Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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