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
- How many and which boats can seat more than 9 people
- Identify boat id, boat type
- How many and which boats can sleep more than 5 people
- Identify boat id boat type and ……..
- Which boats are older than 15 years
- Identify fields to display
- How many provide the cheapest boat to rent per day
- Identify boat id boat type and cost
- how many provide the most expense boats to rent per day
- Identify boat id boat type and cost
- Which is the biggest boat?
- Which is the smallest boat?
- Which is the oldest boat?