CMIS 320 Name:_____________________ Create and populate the modified pet table by running the script file pet2.sql that is on the class web site in the "DBs directory" and then create queries to answer the questions below. Download the pet2.sql to your cmis320 folder. A .sql file is a text file, so it can be viewed in Notepad or a web browser. Notice that it contains SQL statements. It shows how to run itself: either by using the 'source' command (telling mysql to run the statements that are in an external file) or by running mysql redirecting its input to come from a file. It (re)creates database menagerie2 and table pet. pet is the same old pet table but with two additional numeric fields: weight and cuteness. With the pet table execute the following queries. Save the queries and their resultsets by copying and pasting into a text file copy of this file open in a text editor such as Notepad. The query should exactly answer the question (i.e. provide the precise information requested). 1- all the pets and all their attributes. -----> paste the SQL statement and resultset here in place of this line. 2- Benny's pets. 3- non-cats 4- the name, species, and DOB of all the pets. 5- the name, species, and DOB of the female pets. 6- pets born before 1995 6b- pets born in 1994, 1995, 1996, or 1997 (use BETWEEN) 7- cats and dogs 8- neither cats nor dogs 9- female cats and (female) dogs 10- the species of pets (no repeats!) 11- the distinct owners of female cats and (female) dogs 11b- distinct combinations of owners and species 12- all the pets listed in owner order 13- all the pets listed in owner order by name order (owner as primary sort, name as secondary sort) 14- all the pets listed in age order, youngest first 17- the DOB and name (in that column order) of all the pets listed in age order, oldest first, 18- the name,owner,DOB of all the pets listed in name order 20- pets of unknown sex 21- pets who have died 22- pets whose names start with a 'C' 23- pets whose owners have 5 character names 24- pets whose owners have at least 5 character names 25- pets whose names do not contain a 'y' 26- the number of records 27- number of cats 28- number of species 29- number of pets that are neither cats nor dogs - the AVG(), MIN(), MAX(), and SUM() aggreagate functions are designed to work with numeric columns but can be applied in some cases to string and data columns: 30- the min name, i.e. the first in alphabetical order 31- the DOB of the youngest pet 32- number of pets per species (hint: group by) 32a- sum of the weights of pets per owner (i.e. if owner has to carry all his pets, how much would that be) 32b- average cuteness of each sex 33- number of pets per owner, per species 34- name,weight,cuteness and cuteness per kilogram of each pet 34a- "cuticality" is a new scientific measure for pets. It is the square root of the cuteness per kilogram of a pet. use the SQRT() function. use a column alias. name, cuticality of each pet. 34b- smallest cuticality value