Display all lecturers groups by their name with their name and the number of courses they have. * You must use group by. You may use joins.

There is a database with student information system. Tables are given be- low. student_id PRIMARY KEY student number TEXT student student_name student surname TEXT TEXT Thomas Rhodes Lam Thompson Fuller Cherry 1 2 3 6063 2176 2945 gradebook_id PRIMARY KEY 1 lettergrade_id FOREIGN KEY gradebook student_id course.id FOREIGN KEY FOREIGN KEY 1 1 6 1 20 4 2 8 2 3 lettergrade lettergrade_id letter PRIMARY KEY TEXT 1 A 2 A- 3 B+ average DOUBLE 4. 3.7 3.3 lecturer_id FOREIGN KEY course_id PRIMARY KEY 1 2 3 course course.name AKTS TEXT INT UNSIGNED Calculus I 8 Calculus II 9 Physics I 8 4 9 9 lecturer_id PRIMARY KEY lecturer lecturer_name TEXT Colt Colon Bennett Frey Haley Swanson 1 lecturer_surname TEXT Tyler Solis Munoz 2 3