I need help to add some queries to finish my

I need help to add some  queries to finish my project 

 

Part 2

Create a query that shows the following information: you should have 8 queries and 2 tables in your access database. 

8 queries needed

  1. How many and which boats can seat more than 9 people
    1. Identify boat id, boat type
  2. How many and which boats can sleep more than 5 people
    1. Identify boat id boat type and ……..
  3. Which boats are older than 15 years
    1. Identify fields to display
  4. How many provide the cheapest boat to rent per day
    1. Identify boat id boat type and cost
  5. how many provide the most expense boats to rent per day
    1. Identify boat id boat type and cost
  6. Which is the biggest boat?
  7. Which is the smallest boat?
  8. Which is the oldest boat?