Question: MySql Database,, Please Answer all Questions. Make sure to put subquery also 6.3.9 Exercises for Section 6.3 Exercise 6.3.1: Write the following queries, based on

MySql Database,,

Please Answer all Questions. Make sure to put subquery also

MySql Database,, Please Answer all Questions. Make sure to put subquery also

6.3.9 Exercises for Section 6.3 Exercise 6.3.1: Write the following queries, based on the database schema Product (maker, model, type) PC(model, speed, ram, hd, price) Laptop (model, speed, ram, hd, screen, price) Printer (model, color, type, price) of Exercise 2.4.1. You should use at least one subquery in each of your answers and write each query in two significantly different ways (e.g., using different sets of the operators EXISTS, IN, ALL, and ANY). a) Find the makers of PC's with a speed of at least 3.0. b) Find the printers with the highest price. ! c) Find the laptops whose speed is slower than that of any PC. ! d) Find the model number of the item (PC, laptop, or printer) with the highest price. l e) Find the maker of the color printer with the lowest price. !! f) Find the maker(s) of the PC(s) with the fastest processor among all those PC's that have the smallest amount of RAM

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!