Knoppie [2.1.1 - Lys van rose]
Vertoon die besonderehede van die plante in die Roos-kategorie in die tblPlante-tafel - NSC Information Technology - Question 2 - 2019 - Paper 1
Question 2
Knoppie [2.1.1 - Lys van rose]
Vertoon die besonderehede van die plante in die Roos-kategorie in die tblPlante-tafel.
Voorbeeld van afvoer van die eerste vyf rekor... show full transcript
Worked Solution & Example Answer:Knoppie [2.1.1 - Lys van rose]
Vertoon die besonderehede van die plante in die Roos-kategorie in die tblPlante-tafel - NSC Information Technology - Question 2 - 2019 - Paper 1
Step 1
Knoppie [2.1.1 - Lys van rose]
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 * FROM tblPlante WHERE Kategorie = 'Roos';
Step 2
Knoppie [2.1.2 - Pienk rose en blomme]
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 PlantKode, Kategorie, Kleur, GrootteVanPot
FROM tblPlante
WHERE (Kategorie = 'Roos' OR Kategorie = 'Blom')
AND Kleur LIKE '%Pienk%';
Step 3
Knoppie [2.1.3 - Gemiddelde prys per kategorie]
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 Kategorie, FORMAT(AVG(Prys), 'Currency') as [GemiddeldePrys]
FROM tblPlante
GROUP BY Kategorie;
![Knoppie-[2.1.1---Lys-van-rose]--Vertoon-die-besonderehede-van-die-plante-in-die-Roos-kategorie-in-die-tblPlante-tafel-NSC Information Technology-Question 2-2019-Paper 1.png](https://cdn.simplestudy.cloud/assets/backend/uploads/question/subject_1503_paper_20019_q2_679a83de.jpg)
