Answered step by step
Verified Expert Solution
Link Copied!

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

image

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Systems Introduction to Databases and Data Warehouses

Authors: Nenad Jukic, Susan Vrbsky, Svetlozar Nestorov

1st edition

978-1943153190, 1943153191, 978-0132575676

More Books

Students also viewed these Programming questions

Question

How a member of council can join union?

Answered: 1 week ago

Question

How does the concept of hegemony relate to culture?

Answered: 1 week ago