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