Use either a single selection search or a multiple selection search to answer the following questions. You should not need to manually count any items to find the answers to these questions:
1. How many employees are there at the Keilor cafe?
2. How many cooks are employed?
3. How many employees earn less than $550 per week?
4. How many employees were born before 1/1/90?
5. How many employees work over 35 hours per week?
6. How many employees at the Essendon cafe work less than 35 hours per week?
7. How many delivery workers earn more than $400 per week?
8. How many employees at the Richmond cafe were born before 1/1/90?
If you need to find out who earns the most money or who is the oldest employee a sort is the easiest way to do it. Use a Sort request to answer the following questions:
1. Who earns the most income?
2. Who works the least hours per week?
3. Who is the oldest employee?
4. Who is the youngest employee?

8.7 Counting data items

Databases exercise 5