Start by reviewing the Database Design and Implementation Project: Perfect Paws Pet Salon Entity Relationship Diagram (ERD) and Data page.
Either submit a link to LiveSQL or copy the SQL code into the submission box.
Use the clients, client_phone, and phone tables to retrieve the owners’ first names, last names, phone numbers, and phone types for all clients.
Use an aggregate function to calculate the average service price.
Use the appointments, appt_service, and services tables and an aggregate function to calculate the total cost of each appointment.
Use the Clients, Dogs, Appointments, appt_services, and services tables to retrieve the client’s first name, last name, dog’s name, appointment date, total duration, and total cost.
