Q2 Answer Q2(a) and Q2(b) based on Table 1, Table 2, Table 3 and Table 4. TARI.F. 2. rottNTRT F.S tahle. 2 (a) Examine a

[answerhappygod]

Q2 Answer Q2 A And Q2 B Based On Table 1 Table 2 Table 3 And Table 4 Tari F 2 Rottntrt F S Tahle 2 A Examine A 1 (1.13 MiB) Viewed 31 times

Q2 Answer Q2(a) and Q2(b) based on Table 1, Table 2, Table 3 and Table 4. TARI.F. 2. rottNTRT F.S tahle. 2 (a) Examine and write the correct syntax for each of the following Structured Query Language (SQL) statement. (i) Select count(GivenName), min (GivenName), max (GivenName), avg (GivenName), sum(GivenName) from competiTORS; (3 marks) (ii) SELECT * from EVENTS where Gender = WOMEN; (3 marks) (iii) Select Cp.GivenName, Cy.CountryCode from comperitor Cx natural join COUNTRIES Cy; (3 marks) (iv) Select max (count (∗) ) from Competitors group by CountryCode; (2 marks) (b) Write Structured Query Language (SQL). (i) Create a query that displays result to only those people who were in more than two events. (2 marks) (ii) Create a query that displays all given name which have the letter of " u " in the second position, regardless of all other characters. (3 marks) (iii) Create a query that displays data of birth, family name and competitor number for all pairs of competitors who have the same date of birth. (4 marks)