Write queries in MySql to do the following tasks: (just write the needed queries, no need for specific item name in it)

1- Find a DVD with a specific movie on it.

2- Find the number of employees CV has.

3- How often each DVD rented.

4- List all customers from a specific city.

5- List all payments in a specific period.

6- List customers who owe some money.

7- List payments by a specific customer.

8- List purchases by a certain employee.