MYSQL [jsohn6]> SELECT • FROM COURSE;| COURSE_TYPE_CODE || COURSE_TYPE | PROF_NUM | DEPARTMENT_ID | COURSE_TITLE| COURSE_DESCRIPTION101 | Costume Designs101 | Couture Fashion101 | Costume Designs101 | Textile Designs201 | Fine Arts103 | Computer Patterns103 | Web Retail103 | Web Design202 | Design with Technolo | Intro to Computer DesignFundamentals of Costume Design | F| Fundamentals of Luxury Design | F| Fundamentals of Costume Design | F| Fundamentals of Textile Design | FAdvanced PrintmakingFASH-100FASH-1103 |FASH-120FASH-1507|4 |FASH-210TECH-100Intro to Computer Patterns| Intro to Retail Ecommerce| Fundamentals of Graphic Design | TTECH-110TECH-1204TECH-2002> 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 | Smith2 | Banksз| Таylor4 | Smith6 | Smith7 | Banks| Mary| Jane| Hazel| Terry| Jenny| TimTECH-1001234567890 |13579 |24680 |TECH-110TECH-120| TECH-2004 rows in set (0.00 sec)6 rows in set (0.00 sec)

Question
Asked Dec 11, 2019
18 views

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. 

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)
help_outline

Image Transcriptionclose

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)

fullscreen
check_circle

Expert Answer

Step 1

Query:

SELECT COURSE.COURSE_TITLE, COURSE.COURSE_DESCRIPTION, COURSE.COURSE_TYPE_CODE FROM COURSE INNER JOIN TECHNOLOGY ON COURSE.COURSE_TYPE = TECHNOLOGY.COURSE_TYPE WHERE TECHNOLOGY.LABTOP_NUMBER NOT BETWEEN 13320 + 1 AND 25500 +1;

Step 2

Explanation:

Here, the arithmetic operator is “+”

Special operator is “NOT BETWEEN”

The above query is used to join the “COURSE” and “TECHNOLOGY&rd...

Want to see the full answer?

See Solution

Check out a sample Q&A here.

Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.
Tagged in

Engineering

Computer Science

Databases

Related Computer Science Q&A

Find answers to questions asked by student like you
Show more Q&A
add
question_answer

Q: Which program is used to configure IPsec between two computers?

A: The IPsec can be configured between two computers on Windows Firewall with Advanced Security. Howeve...

question_answer

Q: Compiler returning errors with calculations and declarations. Screenshot of File.txt included.  ...

A: The code is working fine as I have tested it and the Output is attached at the end.Code://importing ...

question_answer

Q: - Create a new table called CLERKS based on EMP table so that it contains all the clerks in EMP

A: PROGRAM INSTRUCTIONS:Create two database tables ‘EMP’ and ‘DEPT’ and declare all required attributes...

question_answer

Q: I need help writing a java object oriented code using threads methods. Thank you

A: Program:import java.util.*; public class Main{public static void main(String[] args){try{ final Thre...

question_answer

Q: What are the four ways in which organizations can implement a system conversion?

A: Direct Conversion: The implementation of the new system is known as direct conversion and the discon...

question_answer

Q: Write a program that promotes the user to enter the number of students and each student's name and s...

A: The java program and the approach that prompts the user to enter the names and the scores of the stu...

question_answer

Q: The following words have three consecutive letters that are also consecutive letters in the alphabet...

A: Create a java Class StringSlicerCreate methods fillList and displayList in StringSlicer classIn main...

question_answer

Q: Device registration is a feature that allows non domain-joined devices to access claims-based resour...

A: presented with a logical address that are part of byte and programmable bit. To achieved programming...

question_answer

Q: in c++  Given the following, use a for loop to load the array with user input (include a prompt ...

A: Program Algorithm-STARTStep1: Import the essential headersStep2: Define the main function.Step3: Dec...