Tell me the number of courses that belong to "Language".
select count(t1.course_name) from courses as t1 join subjects as t2 on t1.subject_id = t2.subject_id where t2.subject_name = "Language"
What are they?
select t1.course_name from courses as t1 join subjects as t2 on t1.subject_id = t2.subject_id where t2.subject_name = "Language"
Tell me the subject ID, name of subject and the corresponding number of courses for each subject, and sort by the course count in ascending order.
select t1.subject_id, t2.subject_name, count(*) from courses as t1 join subjects as t2 on t1.subject_id = t2.subject_id group by t1.subject_id order by count(*) asc