Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribedimage text in transcribed

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Repairing And Querying Databases Under Aggregate Constraints

Authors: Sergio Flesca ,Filippo Furfaro ,Francesco Parisi

2011th Edition

146141640X, 978-1461416401

More Books

Students also viewed these Databases questions