Database: cre_Students_Information_Systems
Question: For each student, find the student id, student biographical data, and the number of courses he or she takes.
SQL:
SELECT T1.student_id ,  T1.bio_data ,  count(*) FROM Students AS T1 JOIN Classes AS T2 ON T1.student_id  =  T2.student_id GROUP BY T1.student_id