Question: Basic SQL Use the following schema to answer the queries below using SQL DEVICE [ dno , dtype, price] PROVIDER [ pno , pname, web]

Basic SQL Use the following schema to answer the queries below using SQL

DEVICE [dno, dtype, price] PROVIDER [pno, pname, web] SERVICE [dno, pno, servicedate]

SERVICE.dno references DEVICE.dno SERVICE.pno references PROVIDER.pno

bold is underline.

a) Find the dno for the most expensive device

b) Find all providers that have the work fast in the name

c) Find the number of different device types (dtype)

d) Give all details of devices with price more than $400

Advanced SQL

a) Which provider has serviced all devices that provider with pno 24 has also serviced

b) Which device has the highest average price

c) List providers (PNo) who have only serviced devices with dtype RouterX

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!

Q:

oracle sql statement help. I will upvote a clear, detailed response. Thank you!! more joins (inner and outer), subqueries and other SQL issues You are suggested to adopt a user friendly prefix string...

Q:

Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...

Q:

ISDS 3110: Data and Information Management LAB #2: Basic SQL Use the tables: customers, orders, and payments in the classicmodels schema to create queries to answer the following questions/taks....

Q:

BASIC SQL. Consider the following schema: Suppliers ( sid: integer, sname: string, address: string ) Parts ( pid: integer, pname: string, color: string ) Catalog ( sid: integer, pid: integer, cost:...

Q:

ISDS 3110: Data and Information Management LAB #2: Basic SQL Use the tables: customers, orders, and payments in the classicmodels schema to create queries to answer the following questions/taks....

Q:

Use the following comparative figures for Apple and Google. Key Figures Net income (in millions) Cash dividends declared per common share Common shares outstanding (in millions) Weighted-average...

Q:

Need an ER Diagram created based on the below criteria modeled in SQL. Use the following business rules to create a single Entity-Relationship Model using the SQL Data Modeler software. Show all...

Q:

Please dont copy and paste. Consider the following relational database schema. First, write CREATE TABLE and INSERT INTO (three-five tuples per relation) statements. Second, write basic SQL queries...

Q:

Create a full contract with all the appropriate headings and provisions that you can prepare based on the information that is provided below. Also use notations to identify any source from which you...

Q:

Create a full contract with all the appropriate headings and provisions that you can prepare based on the information that is provided below. Also use notations to identify any source from which you...

Q:

If you buy a new car and try to sell it in the first yearindeed, in the first few weeks after you buy itthe price that you get is substantially less than the original price. Use your knowledge about...

Q:

Write a report to explain the conflict management theories and techniques at the interpersonal, team, and organizational levels throughout organizational downsizing. Evidence of this application will...

Q:

As the CM , it is critical that your project documentation is q , , and Financial, analytical, diagnostic Financial, accurate, technical Factual, accurate, timely Focused, accurate, diagnostic

Q:

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

Q:

Explain the qualities of effective leaders in service organizations.

Q:

Understand why customers are loyal to a particular service firm.

Q:

Appreciate why it is so important for service firms to target the right customers.