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 | | information_schema | | mysql | | performance_schema | | phpmyadmin | | swim | | toyu | +--------------------+ 9 rows in set (0.011 sec) MariaDB [toyu]> show databases; +--------------------+ | Database | +--------------------+ | ctetinker | | dbtool | | ds | | information_schema | | mysql | | performance_schema | | phpmyadmin | | swim | +--------------------+ 8 rows in set (0.002 sec) MariaDB [toyu]> SELECT * FROM student; ERROR 1146 (42S02): Table 'toyu.student' doesn't exist MariaDB [toyu]> MariaDB [toyu]> 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.001 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.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.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.029 sec) Query OK, 0 rows affected, 1 warning (0.019 sec) Query OK, 0 rows affected, 1 warning (0.019 sec) Query OK, 0 rows affected, 1 warning (0.017 sec) Query OK, 0 rows affected, 1 warning (0.018 sec) Query OK, 0 rows affected, 1 warning (0.021 sec) Query OK, 0 rows affected, 1 warning (0.024 sec) Query OK, 0 rows affected, 1 warning (0.023 sec) Query OK, 0 rows affected (0.005 sec) Query OK, 0 rows affected (0.004 sec) Query OK, 0 rows affected (0.006 sec) Query OK, 0 rows affected (0.006 sec) Query OK, 0 rows affected (0.004 sec) Query OK, 15 rows affected (0.004 sec) Records: 15 Duplicates: 0 Warnings: 0 Query OK, 4 rows affected (0.006 sec) Records: 4 Duplicates: 0 Warnings: 0 Query OK, 7 rows affected (0.010 sec) Records: 7 Duplicates: 0 Warnings: 0 Query OK, 11 rows affected (0.003 sec) Records: 11 Duplicates: 0 Warnings: 0 Query OK, 11 rows affected (0.005 sec) Records: 11 Duplicates: 0 Warnings: 0 Query OK, 14 rows affected (0.006 sec) Records: 14 Duplicates: 0 Warnings: 0 Query OK, 11 rows affected (0.004 sec) Records: 11 Duplicates: 0 Warnings: 0 Query OK, 22 rows affected (0.008 sec) Records: 22 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.001 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.001 sec) MariaDB [toyu]> SELECT DISTINCT stuId, fname, lname, ach -> -- output -> FROM student -> -- source -> WHERE -- conditions -> major = 'CSCI' -> AND ach >= 30 AND ach <= 60; +--------+-------+-------+------+ | stuId | fname | lname | ach | +--------+-------+-------+------+ | 100000 | Tony | Hawk | 40 | | 100001 | Mary | Hawk | 35 | +--------+-------+-------+------+ 2 rows in set (0.010 sec) MariaDB [toyu]> SELECT DISTINCT stuId, fname, lname, -> ach AS credits -- alias -> -- output -> FROM student -> -- source -> WHERE -- conditions -> major = 'CSCI' -> AND ach >= 30 AND ach <= 60; +--------+-------+-------+---------+ | stuId | fname | lname | credits | +--------+-------+-------+---------+ | 100000 | Tony | Hawk | 40 | | 100001 | Mary | Hawk | 35 | +--------+-------+-------+---------+ 2 rows in set (0.001 sec) MariaDB [toyu]> SELECT DISTINCT s.fname, s.lname, e.classId, e.grade -> FROM student AS s, enroll AS e -> WHERE s.stuId = e.stuId -> AND (s.minor = 'CINF' OR s.minor = 'ITEC'); +---------+---------+---------+-------+ | fname | lname | classId | grade | +---------+---------+---------+-------+ | Tony | Hawk | 10000 | A | | Tony | Hawk | 10001 | A | | Tony | Hawk | 10002 | B+ | | Tony | Hawk | 10003 | C | | Tony | Hawk | 10004 | A- | | Tony | Hawk | 11001 | D | | Mary | Hawk | 10000 | NULL | | Mary | Hawk | 10001 | A- | | David | Hawk | 10000 | B- | | David | Hawk | 10002 | B+ | | David | Hawk | 10003 | D | | Lillian | Johnson | 10004 | C+ | | Lillian | Johnson | 10005 | A | +---------+---------+---------+-------+ 13 rows in set (0.003 sec) MariaDB [toyu]>