Knoppie [2.1.1 - Lys van rose] Vertoon die besonderhede van die plante in die Roos-kategorie in die tblPlante-tabel - NSC Information Technology - Question 2 - 2019 - Paper 1

To display the [PlantKode-, Kategory-, Kleur- en GrootteVanPot-velde] for all plants in the Blom and Roos categories that have a pink color, the following SQL query is applied:

SELECT PlantKode, Kategory, Kleur, GrootteVanPot
FROM tblPlante
WHERE (Kategory IN ('ROOS', 'BLOM')) AND Kleur LIKE '%Pienk%';

To determine the average price of plants per category from the tblPlante table, the following SQL query should be executed:

SELECT Kategore, FORMAT(AVG(Prys), 'Currency') AS [GemiddeldePrys]
FROM tblPlante
GROUP BY Kategore;

In order to display the FaktuurNom-, Beskrywing- and GetalBestel fields from the tblBestellings table for invoice number F2, use the following SQL query:

SELECT FaktuurNom, Beskrywing, GetalBestel
FROM tblBestellings
WHERE plantkode = 'DIP002#M' AND FaktuurNom = 'F2';

To update the delivery count in tblBestellings, the following SQL command should be executed:

UPDATE tblBestellings SET GetalAfgelewer = GetalBestel WHERE ItemNom = 'Quoted(ItemNom)';

To place an order in the tblBestellings table it is necessary to use the following information:

1. The invoice number is F2.
2. The plantcode is 'DIP002#M'.
3. The delivery count is set to 125.

The specific SQL command could look like this:

INSERT INTO tblBestellings (FaktuurNom, Plantkode, GetalBestel)
VALUES ('F2', 'DIP002#M', 125);