Question: 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

Please write SQL for database 1) From the courses table, list instructor

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!