1. Considering the following table, write SQL query to display the Last Name of customers who...

 

Transcribed Image Text:

1. Considering the following table, write SQL query to display the Last Name of customers who rented movies for 5 days or more? Customers CustID LastName FirstName Rentals CustID Movie Title CkoutDate Duration 2. 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) a) Find those manufacturers that sell Laptops, but not PC's. b) Find the printers with the highest price. (Use subquery) c) Find, for each different speed, the average price of a PC. 1. Considering the following table, write SQL query to display the Last Name of customers who rented movies for 5 days or more? Customers CustID LastName FirstName Rentals CustID Movie Title CkoutDate Duration 2. 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) a) Find those manufacturers that sell Laptops, but not PC's. b) Find the printers with the highest price. (Use subquery) c) Find, for each different speed, the average price of a PC.