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 (
- 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)
-
- List all the animal types in the store without duplicate
-
- List all cats with white in color and has a list price of greater than 2000.
-
Count the number of animals in each category. List in descending order.
-
List all the animals for each category that contains more than 10.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
