I need someone to query my Oracle database

I need the following queries performed in Oracle SQL:

1. A list of all clubs and their details

2. A list of all meetings, with details, and the name of the clubs that hosted them.

3. A list of current and old subscriptions for a specific club. The details of the members are not required.

4. The average income of all clubs from subscriptions

5. A list of meetings a member attended

6. The fastest time a member achieved for a specific event

7. The average distance jumped at high jump at a specific meeting

8. The members competing in 100m at a specific meeting and the achieved times

9. The three most advertised meetings and which club hosted them.

My database CREATE and INSERT statements are also attached. Also the brief and marking scheme, which needs to be followed.