I need help on this database SQL questions refer to the table given. Thank you

PetStore: For each zipcode calculate the total population of cities in New York (using population 1990)

1) PetStore: How many animal friends does the PetStore have.

2) PetStore: Who is the newest employee. Hint - Organize by date hired and limit results to one row.

3) 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

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

5) What is the average sale price of bicycles sold in California in 2013

6) 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 ZIPCode