Database query formation

I need you to develop some query for me and explain me also . I have some schema details and data you need to create a table in your system then perform query .