Logo
Question DetailsNormal
$ 30.00
Bellevue BA302 Assignment 10.2 Creating Queries
Question posted by
request

Assignment 10.2 Creating Queries to Answer Questions Due by Saturday(Midnight, CT) of 

 

Week 10 Create queries in PetStore database to answer the following questions: 1- List the customer ID, first name, last name, and phone number for all customers from the city where the cityID is 11368 2- List all female dogs 3- List the ItemID for items with a ListPrice less than $20. 4- List all items with a SalePrice less than $20. There should be no repeating items. 5- In July, which category of merchandise had the highest sales value? Sort results based on category total sales value. 6- In the first half of the year (January – June), from which supplier did the company purchase the least total value of merchandise? 7- In terms of merchandise value, which employee was the best salesperson for the month of March?


Use the SQL view of these queries to copy and paste them in a Word file. Submit your Word file through the Assignment 10. link located in the Week 10 Assignment Folder.Please do not send query outputs, I just need the SQL view of your queries. Do not send the entire database, just send the SQL code of your queries in a Word file. 

Available Solution
$ 30.00
Bellevue BA302 Assignment 10.2 Creating Queries
  • This solution has not purchased yet.
  • Submitted On 09 Aug, 2018 11:48:39
Solution posted by
solution
Assignment 10.2 Creating Queries to Answer Questions Due by Saturday(Midnight, CT) of Week 10 Create queries in PetStore database to answer the following questions: 1- List the customer ID, first name, last name, and phone number for all customers from the city where the cityID is 113...
Buy now to view full solution.
closebutton

$ 629.35