Write the output produced by the following SQL statements:

(a) SELECT POW(2, 3);

(b) SELECT ROUND(342.9234, -1);

(c) SELECT LENGTH("Informatics Practices");

(d) SELECT YEAR("1979/11/26"), MONTH("1979/11/26"), DAY("1979/11/26"), MONTHNAME("1979/11/26");

(e) SELECT LEFT("INDIA", 3), RIGHT("ComputerScience", 4), MID("Informatics", 3, 4), SUBSTR("Practices", 3);

(a)

Output

+-----------+
| POW(2, 3) |
+-----------+
|         8 |
+-----------+

(b)

Output

+---------------------+
| ROUND(342.9234, -1) |
+---------------------+
|                 340 |
+---------------------+

(c)

Output

+---------------------------------+
| LENGTH("Informatics Practices") |
+---------------------------------+
|                              21 |
+---------------------------------+

(d)

Output

+--------------------+---------------------+-------------------+-------------------------+
| YEAR("1979/11/26") | MONTH("1979/11/26") | DAY("1979/11/26") | MONTHNAME("1979/11/26") |
+--------------------+---------------------+-------------------+-------------------------+
|               1979 |                  11 |                26 | November                |
+--------------------+---------------------+-------------------+-------------------------+

(e)

Output

+------------------+-----------------------------+--------------------------+------------------------+
| LEFT("INDIA", 3) | RIGHT("ComputerScience", 4) | MID("Informatics", 3, 4) | SUBSTR("Practices", 3) |
+------------------+-----------------------------+--------------------------+------------------------+
| IND              | ence                        | form                     | actices                |
+------------------+-----------------------------+--------------------------+------------------------+