How many courses are there in Computer Science?
select count ( * ) from courses as t1 join subjects as t2 on t1.subject_id = t2.subject_id where t2.subject_name = "Computer Science"
Great, and how many courses are there in Arts?
select count ( * ) from courses as t1 join subjects as t2 on t1.subject_id = t2.subject_id where t2.subject_name = "Arts"
Wonderful. And how many courses in Language?
select count ( * ) from courses as t1 join subjects as t2 on t1.subject_id = t2.subject_id where t2.subject_name = "Language"
Great, can you sort a list of Computer Science, Arts, and Language by the number of courses, in ascending order?
select t2.subject_name from courses as t1 join subjects as t2 on t1.subject_id = t2.subject_id group by t1.subject_id order by count ( * ) asc