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.
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.
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.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F935b130b-5988-4a0f-8dda-3ae3c3f19691%2F5a51032d-9c5d-4dc1-ba01-9f05e015037d%2Frt7y7r9_processed.jpeg&w=3840&q=75)
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
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 4 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)