There may be a more elegant way of doing this, but given that SQL is declarative, we can just give all the information to the database engine and ask it...