Passengers with Hotmail email addresses

Partnership marketing wants to reach Hotmail users for a themed integration campaign. Return the full record for every passenger whose email is in the hotmail.com domain.

Expected output sample

This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables.

idnameemailagecity
2Liamliam@hotmail.com35Naples
4Noahnoah@hotmail.com40Hamburg

Your query result will appear here

Focus radio
Paused · SomaFM · Fluid