Proof of Testing SQL Queries Query 1 SELECT.

Proof of Testing
SQL Queries
Query 1
SELECT Member.FamilyName, Member.GivenName, Member.`ContactMobile`,
Member.Email
From Member
Inner Join Countries on Countries.CountryCode = Member.CountryCode
Where Countries.CountryCode = 3;
Query 2
Select Countries.CountryCode, COUNT(Swimmers.`SwimmerID`) From
Swimmers inner join Member on Member.MemberID = Swimmers.MemberID

inner join Countries on Countries.CountryCode = Member.CountryCode
GROUP BY Countries.CountryCode;
Query 3
SELECT (Event.MinTime - EventRegistration.QualifyingTime), Event.*,
EventRegistration.QualifyingTime, Member.FamilyName, Member.GivenName,
Member.CountryCode, Member.ContactMobile, Member.Email FROM `Event`
Inner Join EventRegistration on EventRegistration.EventID = Event.EventID
Inner Join Swimmers on Swimmers.SwimmerID = EventRegistration.SwimmerID
Inner Join Member On Member.MemberID = Swimmers.MemberID

Where (Event.MinTime - EventRegistration.QualifyingTime) < 0;
Query 4
SELECT Member.*, MedicalOfficer.* FROM
MedicalOfficer inner join Member on MedicalOfficer.MemberID = Member.MemberID
Order by MedicalOfficer.`Specification`;
Query 5
SELECT `RaceType`, `EventID`, `RaceID`, `StartTime`, `PoolNo` FROM `Race`
Where `EventID` = 4