Instructors at a dance studio give both private and group dancing lessons. A student would pay $80 for a private lesson, or $25 for a group lesson. Each private lesson is taught by only one instructor, but each group lesson will have at least two instructors and maybe more. The instructors keep 60% of the fees paid by the students, and the other 40% go to the studio. For a group lesson, the instructor's 60% is split evenly among the instructors. For example, for a group lesson of 12 students and 2 instructors, each instructor will get $90.

The following is an ER diagram for a database designed to keep track of the information about the instructors, the students, and the lessons. (click on the image to see a larger version):

1. (12pt) Convert the ER diagram into tables, and use CREATE TABLE statements to create these tables in your database. Make sure that you use appropriate data types and data integrity constraints.

2. (5pt) Populate the tables with some test data so that each table has at least two rows.

3. (18pt)  Complete the following queries:

• Find how many lessons (both private and group) instructor Lisa taught in the last month.
• Find how many lessons instructor Lisa and instructor Jen taught together.
• Find the average number of students in a group lesson.
• Find the total amount of fees paid by student Joe.
• Find how much money the studio made in the last month.
• Find how much money instructor Lisa made in the last month.