Amazon Interview Question

write sql query to extract data from a table