List of top Information Technology Questions on SQL

Consider the given table GARMENT:

+--------+--------------+------+--------+-------+
| GCODE  | GNAME        | SIZE | COLOUR | PRICE |
+--------+--------------+------+--------+-------+
| 111    | TShirt       | XL   | Red    | 1400  |
| 112    | Jeans        | L    | Blue   | 1600  |
| 113    | Skirt        | M    | Black  | 1100  |
| 114    | Ladies Jacket| XL   | Blue   | 4000  |
| 115    | Trousers     | L    | Brown  | 1500  |
| 116    | Ladies Top   | L    | Pink   | 1200  |
+--------+--------------+------+--------+-------+

Write SQL commands for the following: (a) To display names of those garments that are available in ‘L’ size.
(b) To change the colour of garments with code as 115 to “Orange”.
(c) To add a new row with the following data:
GCODE = 117, GNAME = Kurta, SIZE = M, COLOUR = White, PRICE = 1000
(d) To remove the column ‘COLOUR’ from the table ‘GARMENT’.