A2000 Solutions interview question

Use SQL to query and extract data from a given table