Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1. Display all the information for all stores whose RegionID value is C. 2. Display CustomerID and CustomerName for all customers whose CustomerName begins
1. Display all the information for all stores whose RegionID value is C. 2. Display CustomerID and CustomerName for all customers whose CustomerName begins with a letter T. 3. Display the ProductID, ProductName, and ProductPrice for products with a Product Price of $100 or higher. 4. Display the ProductID, ProductName, and Product Price for products that were sold in the zip code 60600. Sort the results by ProductID. 5. Display the TID, CustomerName, and TDate for sales transactions involving a customer buying a product whose ProductName is Easy Boot 6. Display the ProductID, ProductName, ProductPrice, and VendorName for allproducts. Sort the results by ProductID. Submission method: 1. 2. 3. Download the output of each query as a .csv file. Then, copy the result pages from the csv files into sheets of a single .xlsx (Excel) file. Submit the Excel file
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started