Henkel interview question

Write queries with respect to a table