Answered step by step
Verified Expert Solution
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
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 Q8Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started