East Anglian Athletic Association
The East Anglian Athletic Association is a group of Athletic dubs based throughout East Anglia.
Each club has a local membership of up to 200 people. The dubs charge an annual subscription to become a member.
Clubs support a wide range of events, e.g.
• All track events, such as 100M, 200M, relays, etc.
• Field events, such as javelin, high jump
• Swimming events
Throughout the summer, most clubs will host at least one athletic meeting, where the other dubs may if they wish participate in competitions. There are also individual prizes for outstanding individual performances, e.g. best 100 metres time, longest javelin throw, etc.
For each meeting, the hosting club produces a list of events that will take place at the meeting. The Athletic association also maintains a list of local newspapers, with an indication of which ones will allow them to advertise the meetings. They always manage to get at least one newspaper to advertise a particular meeting.
Members of the clubs attending the meeting then apply to take part in their chosen events. Forms are available at each club for this purpose.
Required Reports List
In most cases you should include names as well as ID numbers in your output - although computers prefer numbers, people prefer names.
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 Long 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.
Attachment:- Data.rar