Question
I need help on this database SQL questions refer to the table given. Thank you 1) PetStore: How many cities in the continental US are
I need help on this database SQL questions refer to the table given. Thank you
1) PetStore: How many cities in the continental US are North of the average latitude and south of this average latitude. Hint - Use a nested query to calculate the average. Use this result to determine the number that are larger the average. Repeat for smaller. Then use a set operation to combine results.
2) Which PetStore employee sold the most merchandise by value in June. Hint Organize results with largest on top?
3) Which supplier has received the most money from the PetStore (total value) for dog merchandise?
4) Which suppliers did the pet store NOT buy merchanidise from during August?
5) List the states that the PetStore does NOT have customers in. Show only one result per state. There is some bad data with a null state value, so filter these out.
AdoptionGroup Animal AdoptionlD AdoptionSource ContactName ContactPhone 0 AnimalID Breed DateBorn Category Registered Employee EmployeelD LastName FirstName Category Category Registration ty Supplier SupplierlD ContactName 2 Imageheight ImageWidth ZIPCode one SalelD Donation AreaCode Population1990 Population1980 TaxPayerlD DateHired DateReleased ManagerlD EmployeeLevel SalelD SaleDate EmployeelD CustomerlD Customer CustomerlD Phone FirstName LastName Latitude Longitude ress ZIPCode MerchandiseOrder PONumber OrderDate ReceiveDate SupplierlD EmployeelD ShippingCost Orderltem PONumber ItemlD Merchandise Saleltem SalelD ItemID Description QuantityOnHand ListPrice SalePrice AdoptionGroup Animal AdoptionlD AdoptionSource ContactName ContactPhone 0 AnimalID Breed DateBorn Category Registered Employee EmployeelD LastName FirstName Category Category Registration ty Supplier SupplierlD ContactName 2 Imageheight ImageWidth ZIPCode one SalelD Donation AreaCode Population1990 Population1980 TaxPayerlD DateHired DateReleased ManagerlD EmployeeLevel SalelD SaleDate EmployeelD CustomerlD Customer CustomerlD Phone FirstName LastName Latitude Longitude ress ZIPCode MerchandiseOrder PONumber OrderDate ReceiveDate SupplierlD EmployeelD ShippingCost Orderltem PONumber ItemlD Merchandise Saleltem SalelD ItemID Description QuantityOnHand ListPrice SalePrice
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started