Create a query that uses any THREE of the tables (SCHOOL, DEPARTMENT, PROFESSOR, TECHNOLOGY & COURSE tables attached) that includes both an arithmetic and a special operator (either LIKE, IN, EXISTS,...

Create a query that uses any THREE of the tables (SCHOOL, DEPARTMENT, PROFESSOR, TECHNOLOGY & COURSE tables attached) that includes both an
arithmetic
and a
special operator(either LIKE, IN, EXISTS, or IS NULL **do not use BETWEEN) in the conditional expression.

Extracted text: YSQL [jsohn6]> SELECT * FROM SCHOOL; lySQL [jsohn6]> SELECT * FROM DEPARTMENT; SCHOOL_CODE DEPARTMENT_ID | DEPARTMENT_ID | DEPARTMENT_NAME 101 SCHOOL OF MERCHANDISING FASHION DESIGN 101 SCHOOL OF FASHION DESIGN 102 ADVERTISING 102 103| 201|| 202 | SCHOOL OF GRAPHIC DESIGN GRAPHIC DESIGN 103 SCHOOL OF FINE ARTS 201 FINE ARTS SCHOOL OF DESIGN AND TECHNOLOG DESIGN AND TECHNOLOGY 202 rows in set (0.00 sec) MYSQL [jsohn6]> SELECT FROM PROFESSOR; MYSQL [jsohn6]> SELECT * FROM TECHNOLOGY; | PROF_NUM | PROF_LASTNAME PROF_FIRSTNAME COURSE_TYPE | LABTOP_NUMBER 1 | Smith 2 | Banks 3 | Taylor 4 | Smith 6 | Smith 7 | Banks Mary | Jane TECH-100 12345 Hazel TECH-110 67890 Terry TECH-120 13579 | Jenny | Tim 24680 TECH-200 4 rows in set (0.00 sec) 6 rows in set (0.00 sec)


Extracted text: MYSQL [jsohn6]> SELECT * FROM COURSE; | COURSE_TYPE | PROF_NUM | DEPARTMENT_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 Costume Design F | Fundamentals of Luxury Design | F | Fundamentals of Costume Design |F | Fundamentals of Textile Design | F | Advanced Printmaking | Intro to Computer Patterns | Intro to Retail Ecommerce | Fundamentals of Graphic Design | T FASH-100 FASH-110 FASH-120 7| FASH-150 FASH-210 4 | TECH-100 TECH-110 2 4 | 2 | TECH-120 TECH-200 9 rows in set (0.01 sec)