MariaDB [(none)]> use toyu; Database changed 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]> MariaDB [toyu]> SELECT DISTINCT stuid, -> CONCAT(student.fname, ' ', lname) AS name -- alias: label -> , major, minor -- [1] -> FROM student -- [2] -> ; +--------+-----------------+-------+-------+ | stuid | name | 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 name -- alias: label -> , major, minor -- [1] -> FROM student -- [2] -> ; ERROR 1583 (42000): Incorrect parameters in the call to native function 'CONCAT' MariaDB [toyu]> SELECT DISTINCT stuid, -> CONCAT(student.fname, ' ', lname) AS name -- alias: label -> , major, minor -- [1] -> FROM student -- [2] -> WHERE minor = 'CSCI' OR 'CINF' OR 'ITEC' -> ; +--------+------------+-------+-------+ | stuid | name | major | minor | +--------+------------+-------+-------+ | 100009 | Linda King | ARTS | CSCI | +--------+------------+-------+-------+ 1 row in set, 10 warnings (0.004 sec) MariaDB [toyu]> SELECT DISTINCT stuid, -> CONCAT(student.fname, ' ', lname) AS name -- alias: label -> , major, minor -- [1] -> FROM student -- [2] -> WHERE minor = 'CSCI' OR minor = 'CINF' OR minor = 'ITEC' -> ; +--------+-----------------+-------+-------+ | stuid | name | major | minor | +--------+-----------------+-------+-------+ | 100000 | Tony Hawk | CSCI | CINF | | 100001 | Mary Hawk | CSCI | CINF | | 100002 | David Hawk | CSCI | ITEC | | 100003 | Catherine Lim | ITEC | CINF | | 100006 | Lillian Johnson | CINF | ITEC | | 100009 | Linda King | ARTS | CSCI | +--------+-----------------+-------+-------+ 6 rows in set (0.002 sec) MariaDB [toyu]> SELECT 2 IN (0,3,5,7); +----------------+ | 2 IN (0,3,5,7) | +----------------+ | 0 | +----------------+ 1 row in set (0.000 sec) MariaDB [toyu]> SELECT 2 IN (2,3,5,7); +----------------+ | 2 IN (2,3,5,7) | +----------------+ | 1 | +----------------+ 1 row in set (0.000 sec) MariaDB [toyu]> SELECT DISTINCT stuid, -> CONCAT(student.fname, ' ', lname) AS name -- alias: label -> , major, minor -- [1] -> FROM student -- [2] -> WHERE minor IN ('CSCI','CINF', 'ITEC') -> ; +--------+-----------------+-------+-------+ | stuid | name | major | minor | +--------+-----------------+-------+-------+ | 100000 | Tony Hawk | CSCI | CINF | | 100001 | Mary Hawk | CSCI | CINF | | 100002 | David Hawk | CSCI | ITEC | | 100003 | Catherine Lim | ITEC | CINF | | 100006 | Lillian Johnson | CINF | ITEC | | 100009 | Linda King | ARTS | CSCI | +--------+-----------------+-------+-------+ 6 rows in set (0.001 sec) MariaDB [toyu]> SELECT DISTINCT s.stuid, -> CONCAT(s.fname, ' ', s.lname) AS name -- alias: label -> , d.deptName AS major, minor -- [1] -> FROM student AS s, -> department AS d -- [2] -> WHERE minor IN ('CSCI','CINF', 'ITEC') -> ; +--------+-----------------+------------------------------+-------+ | stuid | name | major | minor | +--------+-----------------+------------------------------+-------+ | 100000 | Tony Hawk | Accounting | CINF | | 100001 | Mary Hawk | Accounting | CINF | | 100002 | David Hawk | Accounting | ITEC | | 100003 | Catherine Lim | Accounting | CINF | | 100006 | Lillian Johnson | Accounting | ITEC | | 100009 | Linda King | Accounting | CSCI | | 100000 | Tony Hawk | Arts | CINF | | 100001 | Mary Hawk | Arts | CINF | | 100002 | David Hawk | Arts | ITEC | | 100003 | Catherine Lim | Arts | CINF | | 100006 | Lillian Johnson | Arts | ITEC | | 100009 | Linda King | Arts | CSCI | | 100000 | Tony Hawk | Computer Information Systems | CINF | | 100001 | Mary Hawk | Computer Information Systems | CINF | | 100002 | David Hawk | Computer Information Systems | ITEC | | 100003 | Catherine Lim | Computer Information Systems | CINF | | 100006 | Lillian Johnson | Computer Information Systems | ITEC | | 100009 | Linda King | Computer Information Systems | CSCI | | 100000 | Tony Hawk | Computer Science | CINF | | 100001 | Mary Hawk | Computer Science | CINF | | 100002 | David Hawk | Computer Science | ITEC | | 100003 | Catherine Lim | Computer Science | CINF | | 100006 | Lillian Johnson | Computer Science | ITEC | | 100009 | Linda King | Computer Science | CSCI | | 100000 | Tony Hawk | English | CINF | | 100001 | Mary Hawk | English | CINF | | 100002 | David Hawk | English | ITEC | | 100003 | Catherine Lim | English | CINF | | 100006 | Lillian Johnson | English | ITEC | | 100009 | Linda King | English | CSCI | | 100000 | Tony Hawk | Information Technology | CINF | | 100001 | Mary Hawk | Information Technology | CINF | | 100002 | David Hawk | Information Technology | ITEC | | 100003 | Catherine Lim | Information Technology | CINF | | 100006 | Lillian Johnson | Information Technology | ITEC | | 100009 | Linda King | Information Technology | CSCI | | 100000 | Tony Hawk | Mathematics | CINF | | 100001 | Mary Hawk | Mathematics | CINF | | 100002 | David Hawk | Mathematics | ITEC | | 100003 | Catherine Lim | Mathematics | CINF | | 100006 | Lillian Johnson | Mathematics | ITEC | | 100009 | Linda King | Mathematics | CSCI | +--------+-----------------+------------------------------+-------+ 42 rows in set (0.004 sec) MariaDB [toyu]> MariaDB [toyu]> SELECT DISTINCT s.stuid, -> CONCAT(s.fname, ' ', s.lname) AS name -- alias: label -> , d.deptName AS major, minor -- [1] -> FROM student AS s, -> department AS d -- [2] -> WHERE s.major = d.deptCode -> AND minor IN ('CSCI','CINF', 'ITEC') -> ; +--------+-----------------+------------------------------+-------+ | stuid | name | 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 | | 100006 | Lillian Johnson | Computer Information Systems | ITEC | | 100009 | Linda King | Arts | CSCI | +--------+-----------------+------------------------------+-------+ 6 rows in set (0.002 sec) MariaDB [toyu]> SELECT DISTINCT s.stuid, -> CONCAT(s.fname, ' ', s.lname) AS name -- alias: label -> , d.deptName AS major, minor -- [1] -> FROM student AS s INNER JOIN department AS d -> ON (s.major = d.deptCode) -- [2] -> WHERE minor IN ('CSCI','CINF', 'ITEC') -> ; +--------+-----------------+------------------------------+-------+ | stuid | name | 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 | | 100006 | Lillian Johnson | Computer Information Systems | ITEC | | 100009 | Linda King | Arts | CSCI | +--------+-----------------+------------------------------+-------+ 6 rows in set (0.001 sec) MariaDB [toyu]> SELECT DISTINCT s.stuid, -> CONCAT(s.fname, ' ', s.lname) AS name -- alias: label -> , d.deptName AS major, minor, -> CONCAT(f.fname, ' ', f.lname) AS advsior -- [1] -> FROM student AS s INNER JOIN department AS d -> ON (s.major = d.deptCode) -> INNER faculty AS f ON (s.advisor = f.facId)-- [2] -> WHERE minor IN ('CSCI','CINF', 'ITEC') -> ; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'faculty AS f ON (s.advisor = f.facId) WHERE minor IN ('CSCI','CINF', 'ITEC')' at line 7 MariaDB [toyu]> SELECT DISTINCT s.stuid, -> CONCAT(s.fname, ' ', s.lname) AS name -- alias: label -> , d.deptName AS major, minor, -> CONCAT(f.fname, ' ', f.lname) AS advsior -- [1] -> FROM student AS s INNER JOIN department AS d -> ON (s.major = d.deptCode) -> INNER JOIN faculty AS f ON (s.advisor = f.facId)-- [2] -> WHERE minor IN ('CSCI','CINF', 'ITEC') -> ; +--------+-----------------+------------------------------+-------+--------------+ | stuid | name | major | minor | advsior | +--------+-----------------+------------------------------+-------+--------------+ | 100000 | Tony Hawk | Computer Science | CINF | Paul Smith | | 100001 | Mary Hawk | Computer Science | CINF | Paul Smith | | 100002 | David Hawk | Computer Science | ITEC | Mary Tran | | 100006 | Lillian Johnson | Computer Information Systems | ITEC | Andrew Byre | | 100009 | Linda King | Arts | CSCI | Art Allister | +--------+-----------------+------------------------------+-------+--------------+ 5 rows in set (0.002 sec) MariaDB [toyu]> SELECT DISTINCT s.stuid, -> CONCAT(s.fname, ' ', s.lname) AS name -- alias: label -> , d.deptName AS major, minor, -> CONCAT(f.fname, ' ', f.lname) AS advsior -- [1] -> FROM student AS s INNER JOIN department AS d -> ON (s.major = d.deptCode) -> INNER JOIN faculty AS f ON (s.advisor = f.facId)-- [2] -> WHERE minor IN ('CSCI','CINF', 'ITEC') -> AND major IN ('CSCI','CINF', 'ITEC') -> ; +--------+-----------------+------------------------------+-------+-------------+ | stuid | name | major | minor | advsior | +--------+-----------------+------------------------------+-------+-------------+ | 100000 | Tony Hawk | Computer Science | CINF | Paul Smith | | 100001 | Mary Hawk | Computer Science | CINF | Paul Smith | | 100002 | David Hawk | Computer Science | ITEC | Mary Tran | | 100006 | Lillian Johnson | Computer Information Systems | ITEC | Andrew Byre | +--------+-----------------+------------------------------+-------+-------------+ 4 rows in set (0.003 sec) MariaDB [toyu]> MariaDB [toyu]> SELECT DISTINCT s.stuid, -> CONCAT(s.fname, ' ', s.lname) AS name -- alias: label -> , d.deptName AS major, minor, -> CONCAT(f.fname, ' ', f.lname) AS advsior -- [1] -> FROM student AS s INNER JOIN department AS d -> ON (s.major = d.deptCode) -> INNER JOIN faculty AS f ON (s.advisor = f.facId)-- [2] -> WHERE minor IN ('CSCI','CINF', 'ITEC') -> OR major IN ('CSCI','CINF', 'ITEC') -> ; +--------+-----------------+------------------------------+-------+--------------+ | stuid | name | major | minor | advsior | +--------+-----------------+------------------------------+-------+--------------+ | 100009 | Linda King | Arts | CSCI | Art Allister | | 100005 | Linda Johnson | Computer Information Systems | ENGL | Daniel Kim | | 100006 | Lillian Johnson | Computer Information Systems | ITEC | Andrew Byre | | 100000 | Tony Hawk | Computer Science | CINF | Paul Smith | | 100001 | Mary Hawk | Computer Science | CINF | Paul Smith | | 100002 | David Hawk | Computer Science | ITEC | Mary Tran | | 100004 | Larry Johnson | Information Technology | NULL | Deborah Gump | +--------+-----------------+------------------------------+-------+--------------+ 7 rows in set (0.001 sec) MariaDB [toyu]> MariaDB [toyu]> SELECT DISTINCT s.stuId, -> CONCAT(s.fname, ' ', s.lname) AS student, -> c.classId, -> CONCAT(co.rubric, ' ', co.number) AS course, -> co.title AS `course title`, -> e.grade, -> CONCAT(f.fname, ' ', f.lname) AS faculty -> FROM student AS s INNER JOIN enroll AS e USING (stuId) -> INNER JOIN class AS c USING (classId) -> INNER JOIN faculty AS f USING (facId) -> INNER JOIN course AS co USING (courseId) -> WHERE f.deptCode = 'CSCI'; +--------+-----------------+---------+-----------+-------------------------------------+-------+---------------+ | stuId | student | classId | course | course title | grade | faculty | +--------+-----------------+---------+-----------+-------------------------------------+-------+---------------+ | 100000 | Tony Hawk | 10000 | CSCI 3333 | Data Structures | A | Paul Smith | | 100001 | Mary Hawk | 10000 | CSCI 3333 | Data Structures | NULL | Paul Smith | | 100002 | David Hawk | 10000 | CSCI 3333 | Data Structures | B- | Paul Smith | | 100000 | Tony Hawk | 10001 | CSCI 4333 | Design of Database Systems | A | Paul Smith | | 100001 | Mary Hawk | 10001 | CSCI 4333 | Design of Database Systems | A- | Paul Smith | | 100000 | Tony Hawk | 10002 | CSCI 5333 | DBMS | B+ | Mary Tran | | 100002 | David Hawk | 10002 | CSCI 5333 | DBMS | B+ | Mary Tran | | 100000 | Tony Hawk | 11001 | CSCI 4333 | Design of Database Systems | D | Mary Tran | | 100000 | Tony Hawk | 10003 | CINF 3321 | Introduction to Information Systems | C | Sharon Mannes | | 100002 | David Hawk | 10003 | CINF 3321 | Introduction to Information Systems | D | Sharon Mannes | | 100004 | Larry Johnson | 10003 | CINF 3321 | Introduction to Information Systems | A | Sharon Mannes | | 100005 | Linda Johnson | 10003 | CINF 3321 | Introduction to Information Systems | NULL | Sharon Mannes | | 100000 | Tony Hawk | 10004 | CINF 4320 | Web Application Development | A- | Sharon Mannes | | 100004 | Larry Johnson | 10004 | CINF 4320 | Web Application Development | B+ | Sharon Mannes | | 100005 | Linda Johnson | 10004 | CINF 4320 | Web Application Development | A- | Sharon Mannes | | 100006 | Lillian Johnson | 10004 | CINF 4320 | Web Application Development | C+ | Sharon Mannes | +--------+-----------------+---------+-----------+-------------------------------------+-------+---------------+ 16 rows in set (0.003 sec) MariaDB [toyu]> notee