SQL> run 1 select state, sex, count(*) 2 from marathon 3 group by state, sex 4* ST S COUNT(*) -- - ---------- MO M 5 MA M 127 CT F 10 NJ M 2 PA M 2 MA F 55 FL M 7 NJ F 2 IN F 1 VT F 1 NC F 4 ST S COUNT(*) -- - ---------- CT M 22 VT M 3 RI F 60 NH M 14 IN M 3 FL F 2 NC M 2 DC F 1 NH F 6 RI M 130 VA M 1 ST S COUNT(*) -- - ---------- VA F 1 PA F 2 24 rows selected. SQL> set pagesize 40 SQL> list 1 select state, sex, count(*) 2 from marathon 3 group by state, sex 4* SQL> select state, sex, count(*) as NUM 2 from marathon 3 group by state, sex 4 order by state, sex 5 ; ST S NUM -- - ---------- CT F 10 CT M 22 DC F 1 FL F 2 FL M 7 IN F 1 IN M 3 MA F 55 MA M 127 MO M 5 NC F 4 NC M 2 NH F 6 NH M 14 NJ F 2 NJ M 2 PA F 2 PA M 2 RI F 60 RI M 130 VA F 1 VA M 1 VT F 1 VT M 3 24 rows selected. SQL> list 1 select state, sex, count(*) as NUM 2 from marathon 3 group by state, sex 4 order by state, sex 5* SQL> select state, sex, count(*) as num 2 from marathon 3 group by state, sex 4 order by num 5 ; ST S NUM -- - ---------- VA F 1 VT F 1 IN F 1 VA M 1 DC F 1 PA F 2 NJ M 2 PA M 2 NC M 2 FL F 2 NJ F 2 VT M 3 IN M 3 NC F 4 MO M 5 NH F 6 FL M 7 CT F 10 NH M 14 CT M 22 MA F 55 RI F 60 MA M 127 RI M 130 24 rows selected. SQL> exit