-- Create table for players
CREATE TABLE Player_SA23416680 (
    id INT,
    Pname VARCHAR(20),
    Age INT,
    School VARCHAR(50),
    PRIMARY KEY (id)
);

-- Create table for participation
CREATE TABLE Participate_SA23416680 (
    id INT,
    AID VARCHAR(50),
    PRIMARY KEY (id, AID)  -- Composite primary key if necessary, adjust as needed
);

-- Create table for activities
CREATE TABLE Activity_SA23416680 (
    AID VARCHAR(50),
    Cost INT,
    PRIMARY KEY (AID)
);

-- Adding values into Player_SA23416680
INSERT INTO Player_SA23416680 (id, Pname, Age, School)
VALUES
    (100, 'Ran', 5, 'Museaus college'),
    (101, 'Ruwan', 5, 'Royal college'),
    (102, 'Methmi', 12, 'Museaus college'),
    (107, 'Ran', 6, 'Royal college'),
    (108, 'Ruwan', 18, 'Thurstan college'),
    (110, 'Kevin', 17, 'Royal college'),
    (114, 'Ridi', 12, 'Museaus college'),
    (121, 'Dev', 14, 'Royal college'),
    (122, 'Dev', 12, 'Thurstan college');

-- Adding values into Participate_SA23416680
INSERT INTO Participate_SA23416680 (id, AID)
VALUES
    (122, 'Tennis'),
    (100, 'Swimming'),
    (102, 'Tennis'),
    (110, 'Swimming'),
    (108, 'Sailing'),
    (102, 'Swimming'),
    (121, 'Swimming'),
    (107, 'Sailing'),
    (121, 'Golf');

-- Adding values into Activity_SA23416680
INSERT INTO Activity_SA23416680 (AID, Cost)
VALUES
    ('Tennis', 10),
    ('Swimming', 15),
    ('Sailing', 20),
    ('Golf', 5);

-- Selecting data from Participate_SA23416680
SELECT * FROM Participate_SA23416680;

-- Selecting data from Player_SA23416680
SELECT * FROM Player_SA23416680;

-- Selecting data from Activity_SA23416680
SELECT * FROM Activity_SA23416680;

-- Drop tables at the end (optional)
DROP TABLE Participate_SA23416680;
DROP TABLE Player_SA23416680;
DROP TABLE Activity_SA23416680;