Bellevue BA302 Assignment 10.2 Creating Queries

Question # 00709985 Posted By: shortone Updated on: 08/09/2018 10:43 AM Due on: 08/09/2018
Subject Computer Science Topic Algorithms Tutorials:
Dot Image
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.
Dot Image
Tutorials for this Question
  1. Tutorial # 00709870 Posted By: shortone Posted on: 08/09/2018 10:45 AM
    Puchased By: 3
    Tutorial Preview
    The solution of Bellevue BA302 Assignment 10.2 Creating Queries...
    New_Microsoft_Word_Document.docx (14.16 KB) (592 KB)

Great! We have found the solution of this question!

Whatsapp Lisa