Database Queries

1. List all clients who have been under contract for past three months.

2. List names of clients who have at least two houses under contract.

3. List all employees who have worked over 50 hours and were paid cash in the month of september (paid monthly).

4. List houses that have a yearly contract and included more than one additional service.

5. List the houses worked on the date 3/6/18 and all employees who worked those houses.

6. List all trucks that hold only tools made from 'Honda'

7. List all clients who's contract has a monthly fee of $100 or more.

8. List all employees who worked in specific car on 3/1/18 on route #4.

9. List the second most expensive contract

10. List all the employees who worked with John Doe on dates between 3/1/18 and 3/5/18.