Question

USING SQL TO RETRIEVE DATA FROM DATABASE AND GENERATE REPORTS BASED ON REQUIREMENTS.

This is using SQL Server Management Studio (SSMS).

Task:

Important: Use one and only one SQL Statement to get results for each of the following items.

Query #                                                                Description

1. List the ID and name of the product(s) that didn’t get ordered by any customer. Use a subquery

Here is an example of the database schema:

Here are the tables created:

ESELECT TOP (1000) [CustomerID] [CustomerNamel [Street] [Cityl IStatel [PhoneNumberl FROM [Projest 2laldbo]. [CUSTOMER T] dbo.CATEGORYT dbo.CUSTOMER T dbo.ORDER T dbo.ORDERLINE_T dbo.PRODUCT T dbo.SUPPLIER_T dbo.SUPPLY T +

Answer 1

Since you have not provided the entire DB schema, I am providing the query by guessing the column names. In case, you need any help, reach out to me via the comments section.

Please find the SQL Query below.

SELECT productID, productName FROM PRODUCT_T WHERE productID NOT IN (SELECT productID FROM ORDER_T);