Question: Please help me with this database SQL questions refer to the picture below. Thank you in advance. 1) PetStore: What is the name of the

Please help me with this database SQL questions refer to the picture below. Thank you in advance.

1) PetStore: What is the name of the oldest cat on the day it was sold? The oldest is defined as sale date less date born. Hint - Use the datediff() function.

2) 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.

Please help me with this database SQL questions refer to the picture

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!