# 1. Show all the animals (id, name, sex) prepare query1 from 'select id, name, sex from animal'; execute query1; # 2. Show all the animals by ? race_id (id, name, sex, dob, race_name) prepare query2 from 'select animal.id, animal.name, animal.sex, animal.dob, race.name from animal join race on race.id = animal.race_id where race_id = ?'; set @r_id = '1'; execute query2 using @r_id; # Show all the animals by ? race_id and ? species_id (id, name, sex, race_name, species_name) prepare query3 from 'select animal.id, animal.name, animal.sex, animal.dob, race.name, species.current_name from animal join race on race.id = animal.race_id join species on species.id = animal.species_id where animal.race_id = ? and animal.species_id = ?'; set @r_id = 1, @s_id = 1; execute query3 using @r_id, @s_id; # 4. Which specie has less than ? males and ? females (id, name, sex, race_name, species_name) wher