4. b. C. Create the following queries: List the names of places from which the company sells. Show all columns in the table. Name this query Q1-SELLING-LOCATIONS. a. What is the total sales by location for May 2008, sorted in descending order? Name this query Q2-SALES-MAY2008. (Hint: "Where" clause may be useful) The company has been informed that the tax has been increased to 17.5%. Calculate how much additional tax (i.e. the difference) would have been collected by the store by year. Name this query Q3 - ADDED-TAX.

icon
Related questions
Question
4.
b.
C.
Create the following queries:
a.
List the names of places from which the company sells. Show all columns in the table.
Name this query Q1-SELLING-LOCATIONS.
What is the total sales by location for May 2008, sorted in descending order? Name
this query Q2-SALES-MAY2008. (Hint: "Where" clause may be useful)
The company has been informed that the tax has been increased to 17.5%. Calculate
how much additional tax (i.e. the difference) would have been collected by the store by
year. Name this query Q3 - ADDED-TAX.
Transcribed Image Text:4. b. C. Create the following queries: a. List the names of places from which the company sells. Show all columns in the table. Name this query Q1-SELLING-LOCATIONS. What is the total sales by location for May 2008, sorted in descending order? Name this query Q2-SALES-MAY2008. (Hint: "Where" clause may be useful) The company has been informed that the tax has been increased to 17.5%. Calculate how much additional tax (i.e. the difference) would have been collected by the store by year. Name this query Q3 - ADDED-TAX.
Expert Solution
steps

Step by step

Solved in 4 steps

Blurred answer