QUESTION 1 1.1 Given the table named PRODUCTS below, answer questions 1.1.1 to 1.1.5 Table 0: PRODUCTS P_CODE P_DESCRIPT
-
- Posts: 43759
- Joined: Sat Aug 07, 2021 7:38 am
QUESTION 1 1.1 Given the table named PRODUCTS below, answer questions 1.1.1 to 1.1.5 Table 0: PRODUCTS P_CODE P_DESCRIPT
QUESTION 1 1.1 Given the table named PRODUCTS below, answer questions 1.1.1 to 1.1.5 Table 0: PRODUCTS P_CODE P_DESCRIPT PRICE 123456 Flashlight 5.26 123457 Lamp 25.15 123458 Box Fan 10.99 213345 9v battery 1.92 254467 100W bulb 1.47 311452 Powerdril 34.99 1.1.1 Show the result of THE SELECT ALL statement. 1.1.2 SELECT price less than R2,00 1.1.3 SELECT P_CODE = 311452 1.1.4 PROJECT Price 1.1.5 PROJECT P_DESCRIPT and Price (5) (2) (1) (4) (3) [15]