Postgres 14

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table yourtable (
title varchar(30),
size int,
count int
)
insert into yourtable
(title, size, count) values
 ('First',	3,	14)
,('First',	5,	3)
,('Second',	2,	5)
,('First',	2,	10)
,('Third',	3,	10)
,('Second',	3,	4)
,('Third',	2,	9)
,('Third',	5,	11)
,('Second',	5,	4)
9 rows affected

SELECT
  q.title AS "Title"
, q.size AS "Size"
, q.count AS "Count"
FROM
(
   SELECT t.title, t.size, t.count
   , SUM(t.count) OVER (PARTITION BY t.title) AS TotalCount
   FROM yourtable t
) q
ORDER BY q.TotalCount, q.title, q.size


Title
Size
Count


Second
2
5

Second
3
4

Second
5
4

First
2
10

First
3
14

First
5
3

Third
2
9

Third
3
10

Third
5
11

Title	Size	Count
Second	2	5
Second	3	4
Second	5	4
First	2	10
First	3	14
First	5	3
Third	2	9
Third	3	10
Third	5	11