The query groups the DEPARTMENT_ID, based on PROF_NUM count's that are more than 1 MYSQL [jsohn6]> SELECT COUNT ( PROF_NUM) , DEPARTMENT_ID ->FROM COURSE ->GROUP BY DEPARTMENT_ID -> HAVING COUNT (...

Did I correctly perform the SQL query below (photo attached):

A query that contains the GROUP BY clause, one of the aggregate functions, the WHERE statement, and the HAVING operator.

Extracted text: The query groups the DEPARTMENT_ID, based on PROF_NUM count's that are more than 1 MYSQL [jsohn6]> SELECT COUNT ( PROF_NUM) , DEPARTMENT_ID ->FROM COURSE ->GROUP BY DEPARTMENT_ID -> HAVING COUNT ( PROF_NUM) >1; COUNT (PROF_NUM) | DEPARTMENT_ID | 4 101 з | 103 2 rows in set (0.01 sec)


Extracted text: MySQL [jsohn6] > SELECT * FROM COURSE; | COURSE_TYPE | PROF_NUM | DE PARTM ENT_ID | COURSE_TITLE | COURSE_DESCRIPTION COURSE_TYPE_CODE 101 Costume Designs 101 Couture Fashion 101 Costume Designs 101 Textile Designs 201 Fine Arts 103 Computer Patterns 103 Web Retail 103 Web Design 202 Design with Technolo | Intro to Computer Design |Fundamentals of Cost ume Design F Fundamentals of Luxury Design | F Fundamentals of Costume Design F Fundamentals of Textile Design | F F T T | Fundamentals of Graphic Design | T | T 1 1 | FASH-100 FASH-110 FASH-120 3 7 FASH-150 Advanced Printmaking | Intro to Computer Patterns |Intro to Retail Ecommerce FASH-210 7 TECH-100 4 ТЕCH-110 TECH-120 4 TECH-200 2 9 rows in set (0.01 sec)