Question: 6. (10 pts) write a SQL query to display the id and name of all the products that belong to the category with id =

6. (10 pts) write a SQL query to display the id

6. (10 pts) write a SQL query to display the id and name of all the products that belong to the category with id = 1.

7. (15 pts) write a SQL query to display the total number of different products belonging to category 1 (categoryId =1), and their average price.

8. (20 pts) write a SQL query to display the id and name of each category, with the number of products that belong to the category.

9. (25 pts) write a SQL query to display the id and name of each category, with the number of products that belong to the category, and make sure ALL categories appear, even those with no products.

The following is a database design about receipts. A receipt represents a sale, and belongs to a store. A receipt has many receipt item's, where each item is for a product, and has a quantity. Each product belongs to exactly one category. The relational schema diagram is shown as follows: Receipt ld IssuedOn Storeld Store Id Name Receipt_Item Receiptld Productld Quantity Product Category ld Name Categoryld Price ld Name

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:

(15 pts) write a SQL query to display the total number of different products belonging to category 1 (categoryId =1), and their average price. (20 pts) write a SQL query to display the id and name of...

Q:

Need questions 4&5 answered, thanks. Homework 2 Write SQL queries for the Pine Valley Furniture Company Database to answer the following questions: 1. Write a SQL query to display order ID and order...

Q:

Need #s 3-5 thanks. Homework 2 Write SQL queries for the Pine Valley Furniture Company Database to answer the following questions: 1. Write a SQL query to display order ID and order date for all the...

Q:

Homework 2 Write SQL queries for the Pine Valley Furniture Company Database to answer the following questions: 1. Write a SQL query to display order ID and order date for all the orders made by...

Q:

con 300 Table : PURCHASE ORDER ORDER_NO AMOUNT ORDER_DATE CUSTOMER_ID SALESMAN_DELIVERY_DATE NAME 1001 05-03-2017 2001 AJI 05-05-2017 1002 200.20 10-07-2017 2002 SHALA 10-10-2017 1003 600 12-06-2017...

Q:

Table Structure: flight COLUMN NAME DATA TYPE SIZE Constraint Fid Number 3 Primary key Fname Varchar 2 10 Splace Varchar 2 8 Dplace Varchar 2 8 Tdate date Seats Number 3 Note: Fid is Fight ID, Fname...

Q:

Task 1: Submit a work proposal for this assignment or before 13/06/2020 (23:59) which must include: Understanding of deliverables -a detail description of deliverables. (3 Marks) General overview of...

Q:

Question from the previous figure Question 3. Write a SQL query in to find the Hire date, Employee title and Department number of employee " TOM HOBSON". Question 4. Write the SQL query to find the...

Q:

This project is designed to touch all aspects of the fundamental concepts of database design and logical/physical data modeling covered in chapters 5 and 6. You are responsible for designing,...

Q:

Describe the purpose of hash functions, message authentication codes and digital signatures, sketching a possible construction for each of them. [12 marks] A funds transfer system authenticates...

Q:

Custom Uniforms produces uniforms. The company allocates manufacturing overhead based on the machine hours each job uses. Custom Uniforms reports the following cost data for the past year: (Click the...

Q:

A large poll showed that 42%, percent of adults approved of their nation's prime minister. Margot wants to test if it is now lower, so she takes a random sample of 1,000 adults in that nation and...

Q:

Donald and Sons manage a product with a 3 . 0 degree of operating leverage. Sales of the product are expected to increase by 1 0 percent next year. What is the expected change in the operating cash...

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:

Are Pay Policies typically the same for all Occupation Groups in an organization?

Q:

Why are Medians sometimes more indicative of Central Tendency than are Averages?

Q:

What types of data are Dimensional Relational Databases in both RDMSs and OLAP Databases primarily designed to hold?