Write the appropriate SQL query for each of the following questions:
A) Display ALL the activities organized by the IT club
B) Display the number of students who are acting in each club.
Extracted text: The aim of assignment 1 is to implement a database schema and execute different types of SQL queries in Oracle SQL developer. Given the following relational schema: Student (studid, FirstName, LastName, Email, phoneNumber, DateofBirth, GPA) Club (clubid, ClubName, #studid) MemberOf (#clubid, #studid, joiningDate ) Activities (actid, actdt, place, durationNbHour) Organize (#actid, #clubid , fee) Table name: Student studid Char(9) Primary key FirstName Varchar2(50) NOT NULL LastName Varchar2(50)NOT NULL Email Varchar2(50) NOT NULL, UNIQUE phoneNumber Number(8) NOT NULL, UNIQUE DateofBirth Date NOT NULL GPA Number(1,2) NOT NULL Table name: Club clubID Number(3) Primary key ClubName Varchar2(20) NOT NULL NOT NULL, UNIQUE, Foreign key studid Char(9) Table Name: MemberOf ClubID Number(3) Primary Key, Foreign Key Studid Char(9) Primary Key, Foreign Key joiningDate Date Table Name: Activities Actid Number(3) Primary Key Actdt DATE NOT NULL Place Varchar2(50)INOT NULL durationNbHour Number NOT NULL Table Name: Organize actid Number(3) Primary Key, Foreign key clubID Number(3) Primary key, Foreign key Fee Number(4,2)