Question: Consider the following database schema. Write SQL queries to solve each task. Q 1 : List the product maker and type for product model 1

Consider the following database schema. Write SQL queries to solve each task.
Q1: List the product maker and type for product model 1001,2004 and 3006.
Q2: List all Laptop model, speed and price. Display the highest price on the top (Hint: order by)
Q3: List Printer model, type, price and add a new column 'color printer' in display result to show 'Yes' as a return value if it is a color printer, 'No' if it is not a color printer. Display the final result with order by printer type. (Hint: case statement, order by)
Q4: List PC model, speed and price, which the price is between 700 and 2000.
 Consider the following database schema. Write SQL queries to solve each

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 Databases Questions!