Enter password: ********
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.13 MySQL Community Server - GPL

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use toyu;
Database changed
mysql> SELECT CONCAT('A', 'B', 'C');
+-----------------------+
| CONCAT('A', 'B', 'C') |
+-----------------------+
| ABC                   |
+-----------------------+
1 row in set (0.00 sec)

mysql> SELECT CONCAT('A', 'BXY', 'CDE');
+---------------------------+
| CONCAT('A', 'BXY', 'CDE') |
+---------------------------+
| ABXYCDE                   |
+---------------------------+
1 row in set (0.00 sec)

mysql> SELECT CONCAT('firstname: ', fname, ' lastname:', lname)
    -> FROM student;
+---------------------------------------------------+
| CONCAT('firstname: ', fname, ' lastname:', lname) |
+---------------------------------------------------+
| firstname: Tony lastname:Hawk                     |
| firstname: Mary lastname:Hawk                     |
| firstname: David lastname:Hawk                    |
| firstname: Catherine lastname:Lim                 |
| firstname: Larry lastname:Johnson                 |
| firstname: Linda lastname:Johnson                 |
| firstname: Lillian lastname:Johnson               |
| firstname: Ben lastname:Zico                      |
| firstname: Bill lastname:Ching                    |
| firstname: Linda lastname:King                    |
+---------------------------------------------------+
10 rows in set (0.10 sec)

mysql> SELECT CONCAT('firstname: ', fname, ' lastname: ', lname)
    ->     AS `student`
    -> FROM student;
+--------------------------------------+
| student                              |
+--------------------------------------+
| firstname: Tony lastname: Hawk       |
| firstname: Mary lastname: Hawk       |
| firstname: David lastname: Hawk      |
| firstname: Catherine lastname: Lim   |
| firstname: Larry lastname: Johnson   |
| firstname: Linda lastname: Johnson   |
| firstname: Lillian lastname: Johnson |
| firstname: Ben lastname: Zico        |
| firstname: Bill lastname: Ching      |
| firstname: Linda lastname: King      |
+--------------------------------------+
10 rows in set (0.00 sec)

mysql> SELECT DISTINCT CONCAT(f.fname, ' ', f.lname)
    ->     AS `faculty not teaching CSCI classes`
    -> FROM faculty f
    -> WHERE f.facId NOT IN -- Q6a result: subquery
    ->     (SELECT DISTINCT c.facId
    ->      FROM class c INNER JOIN course co ON (c.courseId = co.courseId)
    ->      WHERE co.rubric = 'CSCI');
+-----------------------------------+
| faculty not teaching CSCI classes |
+-----------------------------------+
| Sharon Mannes                     |
| Daniel Kim                        |
| Andrew Byre                       |
| Deborah Gump                      |
| Art Allister                      |
| Benjamin Yu                       |
| Katrina Bajaj                     |
| Jorginlo Neymar                   |
+-----------------------------------+
8 rows in set (0.06 sec)

mysql> SELECT DISTINCT CONCAT(f.fname, f.lname)
    ->     AS `faculty not teaching CSCI classes`
    -> FROM faculty f
    -> WHERE f.facId NOT IN -- Q6a result: subquery
    ->     (SELECT DISTINCT c.facId
    ->      FROM class c INNER JOIN course co ON (c.courseId = co.courseId)
    ->      WHERE co.rubric = 'CSCI');
+-----------------------------------+
| faculty not teaching CSCI classes |
+-----------------------------------+
| SharonMannes                      |
| DanielKim                         |
| AndrewByre                        |
| DeborahGump                       |
| ArtAllister                       |
| BenjaminYu                        |
| KatrinaBajaj                      |
| JorginloNeymar                    |
+-----------------------------------+
8 rows in set (0.00 sec)

mysql> SELECT DISTINCT CONCAT(f.fname, ' ', f.lname)
    ->     AS `faculty not teaching CSCI classes`
    -> FROM faculty f
    -> WHERE f.facId NOT IN -- Q6a result: subquery
    ->     (SELECT DISTINCT c.facId
    ->      FROM class c, course co
    ->      WHERE c.courseId = co.courseId
    ->      AND co.rubric = 'CSCI');
+-----------------------------------+
| faculty not teaching CSCI classes |
+-----------------------------------+
| Sharon Mannes                     |
| Daniel Kim                        |
| Andrew Byre                       |
| Deborah Gump                      |
| Art Allister                      |
| Benjamin Yu                       |
| Katrina Bajaj                     |
| Jorginlo Neymar                   |
+-----------------------------------+
8 rows in set (0.00 sec)

mysql> SELECT DISTINCT CONCAT(s.fname, ' ', s.lname) AS `student`
    -> FROM student s INNER JOIN enroll e ON (s.stuId = e.stuId)
    -> WHERE e.classId = 10000 AND 10004;
+------------+
| student    |
+------------+
| Tony Hawk  |
| Mary Hawk  |
| David Hawk |
+------------+
3 rows in set (0.00 sec)

mysql> SELECT DISTINCT CONCAT(s.fname, ' ', s.lname) AS `student`
    -> FROM student s INNER JOIN enroll e ON (s.stuId = e.stuId)
    -> WHERE e.classId = 10000
    -> AND e.classId = 10004;
Empty set (0.00 sec)

mysql> SELECT DISTINCT CONCAT(s.fname, ' ', s.lname) AS `student`
    -> FROM student s INNER JOIN enroll e ON (s.stuId = e.stuId)
    -> WHERE e.classId = 10000
    -> OR e.classId = 10004;
+-----------------+
| student         |
+-----------------+
| Tony Hawk       |
| Mary Hawk       |
| David Hawk      |
| Larry Johnson   |
| Linda Johnson   |
| Lillian Johnson |
+-----------------+
6 rows in set (0.00 sec)

mysql>
mysql> SELECT DISTINCT CONCAT(s.fname, ' ', s.lname) AS `student`
    -> FROM student s INNER JOIN enroll e1 ON (s.stuId = e1.stuId)
    ->     INNER JOIN enroll e2 ON (s.stuId = e2.stuId)
    -> WHERE e1.classId = 10000
    -> AND e2.classId = 10004;
+-----------+
| student   |
+-----------+
| Tony Hawk |
+-----------+
1 row in set (0.00 sec)

mysql> SELECT DISTINCT CONCAT(s.fname, ' ', s.lname) AS `student`
    -> FROM student s INNER JOIN enroll e ON (s.stuId = e.stuId)
    -> WHERE e.classId = 10000;
+------------+
| student    |
+------------+
| Tony Hawk  |
| Mary Hawk  |
| David Hawk |
+------------+
3 rows in set (0.00 sec)

mysql>
mysql> SELECT DISTINCT CONCAT(s.fname, ' ', s.lname) AS `student`
    -> FROM student s INNER JOIN enroll e ON (s.stuId = e.stuId)
    -> WHERE e.classId = 10004;
+-----------------+
| student         |
+-----------------+
| Tony Hawk       |
| Larry Johnson   |
| Linda Johnson   |
| Lillian Johnson |
+-----------------+
4 rows in set (0.00 sec)

mysql> SELECT DISTINCT CONCAT(s.fname, ' ', s.lname) AS `student`
    -> FROM student s INNER JOIN enroll e ON (s.stuId = e.stuId)
    -> WHERE e.classId = 10000
    -> INTERSECT
    -> SELECT DISTINCT CONCAT(s.fname, ' ', s.lname) AS `student`
    -> FROM student s INNER JOIN enroll e ON (s.stuId = e.stuId)
    -> WHERE e.classId = 10004;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INTERSECT
SELECT DISTINCT CONCAT(s.fname, ' ', s.lname) AS `student`
FROM studen' at line 4
mysql> (SELECT DISTINCT CONCAT(s.fname, ' ', s.lname) AS `student`
    -> FROM student s INNER JOIN enroll e ON (s.stuId = e.stuId)
    -> WHERE e.classId = 10000)
    -> INTERSECT
    -> (SELECT DISTINCT CONCAT(s.fname, ' ', s.lname) AS `student`
    -> FROM student s INNER JOIN enroll e ON (s.stuId = e.stuId)
    -> WHERE e.classId = 10004);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INTERSECT
(SELECT DISTINCT CONCAT(s.fname, ' ', s.lname) AS `student`
FROM stude' at line 4
mysql> SELECT t_a.`student`
    -> FROM (SELECT DISTINCT CONCAT(s.fname, ' ', s.lname) AS `student`
    ->       FROM student s INNER JOIN enroll e ON (s.stuId = e.stuId)
    ->       WHERE e.classId = 10000) AS t_a,
    ->      (SELECT DISTINCT CONCAT(s.fname, ' ', s.lname) AS `student`
    ->       FROM student s INNER JOIN enroll e ON (s.stuId = e.stuId)
    ->       WHERE e.classId = 10004) AS t_b
    -> WHERE t_a.`student` =  t_b.`student`;
+-----------+
| student   |
+-----------+
| Tony Hawk |
+-----------+
1 row in set (0.00 sec)

mysql> SET @@x = 1;
ERROR 1193 (HY000): Unknown system variable 'x'
mysql> SET @x = 1;
Query OK, 0 rows affected (0.00 sec)

mysql> select @x;
+------+
| @x   |
+------+
|    1 |
+------+
1 row in set (0.00 sec)

mysql>