VRAAG 2: SQL EN DATABASISPROGRAMMERING
Die databasiste bevat twee tabelle, naamlik tblKlubs en tblLede - NSC Information Technology - Question 2 - 2021 - Paper 1
Question 2
VRAAG 2: SQL EN DATABASISPROGRAMMERING
Die databasiste bevat twee tabelle, naamlik tblKlubs en tblLede.
Die bladsy met data en die einde vraestel verskaf inligting... show full transcript
Worked Solution & Example Answer:VRAAG 2: SQL EN DATABASISPROGRAMMERING
Die databasiste bevat twee tabelle, naamlik tblKlubs en tblLede - NSC Information Technology - Question 2 - 2021 - Paper 1
Step 1
Knoppie [2.1.1 - Klubs van Gauteng en SA geaffilieer]
96%
114 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
SELECT KlubNaam, KlubDorp FROM tblKlubs
WHERE Provinsie = 'GP' AND SA_Geaffilieer = True;
Step 2
Knoppie [2.1.2 - Geboortedatum]
99%
104 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
SELECT LidNaam, LidVan, Geboortedatum
FROM tblLede
WHERE year(Geboortedatum) = 2002
ORDER BY Geboortedatum;
Step 3
Knoppie [2.1.3 - Vertoon lede]
96%
101 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
SELECT tblLede.LidNaam, tblLede.LidVan
FROM tblLede INNER JOIN tblKlubs
on tblKlubs.KlubId = tblLede.KlubId
WHERE tblKlubs.KlubNaam = 'Geselekteerde Klub Naam';
Step 4
Knoppie [2.1.4 - Gemiddelde ledegeld]
98%
120 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
SELECT Provinsie, FORMAT(AVG(LedeGeld), 'Currency') AS GemFooi
FROM tblKlubs
GROUP BY Provinsie
HAVING AVG(LedeGeld) > 400;
Step 5
Knoppie [2.1.5 - Verander naam van lid]
97%
117 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
UPDATE tblLede
SET LidNaam = 'Ainsley'
WHERE LidNaam = 'Ainsley';
