Scribd
Upload
8 views2 pages

Order and Supplier Data Insights

Uploaded by

milanchanda207
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
8 views2 pages

Order and Supplier Data Insights

Uploaded by

milanchanda207
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Question: What is the Supplier Name for Order ID 3?

 Answer: Supplier 3

Question: What is the Product Category for Product Name "Widget F"?

 Answer: Category 1

Question: What is the Delivery Date for Order ID 5 and Product Name "Widget E"?

 Answer:

Question: What is the Total Cost for Order ID 2 and Quantity Ordered 200?

 Answer:

Question: What is the Unit Price of Product Name "Widget H" across Supplier Names?

 Answer:

Question: What is the Delivery Status for Order ID 9 and Delivery Date "2024-02-07"?

 Answer: Pending

Question: Filter orders delivered by Supplier Name "Supplier 3" within date range
2024-01-15 to 2024-01-28.

 Answer: Order ID 3 and Order ID 8

Question: Extract records for orders with Quantity Ordered greater than 300 and
Payment Status as "Paid."

 Answer: Order ID 6, Order ID 7, Order ID 17, Order ID 23, Order ID 27

Question: What is the Warehouse Location for Order ID 10 and Product Category
"Category 3"?

 Answer: Warehouse 2

Question: What is the Customer Name for Order ID 4?

 Answer: Customer 4

Question: What is the Payment Status of Order ID 7?

 Answer: Paid

Question: Determine the Shipping Method for Order ID 10 and Region "West."
 Answer: Air

Question: Find the Quantity Delivered for Product Name "Widget G" and Delivery
Status "Delivered."

 Answer:

Question: Filter orders where Quantity Delivered is less than Quantity Ordered.

 Answer: Order ID 2, Order ID 5, Order ID 6, Order ID 8, Order ID 11, Order ID 12,


Order ID 13, Order ID 14, Order ID 15, Order ID 16, Order ID 17, Order ID 18,
Order ID 19, Order ID 20, Order ID 21, Order ID 22, Order ID 23, Order ID 24,
Order ID 25, Order ID 26, Order ID 27, Order ID 28, Order ID 29, Order ID 30

Question: What is the Supplier Name and Delivery Status for Order ID 6?

 Answer: Supplier 1, Pending

Question: Extract records for orders in Region "North" and Payment Status "Paid."

 Answer: Order ID 1, Order ID 5, Order ID 11, Order ID 19, Order ID 23, Order ID
27

Question: What is the Delivery Date for Product Name "Widget A" and Supplier Name
"Supplier 1"?

 Answer:

Question: Retrieve the Quantity Ordered for Order ID 8 and Customer Name "Customer
8."

 Answer:

Question: What is the Shipping Method and Delivery Status for orders within date range
2024-01-10 to 2024-01-20 and Product Category "Category 1"?

 Answer: Air, Delivered

Question: What is the Customer ID and Order Date for Supplier Name "Supplier 2" and
Region "South"?

 Answer: C2, 2024-01-12

You might also like