1)
	SELECT `ParkName` FROM `ThemePark` WHERE `Country`= 'UK';

2)
	SELECT `Attractions`.`AttractionName`, `Attractions`.`AttractionCapacity`, `ThemePark`.`City`, `ThemePark`.`Country`
	FROM `Attractions`
	INNER JOIN `ThemePark` 
	WHERE `Attractions`.`ParkCode`=`ThemePark`.`ParkCode`
	AND `AttractionCapacity`>15;

3)
	SELECT `AttractionName`,`AttractionCapacity` 
	FROM `Attractions` 
	WHERE `ParkCode`='FR1001';

4)
	SELECT `AttractionCode`,COUNT(`TicketCode`) as TicketsSold 
	FROM `TicketUse` 
	GROUP BY `AttractionCode` 
	ORDER BY COUNT(`TicketCode`) DESC;

5)
	SELECT COUNT(*) FROM `Tickets` WHERE `TypeCode`='Adult';

6)
	SELECT (COUNT(*)/(SELECT COUNT(`ParkCode`) FROM `ThemePark`)) FROM `Tickets`;
	# This finds the average ticket sales for all locations, IE ticket sales divided by number of locations

7)
	SELECT `EmployeeDOB` , `EmployeeNameFirst` , `EmployeeNameLast` 
	FROM `Employees` 
	WHERE `ParkCode` = 'FR1001';

8)
	SELECT `EmployeeNameTitle`,`EmployeeNameFirst`,`EmployeeNameLast` 
	FROM `Employees` 
	WHERE `ParkCode`='';
	#Assumes that a employee must be associated with a park in order to work on an attraction, which is true for the test data

9)
	SELECT `EmployeeNameFirst`,`EmployeeNameLast`,(Year(CURDATE())-Year(EmployeeHireDate)) AS length 
	FROM `Employees`;

10)
	SELECT DISTINCT `WorkedOn`.`EmployeeCode`,`Employees`.`EmployeeNameFirst`,`Employees`.`EmployeeTelCode`,`Employees`.`EmployeeTelNum`,`Employees`.`EmployeeNameLast`,`Attractions`.`AttractionName` 
	FROM WorkedOn,Employees,Attractions 
	WHERE `WorkDate`='2007-05-18' 
	AND `WorkedOn`.`AttractionCode` = `Attractions`.`AttractionCode` 
	AND `Employees`.`EmployeeCode`=`WorkedOn`.`EmployeeCode`;

11)
	SELECT @empCode:=`EmployeeCode`
	FROM `Employees` 
	WHERE `EmployeeNameFirst`= 'Arif' AND `EmployeeNameLast`= 'Arshad' LIMIT 1;

	SELECT DISTINCT `AttractionName`,`WorkHours`
	FROM `WorkedOn` 
	INNER JOIN `Attractions` 
	ON `Attractions`.`AttractionCode`=`WorkedOn`.`AttractionCode` 
	WHERE `WorkedOn`.`EmployeeCode`=@empCode;

12)
	SELECT (SUM(WorkHours*WorkHourlyRate)) as Pay 
	FROM WorkedOn,Employees 
	WHERE `Employees`.`EmployeeNameLast`='Arshad'
	AND `Employees`.`EmployeeNameFirst`='Arif'
	AND `WorkedOn`.`EmployeeCode`=`Employees`.`EmployeeCode` 
	AND (`WorkDate`='2007-05-22' OR `WorkDate`='2007-05-23');

13.1)
	
	SELECT `EmployeeNameFirst`, `EmployeeNameLast`, SUM(`WorkHours`) as TotalHours,  SUM(`WorkHours`*`WorkHourlyRate`) as TotalPay 
	FROM `Employees` 
	INNER JOIN `WorkedOn`
	ON `Employees`.`EmployeeCode`=`WorkedOn`.`EmployeeCode` 
	GROUP BY `Employees`.`EmployeeCode`;
	# Selects all employees who have worked on attractions, and displays their total hours and total pay 

13.2)
	SELECT `ParkCode` , SUM( `TicketPrice` ) 
	FROM `Tickets` 
	INNER JOIN `TicketTypes` ON `Tickets`.`TypeCode` = `TicketTypes`.`TicketCode` 
	GROUP BY `ParkCode`
	ORDER BY SUM(`TicketPrice`) DESC;
	#Gets the total monies collected through tickets sold in each park, sorted from highest earning to lowest

14)
	DELETE FROM `Employees`,`WorkedOn` USING `Employees` INNER JOIN `WorkedOn`
	WHERE `WorkedOn`.`EmployeeCode`=`Employees`.`EmployeeCode`
	AND `EmployeeNameFirst`='Emma'
	AND `EmployeeNameLast`='Calderdale';

15)
	INSERT INTO ` ThemePark` (`ParkCode` ,`ParkName` ,`Country` ,`City`)
	VALUES
	('AU1001', 'SkiWorld', 'AU', 'Vienna'), 
	('GR5001', 'Roboland', 'GR', 'Athens');

16)
	INSERT INTO `Employees` (`EmployeeNameTitle` ,`EmployeeNameFirst` ,`EmployeeNameLast` ,`EmployeeDOB` ,`EmployeeHireDate` ,`EmployeeTelCode` ,`EmployeeTelNum`)
	VALUES ('Mr', 'Fred', 'Smith', '1980-12-04', '2008-11-04', '0191', '3341713');