Question: -REQUIRED: Use the alias table technique for each query. For each exercise provide the SQL command as well as query results in your document. If

-REQUIRED: Use the alias table technique for each query. For each exercise provide the SQL command as well as query results in your document. If the results are long, provide a representative sample.

Tables Include:

Categories -CategoryID -CategoryName -Description -Picture

Customers -CustomerID -CompanyName -ContactName -ContactTitle -Address -City -Region - PostalCode -Country -Phone -Fax

Employees -EmployeeID -LastName -FirstName -Title -TitleOfCourtesy -BirthDate -HireDate -Address -City -Region -PostalCode -Country -HomePhone -Extension -Photo -Notes -ReportsTo- Resume -Photo -Graph -Voice

Order Details - OrderID -ProductID -UnitPrice -Quantity -Discount

Orders -OrderID -CustomerID -EmployeeID -OrderDate -RequiredDate -ShippedDate -ShipVia -Freigt -ShipName -ShipAddress -ShipCity -ShipRegion -ShipPostalCode -ShipCountry

Products -ProductID -ProductName -SupplierID -CategoryID -QuantityPerUnit -UnitPrice -UnitsInStock -UnitsOnOrder -ReorderLevel- Discontinued -WebSource

Shippers -ShipperID -CompanyName -Phone

Supplier -SupplierID -CompanyName -ContactName -ContactTitle -Address -City -Region -PostalCode -Country -Phone -Fax -HomePage

Ex. 6. Create a list of all customers from the United States who are located in the states of Washington or Oregon.

Ex. 8. You will need to use the wildcard character ( * ) to answer this question. Create a list of all Products that contain some form of chocolate in the product name. The query should result in more than one record. Be careful what you choose as the text between the wildcard characters. Include the Product Name, Category and Price fields in the results.

Ex. 9. For each order in the OrderDetails table, a product has a unit price and a quantity. Calculate the total revenues for each record (line) in the OrderDetails table. Display only those records with OrderIDs between and including 10400 and 10415. (41 rows should display).

Ex. 10. In Ex. 9 you obtained the total revenues for each specific order (ie., each line or record) in the OrderDetails table. Notice that there are duplicate values in the OrderID column. Aggregate all of these into one unique result. You will need to add the SUM function.

Ex. 11. You may write your own SQL statement. State the question you are obtaining data for and provide the SQL code and results below:

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!

-REQUIRED: Use the alias table technique for each query. For each exercise provide the SQL command as well as query results in your document. If the results are long, provide a representative sample....

REQUIRED: Use the alias table technique for each query. For each exercise provide the SQL command as well as query results in your document. If the results are long, provide a representative sample....

In the first picture I need #10,11,12 and 13 completed. In the second picture I need #14,15,16,17 and 18 completed. I need these queries in SQL view!!!!! Not design or Datasheet view. I do not need...

SIT103 Data and Information Management T2, 2023 Summative assessment task-2: A real-world database design and implementation project Due dates: Part-1: Project proposal, due date: Wednesday 10th May...

-- ************************************************************* -- This script creates the database -- for Labs 4-7 based on OM (Order Management) database -- **REVISED by PRP to remove some orders...

I am working on my final project in an SQL class using MYSQL. I am working my way through it but it is going slow so I think that I may need a little bit of help to finish in time. If I could get a...

The assignment specification The java file JabberServer.java package com.bham.fsd.assignments.jabberserver; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet;...

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

Yinzer Yards is using Pittsburgh as a test market for a new leaf blower which they plan to sell for $93. Yinzer Yards has rented a temporary distribution center for $2,100 and their equipment fees...

Q.5 A pendulum consists of a mass m and a massless stick of lenght l. The pendulum support ocillates horizontally with a position given by x(t) = Acos(wt). What is the general solution for the angle...

The table below shows the state of nature of the future performance of Roam Ltd . GN ( good news ) , and BN ( bad news ) summarize the information content of the current financial statements. Roam...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

12-2 How do information systems support the activities of managers and management decision making?

4. Be prepared to bring samples of the querying/reporting work you have done in your course work and your Microsoft Access proficiency.

3. If you dont have experience with the BI software tools required for the job, use the web to learn more about these tools and how other healthcare companies are using them. Go to websites of major...