Sql join query to display.

Question

I attached database below and i need a query(i given query below what fields are required).

Thanks in advance.