Proof of Testing SQL Queries Query 1 SELECT `memberName`,

Proof of Testing
SQL Queries
Query 1
SELECT `memberName`, `MemberType`, `ContactMobile`, `Email` FROM `TeamMember`
WHERE
Country = 'Australia';
Query 2
Select Countries.Country, COUNT(Swimmers.`TeamMemberID`) From
Swimmers inner join TeamMember on TeamMember.TeamMemberID =
Swimmers.TeamMemberID
inner join Countries on countries.Country = TeamMember.Country
GROUP BY Countries.Country;

Query 3
SELECT (Events.QualifyingTime - EventRegistration.QualifyingTime), Events.*,
EventRegistration.QualifyingTime, TeamMember.memberName, TeamMember.Country,
TeamMember.ContactMobile, TeamMember.Email FROM `Events`
Inner Join EventRegistration on EventRegistration.EventName = Events.EventName
Inner Join Swimmers on Swimmers.SwimmerID = EventRegistration.SwimmerID
Inner Join TeamMember On TeamMember.TeamMemberID = Swimmers.TEamMemberID
Where (Events.QualifyingTime - EventRegistration.QualifyingTime) < 0;
Query 4
SELECT TeamMember.*, MedicalOfficer.* FROM
MedicalOfficer inner join TeamMember on MedicalOfficer.TeamMemberID =
TeamMember.TeamMemberID

Order by MedicalOfficer.`Specification`;
Query 5
SELECT `RaceName`, `EventName`, `RaceDay`, `StartTime`, `Location` FROM `Race`
Where `EventName` = '50m Freestyle - Women'
Order by `RaceName`;
Query 6