1. Write the update statements needed to set the number of members column to the correct value for each club. Use a select query to count the number of members the club has from the club members table and assign this value to the number of members column. There should be an update statement for each club.

2.The club members table has the following columns: the club id, the student id, and the date joined. The club id has the same type as the club id in the clubs table. The student id column has the same type as the student id in the students table. The date joined column is a date. No null values are allowed in any column. The primary key is all three columns. The club id column is a foreign key reference to the club id column in the clubs table. The student id column is a foreign key reference to the student id column in the students table.

3.Create a view that lists the student names who are members of none of the clubs.