What are the subject ID, subject name, and the number of available courses for each subject?
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
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
[{'subject_id': 1, 'subject_name': 'Computer Science', 'COUNT(*)': 6}, {'subject_id': 2, 'subject_name': 'Arts', 'COUNT(*)': 4}, {'subject_id': 3, 'subject_name': 'Language', 'COUNT(*)': 5}]