-- 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;


	--WORKSHEET 09


	--youngest player
	SELECT MIN(age) AS 'Youngest player' FROM Player_SA23416680;

	SELECT COUNT (*) AS ParticipateCount
	FROM Player_SA23416680
	WHERE School = 'Museaus college'

	SELECT AVG(Age) AS AverageAge
	FROM Player_SA23416680 

	SELECT MIN (Cost) as minm
	FROM Activity_SA23416680

	SELECT MAX (COST) AS maxx
	FROM Activity_SA23416680
	WHERE Cost	= (select min (cost) FROM Activity_SA23416680)


	SELECT *
	FROM  Player_SA23416680
	WHERE Age IN (select age from Player_SA23416680 WHERE id IN (100,107))