Solve_various_queries_using_CSV_data
Use the csv files provided for data and solve the following queries:
-
List the names of all pet owners along with the names of their pets.
-
List all pets and their owner names, including pets that don't have recorded owners.
-
Combine the information of pets and their owners, including those pets without owners and owners without pets.
Hint: We cannot use Full join in mysql. We will use Left Join + union + Right Join. -
List all pet owners and the number of dogs they own.
-
Identify pets that have not had any procedures.
-
Find the name of the oldest pet.
-
Find the details of procedures performed on 'Cuddles'.
-
List the pets who have undergone a procedure called 'VACCINATIONS'.
-
Count the number of pets of each kind.
-
Group pets by their kind and gender and count the number of pets in each group.
-
Show the average age of pets for each kind, but only for kinds that have more than 5 pets.
-
Find the types of procedures that have an average cost greater than $50.
-
Classify pets as 'Young', 'Adult', or 'Senior' based on their age. Age less then 3 Young, Age between 3and 8 Adult, else Senior.
-
Show the gender of pets with a custom label ('Boy' for male, 'Girl' for female).
-
For each pet, display the pet's name, the number of procedures they've had, and a status label: 'Regular' for pets with 1 to 3 procedures, 'Frequent' for 4 to 7 procedures, and 'Super User' for more than 7 procedures.