In-class exercises

1. Use the GL databse in MySQL: user name = 'nobody'', with no password. Get a list of the names and ages of all pets. Also get a list of all the tables present in that database;

2. Get the same list, along with the sex and breed, of just the dogs.

3. Get a list of all dogs whose disposition is good, excellent or docile.

4. Get a list of the owner's first and last name as well as the pet's name, for all the dogs that are less than 5 years old.