Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please write SQL for database 1) From the courses table, list instructor id, course number, course name, semester, and delivery mode for courses that are

image text in transcribed

Please write SQL for database

1) From the courses table, list instructor id, course number, course name, semester, and delivery mode for courses that are offered online in fall. Save the query as Q1 2) From the courses table, list instructor id, course number, course name, semester, and delivery mode for courses whose course number is between 100 and 110 and are offered in spring. Save the query as Q2 3) From the courses table, list instructor id, course number, course name, semester, and delivery mode for the courses that are offered in spring and course number is between 100 and 105 or 120 and 130 . Save the query as Q3 4) From the product table, list products that contains \& in their product name and their cost is greater than $2,000. Save the query as Q4 5) Add fields of id, incoming, and outgoing for both q1data and q3 data to make a one table. Save the query as Q5 6) Using the instructor table, List instructor last name and first name, adding a field computing (age age age) /3+ square root of salary -1300 as newNum. Make the newNum accurate to two decimal places. (Hint: use round (computation, 2)) Save the query as Q6 7) Using the instructor table, List instructor id, last name, first name, and salary whose salary is 1.5 times above the minimum. Save the query as Q7 8) Using the instructor table, List instructor id, last name, first name, and salary whose salary is above the average and department code starting with c. Save the query as Q8

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Information Systems Management

Authors: Barbara McNurlin

8th Edition

0132437155, 9780132437158

More Books

Students also viewed these General Management questions

Question

Personal role: This consists of service to family and friends.

Answered: 1 week ago

Question

The role of life: It consists of your own service to yourself.

Answered: 1 week ago