MariaDB [toyu]> SELECT * FROM student;
+--------+-----------+----------+-------+-------+------+---------+
| stuId  | fname     | lname    | major | minor | ach  | advisor |
+--------+-----------+----------+-------+-------+------+---------+
| 100000 | Tony      | Hawk     | CSCI  | CINF  |   40 |    1011 |
| 100001 | Mary      | Hawk     | CSCI  | CINF  |   35 |    1011 |
| 100002 | David     | Hawk     | CSCI  | ITEC  |   66 |    1012 |
| 100003 | Catherine | Lim      | ITEC  | CINF  |   20 |    NULL |
| 100004 | Larry     | Johnson  | ITEC  | NULL  |   66 |    1017 |
| 100005 | Linda     | Johnson  | CINF  | ENGL  |   13 |    1015 |
| 100006 | Lillian   | Johnson  | CINF  | ITEC  |   18 |    1016 |
| 100007 | Ben       | Zico     | NULL  | NULL  |   16 |    NULL |
| 100008 | Bill      | Ching    | ARTS  | NULL  |   90 |    NULL |
| 100009 | Linda     | King     | ARTS  | CSCI  |  125 |    1018 |
| 100111 | Cathy     | Johanson | NULL  | NULL  |    0 |    1018 |
+--------+-----------+----------+-------+-------+------+---------+
11 rows in set (0.001 sec)

MariaDB [toyu]> show databases;
+--------------------+
| Database           |
+--------------------+
| ctetinker          |
| dbtool             |
| ds                 |
| hw                 |
| information_schema |
| mysql              |
| performance_schema |
| phpmyadmin         |
| swim               |
| toyu               |
+--------------------+
10 rows in set (0.009 sec)

MariaDB [toyu]> DROP SCHEMA IF EXISTS toyu;
Query OK, 9 rows affected (0.190 sec)

MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| ctetinker          |
| dbtool             |
| ds                 |
| hw                 |
| information_schema |
| mysql              |
| performance_schema |
| phpmyadmin         |
| swim               |
+--------------------+
9 rows in set (0.002 sec)

MariaDB [(none)]> SELECT * FROM student;
ERROR 1046 (3D000): No database selected
MariaDB [(none)]> source createtoyu.sql
Query OK, 0 rows affected (0.003 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.001 sec)

Query OK, 0 rows affected, 1 warning (0.001 sec)

Query OK, 1 row affected (0.003 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.001 sec)

Query OK, 0 rows affected, 1 warning (0.001 sec)

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.001 sec)

Query OK, 0 rows affected, 1 warning (0.039 sec)

Query OK, 0 rows affected, 1 warning (0.033 sec)

Query OK, 0 rows affected, 1 warning (0.038 sec)

Query OK, 0 rows affected, 1 warning (0.036 sec)

Query OK, 0 rows affected, 1 warning (0.029 sec)

Query OK, 0 rows affected, 1 warning (0.030 sec)

Query OK, 0 rows affected, 1 warning (0.045 sec)

Query OK, 0 rows affected, 1 warning (0.037 sec)

Query OK, 0 rows affected (0.015 sec)

Query OK, 0 rows affected (0.012 sec)

Query OK, 0 rows affected (0.015 sec)

Query OK, 0 rows affected (0.016 sec)

Query OK, 0 rows affected (0.015 sec)

Query OK, 15 rows affected (0.009 sec)
Records: 15  Duplicates: 0  Warnings: 0

Query OK, 4 rows affected (0.007 sec)
Records: 4  Duplicates: 0  Warnings: 0

Query OK, 7 rows affected (0.014 sec)
Records: 7  Duplicates: 0  Warnings: 0

Query OK, 11 rows affected (0.006 sec)
Records: 11  Duplicates: 0  Warnings: 0

Query OK, 11 rows affected (0.013 sec)
Records: 11  Duplicates: 0  Warnings: 0

Query OK, 14 rows affected (0.014 sec)
Records: 14  Duplicates: 0  Warnings: 0

Query OK, 11 rows affected (0.007 sec)
Records: 11  Duplicates: 0  Warnings: 0

Query OK, 22 rows affected (0.017 sec)
Records: 22  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

MariaDB [toyu]> show databases;
+--------------------+
| Database           |
+--------------------+
| ctetinker          |
| dbtool             |
| ds                 |
| hw                 |
| information_schema |
| mysql              |
| performance_schema |
| phpmyadmin         |
| swim               |
| toyu               |
+--------------------+
10 rows in set (0.002 sec)

MariaDB [toyu]> SELECT * FROM student;
+--------+-----------+----------+-------+-------+------+---------+
| stuId  | fname     | lname    | major | minor | ach  | advisor |
+--------+-----------+----------+-------+-------+------+---------+
| 100000 | Tony      | Hawk     | CSCI  | CINF  |   40 |    1011 |
| 100001 | Mary      | Hawk     | CSCI  | CINF  |   35 |    1011 |
| 100002 | David     | Hawk     | CSCI  | ITEC  |   66 |    1012 |
| 100003 | Catherine | Lim      | ITEC  | CINF  |   20 |    NULL |
| 100004 | Larry     | Johnson  | ITEC  | NULL  |   66 |    1017 |
| 100005 | Linda     | Johnson  | CINF  | ENGL  |   13 |    1015 |
| 100006 | Lillian   | Johnson  | CINF  | ITEC  |   18 |    1016 |
| 100007 | Ben       | Zico     | NULL  | NULL  |   16 |    NULL |
| 100008 | Bill      | Ching    | ARTS  | NULL  |   90 |    NULL |
| 100009 | Linda     | King     | ARTS  | CSCI  |  125 |    1018 |
| 100111 | Cathy     | Johanson | NULL  | NULL  |    0 |    1018 |
+--------+-----------+----------+-------+-------+------+---------+
11 rows in set (0.001 sec)

MariaDB [toyu]> 
MariaDB [toyu]> SELECT DISTINCT stuId, fname, lname, major, minor
    -> FROM student;
+--------+-----------+----------+-------+-------+
| stuId  | fname     | lname    | major | minor |
+--------+-----------+----------+-------+-------+
| 100000 | Tony      | Hawk     | CSCI  | CINF  |
| 100001 | Mary      | Hawk     | CSCI  | CINF  |
| 100002 | David     | Hawk     | CSCI  | ITEC  |
| 100003 | Catherine | Lim      | ITEC  | CINF  |
| 100004 | Larry     | Johnson  | ITEC  | NULL  |
| 100005 | Linda     | Johnson  | CINF  | ENGL  |
| 100006 | Lillian   | Johnson  | CINF  | ITEC  |
| 100007 | Ben       | Zico     | NULL  | NULL  |
| 100008 | Bill      | Ching    | ARTS  | NULL  |
| 100009 | Linda     | King     | ARTS  | CSCI  |
| 100111 | Cathy     | Johanson | NULL  | NULL  |
+--------+-----------+----------+-------+-------+
11 rows in set (0.001 sec)

MariaDB [toyu]> SELECT DISTINCT stuId, 
    ->     CONCAT(fname, ' ', lname), 
    ->     major, minor
    -> FROM student;
+--------+---------------------------+-------+-------+
| stuId  | CONCAT(fname, ' ', lname) | major | minor |
+--------+---------------------------+-------+-------+
| 100000 | Tony Hawk                 | CSCI  | CINF  |
| 100001 | Mary Hawk                 | CSCI  | CINF  |
| 100002 | David Hawk                | CSCI  | ITEC  |
| 100003 | Catherine Lim             | ITEC  | CINF  |
| 100004 | Larry Johnson             | ITEC  | NULL  |
| 100005 | Linda Johnson             | CINF  | ENGL  |
| 100006 | Lillian Johnson           | CINF  | ITEC  |
| 100007 | Ben Zico                  | NULL  | NULL  |
| 100008 | Bill Ching                | ARTS  | NULL  |
| 100009 | Linda King                | ARTS  | CSCI  |
| 100111 | Cathy Johanson            | NULL  | NULL  |
+--------+---------------------------+-------+-------+
11 rows in set (0.001 sec)

MariaDB [toyu]> SELECT DISTINCT stuId, 
    ->     CONCAT(fname, ' ', lname) AS student, -- alias (column label)
    ->     major, minor
    -> FROM student;
+--------+-----------------+-------+-------+
| stuId  | student         | major | minor |
+--------+-----------------+-------+-------+
| 100000 | Tony Hawk       | CSCI  | CINF  |
| 100001 | Mary Hawk       | CSCI  | CINF  |
| 100002 | David Hawk      | CSCI  | ITEC  |
| 100003 | Catherine Lim   | ITEC  | CINF  |
| 100004 | Larry Johnson   | ITEC  | NULL  |
| 100005 | Linda Johnson   | CINF  | ENGL  |
| 100006 | Lillian Johnson | CINF  | ITEC  |
| 100007 | Ben Zico        | NULL  | NULL  |
| 100008 | Bill Ching      | ARTS  | NULL  |
| 100009 | Linda King      | ARTS  | CSCI  |
| 100111 | Cathy Johanson  | NULL  | NULL  |
+--------+-----------------+-------+-------+
11 rows in set (0.000 sec)

MariaDB [toyu]> SELECT DISTINCT stuId, 
    ->     CONCAT(fname, ' ', lname) AS student, -- alias (column label)
    ->     department.deptCode AS major, minor
    -> FROM student, department
    -> WHERE student.major = department.deptCode;
+--------+-----------------+-------+-------+
| stuId  | student         | major | minor |
+--------+-----------------+-------+-------+
| 100000 | Tony Hawk       | CSCI  | CINF  |
| 100001 | Mary Hawk       | CSCI  | CINF  |
| 100002 | David Hawk      | CSCI  | ITEC  |
| 100003 | Catherine Lim   | ITEC  | CINF  |
| 100004 | Larry Johnson   | ITEC  | NULL  |
| 100005 | Linda Johnson   | CINF  | ENGL  |
| 100006 | Lillian Johnson | CINF  | ITEC  |
| 100008 | Bill Ching      | ARTS  | NULL  |
| 100009 | Linda King      | ARTS  | CSCI  |
+--------+-----------------+-------+-------+
9 rows in set (0.003 sec)

MariaDB [toyu]> SELECT DISTINCT stuId, 
    ->     CONCAT(fname, ' ', lname) AS student, -- alias (column label)
    ->     department.deptName AS major, minor
    -> FROM student, department
    -> WHERE student.major = department.deptCode;
+--------+-----------------+------------------------------+-------+
| stuId  | student         | major                        | minor |
+--------+-----------------+------------------------------+-------+
| 100000 | Tony Hawk       | Computer Science             | CINF  |
| 100001 | Mary Hawk       | Computer Science             | CINF  |
| 100002 | David Hawk      | Computer Science             | ITEC  |
| 100003 | Catherine Lim   | Information Technology       | CINF  |
| 100004 | Larry Johnson   | Information Technology       | NULL  |
| 100005 | Linda Johnson   | Computer Information Systems | ENGL  |
| 100006 | Lillian Johnson | Computer Information Systems | ITEC  |
| 100008 | Bill Ching      | Arts                         | NULL  |
| 100009 | Linda King      | Arts                         | CSCI  |
+--------+-----------------+------------------------------+-------+
9 rows in set (0.001 sec)

MariaDB [toyu]> notee