MariaDB [toyu]> SELECT major -> FROM student; +-------+ | major | +-------+ | NULL | | NULL | | ARTS | | ARTS | | CINF | | CINF | | CSCI | | CSCI | | CSCI | | ITEC | | ITEC | +-------+ 11 rows in set (0.001 sec) MariaDB [toyu]> SELECT DISTINCT major -> FROM student -> ; +-------+ | major | +-------+ | NULL | | ARTS | | CINF | | CSCI | | ITEC | +-------+ 5 rows in set (0.003 sec) MariaDB [toyu]> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | phpmyadmin | | test | | toyu | +--------------------+ 6 rows in set (0.001 sec) MariaDB [toyu]> source CreateSwimDB.sql Query OK, 0 rows affected (0.002 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected, 1 warning (0.000 sec) Query OK, 1 row affected (0.002 sec) Database changed Query OK, 0 rows affected, 1 warning (0.001 sec) Query OK, 0 rows affected, 1 warning (0.000 sec) Query OK, 0 rows affected, 1 warning (0.000 sec) Query OK, 0 rows affected, 1 warning (0.000 sec) Query OK, 0 rows affected, 1 warning (0.000 sec) Query OK, 0 rows affected, 1 warning (0.000 sec) Query OK, 0 rows affected, 1 warning (0.000 sec) Query OK, 0 rows affected, 1 warning (0.000 sec) Query OK, 0 rows affected, 1 warning (0.000 sec) Query OK, 0 rows affected, 1 warning (0.000 sec) Query OK, 0 rows affected, 1 warning (0.000 sec) Query OK, 0 rows affected, 1 warning (0.000 sec) Query OK, 0 rows affected, 1 warning (0.000 sec) Query OK, 0 rows affected, 1 warning (0.000 sec) Query OK, 0 rows affected, 1 warning (0.027 sec) Query OK, 0 rows affected, 1 warning (0.001 sec) Query OK, 0 rows affected, 1 warning (0.024 sec) Query OK, 0 rows affected, 1 warning (0.000 sec) Query OK, 0 rows affected, 1 warning (0.028 sec) Query OK, 0 rows affected, 1 warning (0.001 sec) Query OK, 0 rows affected, 1 warning (0.030 sec) Query OK, 0 rows affected, 1 warning (0.001 sec) Query OK, 0 rows affected, 1 warning (0.036 sec) Query OK, 0 rows affected, 1 warning (0.001 sec) Query OK, 0 rows affected, 1 warning (0.035 sec) Query OK, 0 rows affected, 1 warning (0.001 sec) Query OK, 0 rows affected, 1 warning (0.037 sec) Query OK, 0 rows affected, 1 warning (0.000 sec) Query OK, 0 rows affected, 1 warning (0.040 sec) Query OK, 0 rows affected, 1 warning (0.000 sec) Query OK, 0 rows affected, 1 warning (0.035 sec) Query OK, 0 rows affected, 1 warning (0.001 sec) Query OK, 0 rows affected, 1 warning (0.035 sec) Query OK, 0 rows affected, 1 warning (0.000 sec) Query OK, 0 rows affected, 1 warning (0.031 sec) Query OK, 0 rows affected, 1 warning (0.000 sec) Query OK, 0 rows affected, 1 warning (0.033 sec) Query OK, 0 rows affected, 1 warning (0.000 sec) Query OK, 0 rows affected, 1 warning (0.039 sec) Query OK, 5 rows affected (0.006 sec) Records: 5 Duplicates: 0 Warnings: 0 Query OK, 6 rows affected (0.010 sec) Records: 6 Duplicates: 0 Warnings: 0 Query OK, 10 rows affected (0.004 sec) Records: 10 Duplicates: 0 Warnings: 0 Query OK, 3 rows affected (0.009 sec) Records: 3 Duplicates: 0 Warnings: 0 Query OK, 6 rows affected (0.013 sec) Records: 6 Duplicates: 0 Warnings: 0 Query OK, 6 rows affected (0.005 sec) Records: 6 Duplicates: 0 Warnings: 0 Query OK, 9 rows affected (0.028 sec) Records: 9 Duplicates: 0 Warnings: 0 Query OK, 5 rows affected (0.035 sec) Records: 5 Duplicates: 0 Warnings: 0 Query OK, 3 rows affected (0.013 sec) Records: 3 Duplicates: 0 Warnings: 0 Query OK, 11 rows affected (0.014 sec) Records: 11 Duplicates: 0 Warnings: 0 Query OK, 1 row affected (0.011 sec) Query OK, 1 row affected (0.004 sec) Query OK, 1 row affected (0.010 sec) Query OK, 1 row affected (0.005 sec) Query OK, 1 row affected (0.004 sec) Query OK, 1 row affected (0.004 sec) Query OK, 1 row affected (0.004 sec) Query OK, 1 row affected (0.004 sec) Query OK, 1 row affected (0.004 sec) Query OK, 1 row affected (0.004 sec) Query OK, 1 row affected (0.004 sec) Query OK, 1 row affected (0.004 sec) Query OK, 1 row affected (0.004 sec) Query OK, 1 row affected (0.004 sec) Query OK, 1 row affected (0.004 sec) Query OK, 1 row affected (0.003 sec) Query OK, 1 row affected (0.003 sec) Query OK, 1 row affected (0.003 sec) Query OK, 1 row affected (0.005 sec) Query OK, 1 row affected (0.003 sec) Query OK, 4 rows affected (0.004 sec) Records: 4 Duplicates: 0 Warnings: 0 Query OK, 1 row affected (0.005 sec) Query OK, 1 row affected (0.004 sec) Query OK, 1 row affected (0.003 sec) Query OK, 1 row affected (0.005 sec) Query OK, 1 row affected (0.005 sec) Query OK, 1 row affected (0.009 sec) Query OK, 1 row affected (0.004 sec) Query OK, 1 row affected (0.004 sec) Query OK, 1 row affected (0.003 sec) Query OK, 6 rows affected (0.006 sec) Records: 6 Duplicates: 0 Warnings: 0 Query OK, 3 rows affected (0.009 sec) Records: 3 Duplicates: 0 Warnings: 0 Query OK, 2 rows affected (0.004 sec) Records: 2 Duplicates: 0 Warnings: 0 Query OK, 2 rows affected (0.003 sec) Records: 2 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) MariaDB [SWIM]> SELECT DISTINCT fname -> FROM student -> WHERE major = 'CSCI'; ERROR 1146 (42S02): Table 'swim.student' doesn't exist MariaDB [SWIM]> use toyu; Database changed MariaDB [toyu]> SELECT DISTINCT fname -> FROM student -> WHERE major = 'CSCI'; +-------+ | fname | +-------+ | Tony | | Mary | | David | +-------+ 3 rows in set (0.003 sec) MariaDB [toyu]> SELECT 1; +---+ | 1 | +---+ | 1 | +---+ 1 row in set (0.000 sec) MariaDB [toyu]> SELECT MAX(ach) AS max_ach -> FROM student; +---------+ | max_ach | +---------+ | 125 | +---------+ 1 row in set (0.005 sec) MariaDB [toyu]> MariaDB [toyu]> SELECT DISTINCT s.stuId, s.ach -> (max_student.max_ach - s.ach) AS `delta ach from the max student` -> FROM student AS s, -> (SELECT MAX(ach) AS max_ach -> FROM student) AS max_student; ERROR 1305 (42000): FUNCTION s.ach does not exist MariaDB [toyu]> SELECT DISTINCT s.stuId, s.ach -> (max_student.max_ach - s.ach) AS `delta ach from the max student` -> FROM student AS s, -> (SELECT MAX(ach) AS max_ach -> FROM student) AS max_student; ERROR 1305 (42000): FUNCTION s.ach does not exist MariaDB [toyu]> SELECT DISTINCT s.stuId, s.ach, -> (max_student.max_ach - s.ach) AS `delta ach from the max student` -> FROM student AS s, -> (SELECT MAX(ach) AS max_ach -> FROM student) AS max_student; +--------+------+--------------------------------+ | stuId | ach | delta ach from the max student | +--------+------+--------------------------------+ | 100000 | 40 | 85 | | 100001 | 35 | 90 | | 100002 | 66 | 59 | | 100003 | 20 | 105 | | 100004 | 66 | 59 | | 100005 | 13 | 112 | | 100006 | 18 | 107 | | 100007 | 16 | 109 | | 100008 | 90 | 35 | | 100009 | 125 | 0 | | 100111 | 0 | 125 | +--------+------+--------------------------------+ 11 rows in set (0.004 sec) MariaDB [toyu]> notee