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]> 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.003 sec)

MariaDB [toyu]> DROP SCHEMA IF EXISTS toyu;
Query OK, 8 rows affected (0.120 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.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.001 sec)

Query OK, 1 row affected (0.004 sec)

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

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

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

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

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

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

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

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

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

Query OK, 0 rows affected (0.013 sec)

Query OK, 0 rows affected (0.012 sec)

Query OK, 0 rows affected (0.015 sec)

Query OK, 0 rows affected (0.013 sec)

Query OK, 0 rows affected (0.012 sec)

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

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

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

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

Query OK, 11 rows affected (0.012 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.006 sec)
Records: 11  Duplicates: 0  Warnings: 0

Query OK, 22 rows affected (0.018 sec)
Records: 22  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 [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.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 DISTINCT stuid, fname, lname, major, minor  -- [1]
    -> FROM student -- [2] 
    -> ;
+--------+-----------+----------+-------+-------+
| 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, 
    ->     CONCA(fname, ' ', lname), major, minor  -- [1]
    -> FROM student -- [2] 
    -> ;
ERROR 1305 (42000): FUNCTION toyu.CONCA does not exist
MariaDB [toyu]> SELECT DISTINCT stuid, 
    ->     CONCAT(student.fname, ' ', lname), major, minor  -- [1]
    -> FROM student -- [2] 
    -> ;
+--------+-----------------------------------+-------+-------+
| stuid  | CONCAT(student.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(student.fname, ' ', lname) AS student -- alias: label
    ->     , major, minor  -- [1]
    -> FROM student -- [2] 
    -> ;
+--------+-----------------+-------+-------+
| 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.001 sec)

MariaDB [toyu]> notee