Question: Write the SQL statements that will answer questions a through g based on apart of tables in Pet Store Database as shown below. ANIMAL (

  1. Write the SQL statements that will answer questions a through g based on apart of tables in Pet Store Database as shown below.

ANIMAL ( AnimalID, Name, Category, DateBorn, Gender, Color, ListPrice)

SALE_ANIMAL (SaleID, AnimalID, SalePrice)

SALE(SaleID, Date, EmployeeName, CustomerName, SaleTax)

    1. List all the animal types in the store without duplicate
    1. List all cats with white in color and has a list price of greater than 2000.
    2. Count the number of animals in each category. List in descending order.

    3. List all the animals for each category that contains more than 10.

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!