Welcome to our SQL Practice for June! New tasks are waiting for you. If you've finished our SQL Basics course or have fundamental SQL knowledge, this is a good way to test your database skills. Are you ready to find some answers to business problems?

Help Jennifer Expand Her Pet Care Business

Nowadays a lot of people have one or more dogs. Sometimes, dog owners go on holiday or take a business trip without their pets. How can these people make sure their dogs are taken care of when they're away?

Jennifer is a vet who loves dogs. She's launched a pet sitting business to care for dogs when their owners are away. But she's also looking to expand her services and include things like dog training. Of course, for Jennifer to do that, she'll need to answer some questions about her business:

• How many dogs fall into a certain size group?
• How many dogs are under a year old?
• Who are her most experienced employees?
• What's the average per-day price for dog care?

Jennifer needs your help to find the answers. If you've finished our SQL Basics course, you know everything you need to get the right data.

Try this SQL Practice and see if you can solve all the exercises. (Hint: In each exercise, you can see a sample of the data. Look in the right-hand menu, under the "Database" tab.)

Let's help Jennifer grow her business!