What is an example of a query that is based on the tables (attached) and includes both an arithmetic and a special operator in the conditional expression. SELECT • FROM COURSE;| COURSE_TYPE_CODE ||...

What is an example of a query that is based on the tables (attached)  and includes both an arithmetic and a special operator in the conditional expression.

Extracted text: MYSQL [jsohn6]> SELECT • FROM COURSE; | COURSE_TYPE_CODE | | COURSE_TYPE | PROF_NUM | DEPARTMENT_ID | COURSE_TITLE | COURSE_DESCRIPTION 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 FASH-100 FASH-110 3 | FASH-120 FASH-150 7| 4 | FASH-210 TECH-100 Intro to Computer Patterns | Intro to Retail Ecommerce | Fundamentals of Graphic Design | T TECH-110 TECH-120 4 TECH-200 2 > rows in set (0.01 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 з| Таylor 4 | Smith 6 | Smith 7 | Banks | Mary | Jane | Hazel | Terry | Jenny | Tim TECH-100 12345 67890 | 13579 | 24680 | TECH-110 TECH-120 | TECH-200 4 rows in set (0.00 sec) 6 rows in set (0.00 sec)