Using Sql Show Breakdown State Number Stores B List Top 5 Shoppers Spent Martin Luther Ki Q37038501

Using SQL

a. Show a breakdown, by state, of the number of stores.

b. List the top 5 shoppers who spent the most on Martin LutherKing Jr. Day in 2000. (Hint: Use SELECT TOP 5 …, date columns canbe found in the table date_dimension)

c. How many customers have visited 2 or more stores in year2000?

d. Count the number of

OR

 

OR