Subqueries lab exercise

Use subqueries to answer these queries.

The row with the youngest pet.

The row with the youngest cat.

The row(s) with pets older than the average (i.e. median) pet age.  

Non-subquery: what is the median birth date?  Which pet's birth is it?


The pets older than Claws.

The pets older than Claws in increasing age order.

The living pets older than Claws in increasing age order.

The name, birth and age in years of the living pets older than Claws
in increasing age order. hint: Sysdate

The pets whose individual weights are more than 25% of the total weight of all the pets:

The pets older than the earliest event.

Owners whose pets have had a lobotomy.