Liquidnet interview question

write a select query for any SQL database