Question: 1. Considering the following table, write SQL query to display the LastName of customers who rented movies for 5 days or more? 2. Write the

1. Considering the following table, write SQL query to display the LastName of customers who rented movies for 5 days or more? 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

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!

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...

Use the Module 4 Project ERD and the tables created for the midterm project to complete the steps listed below. A . Setting Up Your Script ( 5 points ) 1 . Open a text editor to begin writing your...

D . Creating Indexes ( 5 points ) 1 . Create an index on the last name column of the Rental Customers table. E . Creating Synonyms ( 5 points ) 1 . Create a synonym called TU for the TITLE _ UNAVAIL...

--******************************************* -- SECTION 1: Single-Table SQL Queries -- --******************************************* -- 1. Write a query to display customers last names, first names,...

-- SECTION 1: Single-Table SQL Queries --******************************************* -- 1. Write a query to display customers last names, first names, and email addresses. -- Sort your results by...

HERE IS THE TINY VIDEO SCHEMA FOR MYSQL WORKBENCH /* Database Systems, 9th Ed., Coronel/MOrris/Rob */ /* Type of SQL : MySQL */ CREATE SCHEMA IF NOT EXISTS TINY_VIDEO; USE TINY_VIDEO; DROP TABLE IF...

ConAir (CA) commercial airlines company requires you experience in database design and have approached you to assist in the design of their new airline database system. They urgently need to have...

A Case Study : Vine Estate Agency Ltd (VEA) is a licensed estate agent, providing a variety of services such as property management, sales, auction, etc. The following is a brief description of the...

Using MySQL Workbench SELECT commands answer the questions listed below using the Tiny Video schema used in your previous assignment. Submit via the D2L drop box the final SQL script for each...

An interesting exercise that should help you understand how rapidly graphics performance has improved is to go to the Web sites of some of the GPU manufacturers such as NVIDIA ATI and Intel and look...

Why do most successful industrial societies offer patents and copyright protection, even though these protections enable sellers to charge higher prices?

Powder Room Mess. For $ 3 0 0 , 0 0 0 . Wils dgrees to build a new home for Aobert, who is very piciry. Wilis bullds the home to Robert's specifications with one exception. The faucets and Inoleum...

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

ADVANCED ANALYSIS Linear equations for the consumption and saving schedules take the general form C a bY and S a (1 b)Y, where C, S, and Y are consumption, saving, and national income,...

ADVANCED ANALYSIS Suppose that the linear equation for consumption in a hypothetical economy is C 40 .8Y. Also suppose that income (Y ) is $400. Determine (a) the marginal propensity to consume,...

KEY QUESTION Assume that in a particular year the natural rate of unemployment is 5 percent and the actual rate of unemployment is 9 percent. Use Okuns law to determine the size of the GDP gap in...