Lynx Analytics interview question

To write a SQL query without using any built-in functions like sample, for example.