Daisy’s already have some data that they’ve been collecting in spreadsheets. You re-formatted the data a bit and converted them into CSV files. For this assignment, please import the data below into the appropriate tables.
Daisy’s asked if we could create a table that will show all the appointments, sorted by appointment date and time, where it would show the appointment date, the dog owner name and the dog name.
Daisy’s liked the table that you made for the previous assignment. They now are asking if you could make one where it would still show each appointment, sorted by appointment date and time, but this time with the dog groomer’s name and dog’s name associated with each appointment.
The groomers saw the table that you’ve made and asked to make another table similar to that. But this time a list of appointments, sorted by the appointment date and time, but with the groomer name and owner name for each appointment.
Daisy’s asked if you could create a ranking of the most popular dog breeds that are in their database of dogs.
This time, they asked if you could create a ranking of dog breeds in the appointment table that are most frequently occuring.
The manager of Daisy asked if we could create a ranking of groomers that have the most hair cut appointments.
The groomers asked if we could now create a ranking of the dog breeds that have the most dog notes on them.
This time they asked if we could create a ranking for the dog breeds that get the most dog baths.