Completed
Incomplete
Not Attended
Share
In a small, pet-loving community, the local council decided to create a digital pet registry to keep track of all the furry, feathery, and scaly friends in the neighborhood. As the database administrator, you've been tasked with managing this new system. The registry contains information about each pet, including their name, species, age, and owner. Your job is to help the council members and pet owners with various queries and updates to the registry.
Question - 1The council wants to know how many pets are currently registered. Can you help them get this information ?
Question - 2Alice is worried she might have given the wrong age for her cat, Fluffy. Can you help her check Fluffy's current age in the registry?
Question - 3Bob realizes he made a mistake. His dog Buddy is actually 6 years old, not 5. Can you help update this information in the registry and then display Buddy's updated information?
Question - 4Eve's friend Grace just moved to the neighborhood with her turtle, Shelly. Can you help add Shelly to the registry? Shelly is 10 years old, and should have the ID 6. After adding Shelly, please display all pets owned by Grace.
Code Editor
Table Name: pets
| id | name | species | age | owner |
| 1 | Fluffy | Cat | 3 | Alice |
| 2 | Buddy | Dog | 5 | Bob |
| 3 | Tweety | Bird | 1 | Charlie |
| 4 | Nemo | Fish | 2 | David |
| 5 | Hammy | Hamster | 1 | Eve |
>>> Submit Your Query to validate