List each attack type, the animal that committed that type of attack, and the date of the attack, in ascending order by attack type, then by pet within each attack type. There may be some attack types that have never been committed, so please account for that. This query has outer joins. Leave out Null Pets.

SQL Query