count - SQL Student Database -
i having hard time trying display number of classes in column student taking. i have following query not sure if count counting , how display count each student: create view busy_student select first_name, last_name, student.student_id student inner join enrollment on enrollment.student_id= student.student_id group student.student_id, student.first_name, student.last_name having count(*) > 2 create view call busy_student stores concatenated name (first name , last name), student id , count of classes enrolled in, students enrolled in more 2 classes. name columns, full_name, student_id , enroll_num respectively. your select statement should this: select first_name + ' ' + last_name [full_name], student.student_id, count(*) [enrol_num] student inner join enrollment on enrollment.student_id= student.student_id group student.student_id, student.first_name, student.last_name having count(*) > 2
