Question
I need help on this database SQL questions refer to the table given. Thank you 1) PetStore: List all of the fist sorted by breed
I need help on this database SQL questions refer to the table given. Thank you
1) PetStore: List all of the fist sorted by breed
2) PetStore: List all animals born in March
3) PetStore: What is the total value of all dog related merchandize
4) PetStore: What is the largest merchandise quantity on hand. Show a single row result.
5) PetStore: List all of the cities in Arizona with population 1990 great than 10000 organized by zipcode
6) PetStore: For each zipcode calculate the total population of cities in New York (using population 1990)
7) PetStore: How many animal friends does the PetStore have.
8) PetStore: Who is the newest employee. Hint - Organize by date hired and limit results to one row.
9) RollingThunder: What is the profit margin for derailleurs for Road bikes. Search for derailleur in any part of the description. The profit margin is the list price minus the estimated cost
10) RollingThunder: What is the greatest number of components ever installed in one day by one employee. Ignore employee 0 (which means none). Rank from largest to smallest. Hint - Use bike parts table.
11) What is the average sale price of bicycles sold in California in 2013
12) RollingThunder: What is the largest discount percent given on mountain bikes (including full) bicycles sold in Oregon in 2007. The discount can be calculated as the (list price less the sale price) divided by list place
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 Customer TubeMaterial BikeTubes ModelType Tube Name Component Groupl Paint ColorStyle Totallength WaterBottleBr azeOn HeadTubeAngle Manufact urerlD CustomerTrans Category LetterStylelD Datelnstalled TransactionDate StorelD ZIPCode CitylD Quantity Received ReceiveDate Manufacturer Manufacturer Trans WorkArea Manufactu rerlD Manufacturer Name Description ZIPCodeStep 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