Assignment One

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.

Assignment Two

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.

Assignment Three

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.

Assignment Four

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.

Assignment Five

Daisy’s asked if you could create a ranking of the most popular dog breeds that are in their database of dogs.

Assignment Six

This time, they asked if you could create a ranking of dog breeds in the appointment table that are most frequently occuring.

Assignment Seven

The manager of Daisy asked if we could create a ranking of groomers that have the most hair cut appointments.

Assignment Eight

The groomers asked if we could now create a ranking of the dog breeds that have the most dog notes on them.

Assignment Nine

This time they asked if we could create a ranking for the dog breeds that get the most dog baths.