Henkel Interview Question

Write queries with respect to a table