Question: Question 3. Use the baseball database you created in question 2 (now you have two tables) for this assignment. Write SQL queries (please save each

Question 3. Use the baseball database you created in question 2 (now you have two tables) for this assignment. Write SQL queries (please

Question 3. Use the baseball database you created in question 2 (now you have two tables) for this assignment. Write SQL queries (please save each query): (3a). Display the item id, description, on-hand value (UnitsOnHand*Cost), and supplier name of all items. (3b). Display the average selling price of supplier Logo Goods' (we only know this supplier name as the criteria) items. Use Join (3c). Display the average selling price of supplier Logo Goods' (we only know this supplier name as the criteria) items. Use Subquery/Nestedquery (3d). Display the average selling price of supplier Beverage Holders' items (We only know this supplier name as the criteria) (3e). For each supplier name, find a count of different types of items of the supplier name. (3f). Display item id, description, selling price for the item that has the lowest selling price. Note: when you join two or more tables together, don't use INNER JOIN, LEFT JOIN, RIGHT JOIN format, otherwise, you will get 0 point & Baseball X ID Description Cost 1 Baseball Cap $10.15 2 Al Clothes $7.45 3 Beverage Holders $1.85 4 Logo Goods $8.20 5 Jacket $44.75 6 Short $14.95 7 Sport Towel $3.25 8 Sweatshirt $27.45 9 Tee Shirt $9.50 10 Coffee Travel Mug $2.90 (New) $0.00 Units - Selling Price - Code - 30 $18.76 LG 12 $9.00 BH 20 $4.75 BH 8 $10.75 BH 12 $54.95 LG 10 $19.95 AC 24 $6.75 LG 9 $34.95 AC 32 $14.95 AC 11 $3.25 BH 0 $0.00 SupplierName SupplierPhone - Click to Add Logo Goods 517-555-3853 Beverage Holders 317-555-4747 Beverage Holders 317-555-4747 Beverage Holders 317-555-4747 Logo Goods 517-555-3858 Al Clothes 616-555-9228 Logo Goods 517-555-3853 Al Clothes 616-555-9228 Al Clothes 616-555-9228 Beverage Holders 317-555-4747 *

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!

!!!!!DO NOT DO THIS IN SQL!!!! (2a). Create a new table for Suppliers, set the primary key, input data (Note: the supplier data are from Week 1 Assignment). (2b). Change the structure of the original...

**********DO NOT USE INNER JOIN, LEFT JOIN, RIGHT JOIN*********** Results Query Type Query Setup Show/Hide All Acc... o Search... EL Query1 SELECT ItemID, Description, (Cost*Units) AS ['OnHandValue']...

Question 3 . Use the baseball database you created in question 2 (now you have two tables ) for this assignment. Write SQL queries (please save each query): (3a). Display the item id, description,...

Question 2 . Use the Baseball database you created in the first week for this assignment (copy and save as YourLastNameLec3). Now by analyzing the baseball inventory data, we know one table design is...

Please help with step by step Question 2. Use the Baseball database you created in the first week for this assignment (copy the file). Now by analyzing the baseball inventory data, we know one table...

Its management information systems Please follow up all the information whatever is mention. The purpose of the project is to manipulate tables and write SQL queries in order to extract various...

Use the baseball database you created for this assignment (Note: please copy the Access file and paste, give a name like BaseballLec02 ). Create Access queries (each question needs a query, please...

1. Use the baseball database you created for this assignment (Note: please copy the Access file and paste, give a name like BaseballLec02). Create Access queries (each question needs a query, please...

2. Use the baseball database you created (now you have two tables) for this assignment. Write SQL queries: (a). Display the item id, description, and on-hand value (unitsOnhand*cost), supplier name...

I need help making the SQL statements in visual studio 2017 Please read homework carefully svxGS0201 9 1 0/Project%20Task%2075628 1 %29.pdf MGMT 329: Database Management Project Task 7: Requi The...

The ongoing trend toward using fair value has both its supporters and its critics. Briefly explain arguments in favor of and against the use of fair value.

An effective social media policy includes an element that prevents all use of social media during daytime hours. vaguely threatens employees who violate the policy. applies consistent standards...

you just borrowed 1 5 5 , 0 0 0 for 3 5 years at 7 % this ia an amortized laon with equal monthly payments over the life of the loan. how much of the first payment goes to reducing the principle...

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

1. What are some potential legal issues that a trainer should consider before deciding to run an adventure learning program?

7. Determine what feedback is provided to employees.

3. Develop standards to evaluate positions (e.g., competencies, desired experiences, desired knowledge, developmental value).