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) 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)
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) 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)
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
1st Edition
ISBN:9780357392676
Author:FREUND, Steven
Publisher:FREUND, Steven
Chapter8: Working With Trendlines, Pivottables, Pivotcharts, And Slicers
Section: Chapter Questions
Problem 3EYK
Related questions
Concept explainers
SQL
SQL stands for Structured Query Language, is a form of communication that uses queries structured in a specific format to store, manage & retrieve data from a relational database.
Queries
A query is a type of computer programming language that is used to retrieve data from a database. Databases are useful in a variety of ways. They enable the retrieval of records or parts of records, as well as the performance of various calculations prior to displaying the results. A search query is one type of query that many people perform several times per day. A search query is executed every time you use a search engine to find something. When you press the Enter key, the keywords are sent to the search engine, where they are processed by an algorithm that retrieves related results from the search index. Your query's results are displayed on a search engine results page, or SER.
Question
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 in the conditional expression.
![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)](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F78544e10-7946-43ea-b00d-6c8b7ace37d1%2F839f2eab-835c-42f7-bf33-f71c29bf3d10%2Fposbb5b.png&w=3840&q=75)
Transcribed Image 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)
![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)](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F78544e10-7946-43ea-b00d-6c8b7ace37d1%2F839f2eab-835c-42f7-bf33-f71c29bf3d10%2Fswsarf.png&w=3840&q=75)
Transcribed Image 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)
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage