Question: 1) Write a SELECT statement that answers this question: Which artist has a total unit_price greater than the average unit price for all artist witha

1) Write a SELECT statement that answers this question: Which artist has a total unit_price greater than the average unit price for all artist witha unit_price greater than 0? This query uses the items table. A subquery is required. 2) Write a select statement that returns these columns from the order_ details table: a) The order_qty column b) A column that uses the ROUND function to return the order_gty column with 2 d ecimal digits. c) A column that uses the ROUND function to return the order qty column with no d digits. 3) Write a select statement that returns three columns: customer last name from Order_date Shipped_date customers table from orders table from orders table JOINS are required 4) Write a summary query that calculates the total (SUM) unit_price by each artist. Select only those with a total (SUM) unit_price greater than 4. Again see the attached ER diagram. This query uses the items table. 1) Write a SELECT statement that answers this question: Which artist has a total unit_price greater than the average unit price for all artist witha unit_price greater than 0? This query uses the items table. A subquery is required. 2) Write a select statement that returns these columns from the order_ details table: a) The order_qty column b) A column that uses the ROUND function to return the order_gty column with 2 d ecimal digits. c) A column that uses the ROUND function to return the order qty column with no d digits. 3) Write a select statement that returns three columns: customer last name from Order_date Shipped_date customers table from orders table from orders table JOINS are required 4) Write a summary query that calculates the total (SUM) unit_price by each artist. Select only those with a total (SUM) unit_price greater than 4. Again see the attached ER diagram. This query uses the items table

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!

*Using ap SELECT * FROM ap.invoices; SELECT * FROM ap.general_ledger_accounts; SELECT * FROM ap.invoice_line_items; SELECT * FROM ap.vendors; *using MYSQL ap.sql Exercises 1. Write a SELECT statement...

SQL 1. Write a SELECT statement that returns the companyname, address, city and postalcode from the suppliers table where the suppliers ID is also in the products table. Order it by the supplier id...

I need these 6 queries completed . Thank you. /* Query 1 . Write a SELECT statement that returns the same result set as the SELECT statement below, but dont use a join. Instead, use a subquery in a...

MySQL or SQL needed. 1. Write a SELECT statement that returns the same result set as this SELECT statement, but dont use a join. Instead, use a subquery in a WHERE clause that uses the IN keyword....

1. Write a SELECT statement that returns the same result set as this SELECT statement, but dont use a join. Instead, use a subquery in a WHERE clause that uses the IN keyword. SELECT DISTINCT...

Chapter 6 How to code subqueries Exercise Save a TEXT COPY of the query 1. Write a SELECT statement that returns the same result set as this SELECT statement, but dont use a join. Instead, use a...

Chapter 6 Guitar Shop Database How to code subqueries Exercises 1 . Write a SELECT statement that returns the same result set as this SELECT statement, but don t use a join. Instead, use a subquery...

1. Write a SELECT statement that returns the same result set as this SELECT statement, but don't use a join. Instead, use a subquery in a WHERE clause that uses the IN keyword. SELECT DISTINCT...

1. Write a SELECT statement that returns the same result set as this SELECT statement, but don't use a join. Instead, use a subquery in a WHERE clause that uses the IN keyword. SELECT DISTINCT vendor...

2-4 An infinitely long line charge has uniform charge density A per unit length. Using direct integration, find the electric field at a distance r from the line.

Cullumber Inc. purchased land, a building, and land improvements from Kingswood Corporation for a cash payment of $450,000. The assets were on the books of Kingswood for the following amounts: Land:...

Question 3 9 4 pts Leonard and Penny, a married couple, formed the equally owned calendar year PL LLC several years ago. Capital is a material income - producing factor for the LLC . On July 1 of...

4. Using the template projection, draw the most stable conformation of the following non-natural amino acid. 4. Using the template projection, draw the most stable conformation of the following...

Economist John Taylor has suggested that the Fed use the following rule for choosing its target for the federal funds interest rate (r): r = 2% + + 12 (y y*) / y* + 12 ( *), where is the average...

Suppose banks install automatic teller machines on every block and, by making cash readily available, reduce the amount of money people want to hold. a. Assume the Fed does not change the money...

Consider two policiesa tax cut that will last for only 1 year and a tax cut that is expected to be permanent. Which policy will stimulate greater spending by consumers? Which policy will have the...