Question: Use the PetOwners create script to answer these questions. We will use the below area to write our test SQL . * * * *
Use the PetOwners create script to answer these questions.
We will use the below area to write our test SQL
How would you add an age attribute integer
to the Pets table?
Luma was adopted. How would we remove her record from the Owns table?
DELETE
How would you create a new DogBreeds table?
How would you insert Pug to the DogBreeds table?
How would you show the rows of the DogBreeds table to make sure you
inserted Pug successfully?
How would you remove the DogBreeds table?
Show which breedID has the most pets.
Show which pet owner has the highest ID number.
Show the Pets in alphabetical order by Name
What are the breeds of all the pets?
Bonus! How many pets do each owner have?
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
