MariaDB [toyu]> SELECT DISTINCT * -> FROM Student -> WHERE StuId = 100000; +--------+-------+-------+-------+-------+------+---------+ | stuId | fname | lname | major | minor | ach | advisor | +--------+-------+-------+-------+-------+------+---------+ | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | +--------+-------+-------+-------+-------+------+---------+ 1 row in set (0.003 sec) MariaDB [toyu]> SELECT DISTINCT * -> FROM Student -> WHERE lname = 'Hawk'; +--------+-------+-------+-------+-------+------+---------+ | 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 | +--------+-------+-------+-------+-------+------+---------+ 3 rows in set (0.001 sec) MariaDB [toyu]> INSERT INTO Student(stuId, fname, lname, major, minor, ach, advisor) VALUES -> (2200000,'Bun,'Yue','ITEC','CINF',25,1011); '> '; 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 'Yue','ITEC','CINF',25,1011); '' at line 2 MariaDB [toyu]> INSERT INTO Student(stuId, fname, lname, major, minor, ach, advisor) VALUES -> (2200000,'Bun','Yue','ITEC','CINF',25,1011); Query OK, 1 row affected (0.011 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 | | 2200000 | Bun | Yue | ITEC | CINF | 25 | 1011 | +---------+-----------+----------+-------+-------+------+---------+ 12 rows in set (0.001 sec) MariaDB [toyu]> INSERT INTO Student(stuId, fname, lname, major, minor, ach, advisor) VALUES -> (2200000,'Bunny','Yue','CINF','ITEC',15,1011); ERROR 1062 (23000): Duplicate entry '2200000' for key 'PRIMARY' MariaDB [toyu]> INSERT INTO Student(stuId, fname, lname, major, minor, ach, advisor) VALUES -> (3330000,'Bunny','Yue','CINF','ITEC',15,1011); Query OK, 1 row affected (0.006 sec) MariaDB [toyu]> INSERT INTO Student(stuId, fname, lname, major, minor, ach, advisor) VALUES -> (4440000,'Funny','Yue','COME','ITEC',55,1011); ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`toyu`.`student`, CONSTRAINT `Student_major_fk` FOREIGN KEY (`major`) REFERENCES `department` (`deptCode`) ON DELETE CASCADE) MariaDB [toyu]> INSERT INTO Department(deptCode, deptName, schoolCode, numStaff) VALUES -> ('COME','Comedy','CSE',3); Query OK, 1 row affected (0.005 sec) MariaDB [toyu]> INSERT INTO Student(stuId, fname, lname, major, minor, ach, advisor) VALUES -> (4440000,'Funny','Yue','COME','ITEC',55,1011); Query OK, 1 row affected (0.003 sec) MariaDB [toyu]> INSERT INTO Student(stuId, fname, lname, major, minor, ach, advisor) VALUES -> (5550000,'Grumpy','Yue','COME','MUSI',75,1221); ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`toyu`.`student`, CONSTRAINT `Student_minor_fk` FOREIGN KEY (`minor`) REFERENCES `department` (`deptCode`) ON DELETE CASCADE) MariaDB [toyu]> INSERT INTO Department(deptCode, deptName, schoolCode, numStaff) VALUES -> ('MUSI','Music','HSH',2); Query OK, 1 row affected (0.005 sec) MariaDB [toyu]> MariaDB [toyu]> INSERT INTO Student(stuId, fname, lname, major, minor, ach, advisor) VALUES -> (5550000,'Grumpy','Yue','COME','MUSI',75,1221); ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`toyu`.`student`, CONSTRAINT `Student_advisor_fk` FOREIGN KEY (`advisor`) REFERENCES `faculty` (`facId`)) MariaDB [toyu]> MariaDB [toyu]> INSERT INTO Faculty(facId, fname, lname, deptCode, `rank`) VALUES -> (1221,'Pauline','Smithson','MUSI','Professor'), -> ; 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 '' at line 2 MariaDB [toyu]> INSERT INTO Faculty(facId, fname, lname, deptCode, `rank`) VALUES -> (1221,'Pauline','Smithson','MUSI','Professor'); Query OK, 1 row affected (0.006 sec) MariaDB [toyu]> MariaDB [toyu]> INSERT INTO Student(stuId, fname, lname, major, minor, ach, advisor) VALUES -> (5550000,'Grumpy','Yue','COME','MUSI',75,1221); Query OK, 1 row affected (0.006 sec) MariaDB [toyu]> SELECT DISTINCT s.fname, s.lname, e.classId, e.grade -- [3] -> FROM student AS s, enroll AS e -- [2] -> WHERE s.stuId = e.stuId [3] -> AND (s.minor = 'CINF' OR s.minor = '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 '[3] AND (s.minor = 'CINF' OR s.minor = 'ITEC')' at line 3 MariaDB [toyu]> SELECT DISTINCT s.fname, s.lname, e.classId, e.grade -- [3] -> FROM student AS s, enroll AS e -- [2] -> WHERE s.stuId = e.stuId -- [3] -> 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.011 sec) MariaDB [toyu]> SELECT DISTINCT s.*, e.* -- [3] -> FROM student AS s, enroll AS e; -- [1] +---------+-----------+----------+-------+-------+------+---------+--------+---------+-------+----------+ | stuId | fname | lname | major | minor | ach | advisor | stuId | classId | grade | n_alerts | +---------+-----------+----------+-------+-------+------+---------+--------+---------+-------+----------+ | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10000 | A | 0 | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100000 | 10000 | A | 0 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100000 | 10000 | A | 0 | | 100003 | Catherine | Lim | ITEC | CINF | 20 | NULL | 100000 | 10000 | A | 0 | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 100000 | 10000 | A | 0 | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100000 | 10000 | A | 0 | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100000 | 10000 | A | 0 | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 100000 | 10000 | A | 0 | | 100008 | Bill | Ching | ARTS | NULL | 90 | NULL | 100000 | 10000 | A | 0 | | 100009 | Linda | King | ARTS | CSCI | 125 | 1018 | 100000 | 10000 | A | 0 | | 100111 | Cathy | Johanson | NULL | NULL | 0 | 1018 | 100000 | 10000 | A | 0 | | 2200000 | Bun | Yue | ITEC | CINF | 25 | 1011 | 100000 | 10000 | A | 0 | | 3330000 | Bunny | Yue | CINF | ITEC | 15 | 1011 | 100000 | 10000 | A | 0 | | 4440000 | Funny | Yue | COME | ITEC | 55 | 1011 | 100000 | 10000 | A | 0 | | 5550000 | Grumpy | Yue | COME | MUSI | 75 | 1221 | 100000 | 10000 | A | 0 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100001 | 10000 | NULL | NULL | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100001 | 10000 | NULL | NULL | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100001 | 10000 | NULL | NULL | | 100003 | Catherine | Lim | ITEC | CINF | 20 | NULL | 100001 | 10000 | NULL | NULL | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 100001 | 10000 | NULL | NULL | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100001 | 10000 | NULL | NULL | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100001 | 10000 | NULL | NULL | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 100001 | 10000 | NULL | NULL | | 100008 | Bill | Ching | ARTS | NULL | 90 | NULL | 100001 | 10000 | NULL | NULL | | 100009 | Linda | King | ARTS | CSCI | 125 | 1018 | 100001 | 10000 | NULL | NULL | | 100111 | Cathy | Johanson | NULL | NULL | 0 | 1018 | 100001 | 10000 | NULL | NULL | | 2200000 | Bun | Yue | ITEC | CINF | 25 | 1011 | 100001 | 10000 | NULL | NULL | | 3330000 | Bunny | Yue | CINF | ITEC | 15 | 1011 | 100001 | 10000 | NULL | NULL | | 4440000 | Funny | Yue | COME | ITEC | 55 | 1011 | 100001 | 10000 | NULL | NULL | | 5550000 | Grumpy | Yue | COME | MUSI | 75 | 1221 | 100001 | 10000 | NULL | NULL | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100002 | 10000 | B- | 3 | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100002 | 10000 | B- | 3 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100002 | 10000 | B- | 3 | | 100003 | Catherine | Lim | ITEC | CINF | 20 | NULL | 100002 | 10000 | B- | 3 | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 100002 | 10000 | B- | 3 | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100002 | 10000 | B- | 3 | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100002 | 10000 | B- | 3 | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 100002 | 10000 | B- | 3 | | 100008 | Bill | Ching | ARTS | NULL | 90 | NULL | 100002 | 10000 | B- | 3 | | 100009 | Linda | King | ARTS | CSCI | 125 | 1018 | 100002 | 10000 | B- | 3 | | 100111 | Cathy | Johanson | NULL | NULL | 0 | 1018 | 100002 | 10000 | B- | 3 | | 2200000 | Bun | Yue | ITEC | CINF | 25 | 1011 | 100002 | 10000 | B- | 3 | | 3330000 | Bunny | Yue | CINF | ITEC | 15 | 1011 | 100002 | 10000 | B- | 3 | | 4440000 | Funny | Yue | COME | ITEC | 55 | 1011 | 100002 | 10000 | B- | 3 | | 5550000 | Grumpy | Yue | COME | MUSI | 75 | 1221 | 100002 | 10000 | B- | 3 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10001 | A | 2 | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100000 | 10001 | A | 2 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100000 | 10001 | A | 2 | | 100003 | Catherine | Lim | ITEC | CINF | 20 | NULL | 100000 | 10001 | A | 2 | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 100000 | 10001 | A | 2 | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100000 | 10001 | A | 2 | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100000 | 10001 | A | 2 | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 100000 | 10001 | A | 2 | | 100008 | Bill | Ching | ARTS | NULL | 90 | NULL | 100000 | 10001 | A | 2 | | 100009 | Linda | King | ARTS | CSCI | 125 | 1018 | 100000 | 10001 | A | 2 | | 100111 | Cathy | Johanson | NULL | NULL | 0 | 1018 | 100000 | 10001 | A | 2 | | 2200000 | Bun | Yue | ITEC | CINF | 25 | 1011 | 100000 | 10001 | A | 2 | | 3330000 | Bunny | Yue | CINF | ITEC | 15 | 1011 | 100000 | 10001 | A | 2 | | 4440000 | Funny | Yue | COME | ITEC | 55 | 1011 | 100000 | 10001 | A | 2 | | 5550000 | Grumpy | Yue | COME | MUSI | 75 | 1221 | 100000 | 10001 | A | 2 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100001 | 10001 | A- | 0 | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100001 | 10001 | A- | 0 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100001 | 10001 | A- | 0 | | 100003 | Catherine | Lim | ITEC | CINF | 20 | NULL | 100001 | 10001 | A- | 0 | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 100001 | 10001 | A- | 0 | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100001 | 10001 | A- | 0 | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100001 | 10001 | A- | 0 | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 100001 | 10001 | A- | 0 | | 100008 | Bill | Ching | ARTS | NULL | 90 | NULL | 100001 | 10001 | A- | 0 | | 100009 | Linda | King | ARTS | CSCI | 125 | 1018 | 100001 | 10001 | A- | 0 | | 100111 | Cathy | Johanson | NULL | NULL | 0 | 1018 | 100001 | 10001 | A- | 0 | | 2200000 | Bun | Yue | ITEC | CINF | 25 | 1011 | 100001 | 10001 | A- | 0 | | 3330000 | Bunny | Yue | CINF | ITEC | 15 | 1011 | 100001 | 10001 | A- | 0 | | 4440000 | Funny | Yue | COME | ITEC | 55 | 1011 | 100001 | 10001 | A- | 0 | | 5550000 | Grumpy | Yue | COME | MUSI | 75 | 1221 | 100001 | 10001 | A- | 0 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10002 | B+ | 1 | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100000 | 10002 | B+ | 1 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100000 | 10002 | B+ | 1 | | 100003 | Catherine | Lim | ITEC | CINF | 20 | NULL | 100000 | 10002 | B+ | 1 | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 100000 | 10002 | B+ | 1 | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100000 | 10002 | B+ | 1 | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100000 | 10002 | B+ | 1 | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 100000 | 10002 | B+ | 1 | | 100008 | Bill | Ching | ARTS | NULL | 90 | NULL | 100000 | 10002 | B+ | 1 | | 100009 | Linda | King | ARTS | CSCI | 125 | 1018 | 100000 | 10002 | B+ | 1 | | 100111 | Cathy | Johanson | NULL | NULL | 0 | 1018 | 100000 | 10002 | B+ | 1 | | 2200000 | Bun | Yue | ITEC | CINF | 25 | 1011 | 100000 | 10002 | B+ | 1 | | 3330000 | Bunny | Yue | CINF | ITEC | 15 | 1011 | 100000 | 10002 | B+ | 1 | | 4440000 | Funny | Yue | COME | ITEC | 55 | 1011 | 100000 | 10002 | B+ | 1 | | 5550000 | Grumpy | Yue | COME | MUSI | 75 | 1221 | 100000 | 10002 | B+ | 1 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100002 | 10002 | B+ | 2 | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100002 | 10002 | B+ | 2 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100002 | 10002 | B+ | 2 | | 100003 | Catherine | Lim | ITEC | CINF | 20 | NULL | 100002 | 10002 | B+ | 2 | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 100002 | 10002 | B+ | 2 | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100002 | 10002 | B+ | 2 | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100002 | 10002 | B+ | 2 | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 100002 | 10002 | B+ | 2 | | 100008 | Bill | Ching | ARTS | NULL | 90 | NULL | 100002 | 10002 | B+ | 2 | | 100009 | Linda | King | ARTS | CSCI | 125 | 1018 | 100002 | 10002 | B+ | 2 | | 100111 | Cathy | Johanson | NULL | NULL | 0 | 1018 | 100002 | 10002 | B+ | 2 | | 2200000 | Bun | Yue | ITEC | CINF | 25 | 1011 | 100002 | 10002 | B+ | 2 | | 3330000 | Bunny | Yue | CINF | ITEC | 15 | 1011 | 100002 | 10002 | B+ | 2 | | 4440000 | Funny | Yue | COME | ITEC | 55 | 1011 | 100002 | 10002 | B+ | 2 | | 5550000 | Grumpy | Yue | COME | MUSI | 75 | 1221 | 100002 | 10002 | B+ | 2 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10003 | C | 0 | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100000 | 10003 | C | 0 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100000 | 10003 | C | 0 | | 100003 | Catherine | Lim | ITEC | CINF | 20 | NULL | 100000 | 10003 | C | 0 | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 100000 | 10003 | C | 0 | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100000 | 10003 | C | 0 | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100000 | 10003 | C | 0 | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 100000 | 10003 | C | 0 | | 100008 | Bill | Ching | ARTS | NULL | 90 | NULL | 100000 | 10003 | C | 0 | | 100009 | Linda | King | ARTS | CSCI | 125 | 1018 | 100000 | 10003 | C | 0 | | 100111 | Cathy | Johanson | NULL | NULL | 0 | 1018 | 100000 | 10003 | C | 0 | | 2200000 | Bun | Yue | ITEC | CINF | 25 | 1011 | 100000 | 10003 | C | 0 | | 3330000 | Bunny | Yue | CINF | ITEC | 15 | 1011 | 100000 | 10003 | C | 0 | | 4440000 | Funny | Yue | COME | ITEC | 55 | 1011 | 100000 | 10003 | C | 0 | | 5550000 | Grumpy | Yue | COME | MUSI | 75 | 1221 | 100000 | 10003 | C | 0 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100002 | 10003 | D | 4 | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100002 | 10003 | D | 4 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100002 | 10003 | D | 4 | | 100003 | Catherine | Lim | ITEC | CINF | 20 | NULL | 100002 | 10003 | D | 4 | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 100002 | 10003 | D | 4 | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100002 | 10003 | D | 4 | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100002 | 10003 | D | 4 | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 100002 | 10003 | D | 4 | | 100008 | Bill | Ching | ARTS | NULL | 90 | NULL | 100002 | 10003 | D | 4 | | 100009 | Linda | King | ARTS | CSCI | 125 | 1018 | 100002 | 10003 | D | 4 | | 100111 | Cathy | Johanson | NULL | NULL | 0 | 1018 | 100002 | 10003 | D | 4 | | 2200000 | Bun | Yue | ITEC | CINF | 25 | 1011 | 100002 | 10003 | D | 4 | | 3330000 | Bunny | Yue | CINF | ITEC | 15 | 1011 | 100002 | 10003 | D | 4 | | 4440000 | Funny | Yue | COME | ITEC | 55 | 1011 | 100002 | 10003 | D | 4 | | 5550000 | Grumpy | Yue | COME | MUSI | 75 | 1221 | 100002 | 10003 | D | 4 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100004 | 10003 | A | 0 | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100004 | 10003 | A | 0 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100004 | 10003 | A | 0 | | 100003 | Catherine | Lim | ITEC | CINF | 20 | NULL | 100004 | 10003 | A | 0 | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 100004 | 10003 | A | 0 | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100004 | 10003 | A | 0 | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100004 | 10003 | A | 0 | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 100004 | 10003 | A | 0 | | 100008 | Bill | Ching | ARTS | NULL | 90 | NULL | 100004 | 10003 | A | 0 | | 100009 | Linda | King | ARTS | CSCI | 125 | 1018 | 100004 | 10003 | A | 0 | | 100111 | Cathy | Johanson | NULL | NULL | 0 | 1018 | 100004 | 10003 | A | 0 | | 2200000 | Bun | Yue | ITEC | CINF | 25 | 1011 | 100004 | 10003 | A | 0 | | 3330000 | Bunny | Yue | CINF | ITEC | 15 | 1011 | 100004 | 10003 | A | 0 | | 4440000 | Funny | Yue | COME | ITEC | 55 | 1011 | 100004 | 10003 | A | 0 | | 5550000 | Grumpy | Yue | COME | MUSI | 75 | 1221 | 100004 | 10003 | A | 0 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100005 | 10003 | NULL | NULL | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100005 | 10003 | NULL | NULL | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100005 | 10003 | NULL | NULL | | 100003 | Catherine | Lim | ITEC | CINF | 20 | NULL | 100005 | 10003 | NULL | NULL | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 100005 | 10003 | NULL | NULL | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100005 | 10003 | NULL | NULL | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100005 | 10003 | NULL | NULL | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 100005 | 10003 | NULL | NULL | | 100008 | Bill | Ching | ARTS | NULL | 90 | NULL | 100005 | 10003 | NULL | NULL | | 100009 | Linda | King | ARTS | CSCI | 125 | 1018 | 100005 | 10003 | NULL | NULL | | 100111 | Cathy | Johanson | NULL | NULL | 0 | 1018 | 100005 | 10003 | NULL | NULL | | 2200000 | Bun | Yue | ITEC | CINF | 25 | 1011 | 100005 | 10003 | NULL | NULL | | 3330000 | Bunny | Yue | CINF | ITEC | 15 | 1011 | 100005 | 10003 | NULL | NULL | | 4440000 | Funny | Yue | COME | ITEC | 55 | 1011 | 100005 | 10003 | NULL | NULL | | 5550000 | Grumpy | Yue | COME | MUSI | 75 | 1221 | 100005 | 10003 | NULL | NULL | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10004 | A- | 1 | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100000 | 10004 | A- | 1 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100000 | 10004 | A- | 1 | | 100003 | Catherine | Lim | ITEC | CINF | 20 | NULL | 100000 | 10004 | A- | 1 | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 100000 | 10004 | A- | 1 | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100000 | 10004 | A- | 1 | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100000 | 10004 | A- | 1 | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 100000 | 10004 | A- | 1 | | 100008 | Bill | Ching | ARTS | NULL | 90 | NULL | 100000 | 10004 | A- | 1 | | 100009 | Linda | King | ARTS | CSCI | 125 | 1018 | 100000 | 10004 | A- | 1 | | 100111 | Cathy | Johanson | NULL | NULL | 0 | 1018 | 100000 | 10004 | A- | 1 | | 2200000 | Bun | Yue | ITEC | CINF | 25 | 1011 | 100000 | 10004 | A- | 1 | | 3330000 | Bunny | Yue | CINF | ITEC | 15 | 1011 | 100000 | 10004 | A- | 1 | | 4440000 | Funny | Yue | COME | ITEC | 55 | 1011 | 100000 | 10004 | A- | 1 | | 5550000 | Grumpy | Yue | COME | MUSI | 75 | 1221 | 100000 | 10004 | A- | 1 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100004 | 10004 | B+ | NULL | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100004 | 10004 | B+ | NULL | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100004 | 10004 | B+ | NULL | | 100003 | Catherine | Lim | ITEC | CINF | 20 | NULL | 100004 | 10004 | B+ | NULL | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 100004 | 10004 | B+ | NULL | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100004 | 10004 | B+ | NULL | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100004 | 10004 | B+ | NULL | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 100004 | 10004 | B+ | NULL | | 100008 | Bill | Ching | ARTS | NULL | 90 | NULL | 100004 | 10004 | B+ | NULL | | 100009 | Linda | King | ARTS | CSCI | 125 | 1018 | 100004 | 10004 | B+ | NULL | | 100111 | Cathy | Johanson | NULL | NULL | 0 | 1018 | 100004 | 10004 | B+ | NULL | | 2200000 | Bun | Yue | ITEC | CINF | 25 | 1011 | 100004 | 10004 | B+ | NULL | | 3330000 | Bunny | Yue | CINF | ITEC | 15 | 1011 | 100004 | 10004 | B+ | NULL | | 4440000 | Funny | Yue | COME | ITEC | 55 | 1011 | 100004 | 10004 | B+ | NULL | | 5550000 | Grumpy | Yue | COME | MUSI | 75 | 1221 | 100004 | 10004 | B+ | NULL | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100005 | 10004 | A- | 0 | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100005 | 10004 | A- | 0 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100005 | 10004 | A- | 0 | | 100003 | Catherine | Lim | ITEC | CINF | 20 | NULL | 100005 | 10004 | A- | 0 | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 100005 | 10004 | A- | 0 | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100005 | 10004 | A- | 0 | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100005 | 10004 | A- | 0 | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 100005 | 10004 | A- | 0 | | 100008 | Bill | Ching | ARTS | NULL | 90 | NULL | 100005 | 10004 | A- | 0 | | 100009 | Linda | King | ARTS | CSCI | 125 | 1018 | 100005 | 10004 | A- | 0 | | 100111 | Cathy | Johanson | NULL | NULL | 0 | 1018 | 100005 | 10004 | A- | 0 | | 2200000 | Bun | Yue | ITEC | CINF | 25 | 1011 | 100005 | 10004 | A- | 0 | | 3330000 | Bunny | Yue | CINF | ITEC | 15 | 1011 | 100005 | 10004 | A- | 0 | | 4440000 | Funny | Yue | COME | ITEC | 55 | 1011 | 100005 | 10004 | A- | 0 | | 5550000 | Grumpy | Yue | COME | MUSI | 75 | 1221 | 100005 | 10004 | A- | 0 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100006 | 10004 | C+ | NULL | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100006 | 10004 | C+ | NULL | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100006 | 10004 | C+ | NULL | | 100003 | Catherine | Lim | ITEC | CINF | 20 | NULL | 100006 | 10004 | C+ | NULL | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 100006 | 10004 | C+ | NULL | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100006 | 10004 | C+ | NULL | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100006 | 10004 | C+ | NULL | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 100006 | 10004 | C+ | NULL | | 100008 | Bill | Ching | ARTS | NULL | 90 | NULL | 100006 | 10004 | C+ | NULL | | 100009 | Linda | King | ARTS | CSCI | 125 | 1018 | 100006 | 10004 | C+ | NULL | | 100111 | Cathy | Johanson | NULL | NULL | 0 | 1018 | 100006 | 10004 | C+ | NULL | | 2200000 | Bun | Yue | ITEC | CINF | 25 | 1011 | 100006 | 10004 | C+ | NULL | | 3330000 | Bunny | Yue | CINF | ITEC | 15 | 1011 | 100006 | 10004 | C+ | NULL | | 4440000 | Funny | Yue | COME | ITEC | 55 | 1011 | 100006 | 10004 | C+ | NULL | | 5550000 | Grumpy | Yue | COME | MUSI | 75 | 1221 | 100006 | 10004 | C+ | NULL | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100005 | 10005 | A- | 0 | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100005 | 10005 | A- | 0 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100005 | 10005 | A- | 0 | | 100003 | Catherine | Lim | ITEC | CINF | 20 | NULL | 100005 | 10005 | A- | 0 | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 100005 | 10005 | A- | 0 | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100005 | 10005 | A- | 0 | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100005 | 10005 | A- | 0 | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 100005 | 10005 | A- | 0 | | 100008 | Bill | Ching | ARTS | NULL | 90 | NULL | 100005 | 10005 | A- | 0 | | 100009 | Linda | King | ARTS | CSCI | 125 | 1018 | 100005 | 10005 | A- | 0 | | 100111 | Cathy | Johanson | NULL | NULL | 0 | 1018 | 100005 | 10005 | A- | 0 | | 2200000 | Bun | Yue | ITEC | CINF | 25 | 1011 | 100005 | 10005 | A- | 0 | | 3330000 | Bunny | Yue | CINF | ITEC | 15 | 1011 | 100005 | 10005 | A- | 0 | | 4440000 | Funny | Yue | COME | ITEC | 55 | 1011 | 100005 | 10005 | A- | 0 | | 5550000 | Grumpy | Yue | COME | MUSI | 75 | 1221 | 100005 | 10005 | A- | 0 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100006 | 10005 | A | NULL | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100006 | 10005 | A | NULL | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100006 | 10005 | A | NULL | | 100003 | Catherine | Lim | ITEC | CINF | 20 | NULL | 100006 | 10005 | A | NULL | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 100006 | 10005 | A | NULL | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100006 | 10005 | A | NULL | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100006 | 10005 | A | NULL | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 100006 | 10005 | A | NULL | | 100008 | Bill | Ching | ARTS | NULL | 90 | NULL | 100006 | 10005 | A | NULL | | 100009 | Linda | King | ARTS | CSCI | 125 | 1018 | 100006 | 10005 | A | NULL | | 100111 | Cathy | Johanson | NULL | NULL | 0 | 1018 | 100006 | 10005 | A | NULL | | 2200000 | Bun | Yue | ITEC | CINF | 25 | 1011 | 100006 | 10005 | A | NULL | | 3330000 | Bunny | Yue | CINF | ITEC | 15 | 1011 | 100006 | 10005 | A | NULL | | 4440000 | Funny | Yue | COME | ITEC | 55 | 1011 | 100006 | 10005 | A | NULL | | 5550000 | Grumpy | Yue | COME | MUSI | 75 | 1221 | 100006 | 10005 | A | NULL | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100005 | 10006 | B+ | NULL | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100005 | 10006 | B+ | NULL | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100005 | 10006 | B+ | NULL | | 100003 | Catherine | Lim | ITEC | CINF | 20 | NULL | 100005 | 10006 | B+ | NULL | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 100005 | 10006 | B+ | NULL | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100005 | 10006 | B+ | NULL | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100005 | 10006 | B+ | NULL | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 100005 | 10006 | B+ | NULL | | 100008 | Bill | Ching | ARTS | NULL | 90 | NULL | 100005 | 10006 | B+ | NULL | | 100009 | Linda | King | ARTS | CSCI | 125 | 1018 | 100005 | 10006 | B+ | NULL | | 100111 | Cathy | Johanson | NULL | NULL | 0 | 1018 | 100005 | 10006 | B+ | NULL | | 2200000 | Bun | Yue | ITEC | CINF | 25 | 1011 | 100005 | 10006 | B+ | NULL | | 3330000 | Bunny | Yue | CINF | ITEC | 15 | 1011 | 100005 | 10006 | B+ | NULL | | 4440000 | Funny | Yue | COME | ITEC | 55 | 1011 | 100005 | 10006 | B+ | NULL | | 5550000 | Grumpy | Yue | COME | MUSI | 75 | 1221 | 100005 | 10006 | B+ | NULL | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100007 | 10007 | F | 4 | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100007 | 10007 | F | 4 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100007 | 10007 | F | 4 | | 100003 | Catherine | Lim | ITEC | CINF | 20 | NULL | 100007 | 10007 | F | 4 | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 100007 | 10007 | F | 4 | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100007 | 10007 | F | 4 | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100007 | 10007 | F | 4 | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 100007 | 10007 | F | 4 | | 100008 | Bill | Ching | ARTS | NULL | 90 | NULL | 100007 | 10007 | F | 4 | | 100009 | Linda | King | ARTS | CSCI | 125 | 1018 | 100007 | 10007 | F | 4 | | 100111 | Cathy | Johanson | NULL | NULL | 0 | 1018 | 100007 | 10007 | F | 4 | | 2200000 | Bun | Yue | ITEC | CINF | 25 | 1011 | 100007 | 10007 | F | 4 | | 3330000 | Bunny | Yue | CINF | ITEC | 15 | 1011 | 100007 | 10007 | F | 4 | | 4440000 | Funny | Yue | COME | ITEC | 55 | 1011 | 100007 | 10007 | F | 4 | | 5550000 | Grumpy | Yue | COME | MUSI | 75 | 1221 | 100007 | 10007 | F | 4 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100008 | 10007 | C- | 0 | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100008 | 10007 | C- | 0 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100008 | 10007 | C- | 0 | | 100003 | Catherine | Lim | ITEC | CINF | 20 | NULL | 100008 | 10007 | C- | 0 | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 100008 | 10007 | C- | 0 | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100008 | 10007 | C- | 0 | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100008 | 10007 | C- | 0 | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 100008 | 10007 | C- | 0 | | 100008 | Bill | Ching | ARTS | NULL | 90 | NULL | 100008 | 10007 | C- | 0 | | 100009 | Linda | King | ARTS | CSCI | 125 | 1018 | 100008 | 10007 | C- | 0 | | 100111 | Cathy | Johanson | NULL | NULL | 0 | 1018 | 100008 | 10007 | C- | 0 | | 2200000 | Bun | Yue | ITEC | CINF | 25 | 1011 | 100008 | 10007 | C- | 0 | | 3330000 | Bunny | Yue | CINF | ITEC | 15 | 1011 | 100008 | 10007 | C- | 0 | | 4440000 | Funny | Yue | COME | ITEC | 55 | 1011 | 100008 | 10007 | C- | 0 | | 5550000 | Grumpy | Yue | COME | MUSI | 75 | 1221 | 100008 | 10007 | C- | 0 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100007 | 10008 | A- | 0 | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100007 | 10008 | A- | 0 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100007 | 10008 | A- | 0 | | 100003 | Catherine | Lim | ITEC | CINF | 20 | NULL | 100007 | 10008 | A- | 0 | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 100007 | 10008 | A- | 0 | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100007 | 10008 | A- | 0 | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100007 | 10008 | A- | 0 | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 100007 | 10008 | A- | 0 | | 100008 | Bill | Ching | ARTS | NULL | 90 | NULL | 100007 | 10008 | A- | 0 | | 100009 | Linda | King | ARTS | CSCI | 125 | 1018 | 100007 | 10008 | A- | 0 | | 100111 | Cathy | Johanson | NULL | NULL | 0 | 1018 | 100007 | 10008 | A- | 0 | | 2200000 | Bun | Yue | ITEC | CINF | 25 | 1011 | 100007 | 10008 | A- | 0 | | 3330000 | Bunny | Yue | CINF | ITEC | 15 | 1011 | 100007 | 10008 | A- | 0 | | 4440000 | Funny | Yue | COME | ITEC | 55 | 1011 | 100007 | 10008 | A- | 0 | | 5550000 | Grumpy | Yue | COME | MUSI | 75 | 1221 | 100007 | 10008 | A- | 0 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 11001 | D | 4 | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100000 | 11001 | D | 4 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100000 | 11001 | D | 4 | | 100003 | Catherine | Lim | ITEC | CINF | 20 | NULL | 100000 | 11001 | D | 4 | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 100000 | 11001 | D | 4 | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100000 | 11001 | D | 4 | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100000 | 11001 | D | 4 | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 100000 | 11001 | D | 4 | | 100008 | Bill | Ching | ARTS | NULL | 90 | NULL | 100000 | 11001 | D | 4 | | 100009 | Linda | King | ARTS | CSCI | 125 | 1018 | 100000 | 11001 | D | 4 | | 100111 | Cathy | Johanson | NULL | NULL | 0 | 1018 | 100000 | 11001 | D | 4 | | 2200000 | Bun | Yue | ITEC | CINF | 25 | 1011 | 100000 | 11001 | D | 4 | | 3330000 | Bunny | Yue | CINF | ITEC | 15 | 1011 | 100000 | 11001 | D | 4 | | 4440000 | Funny | Yue | COME | ITEC | 55 | 1011 | 100000 | 11001 | D | 4 | | 5550000 | Grumpy | Yue | COME | MUSI | 75 | 1221 | 100000 | 11001 | D | 4 | +---------+-----------+----------+-------+-------+------+---------+--------+---------+-------+----------+ 330 rows in set (0.004 sec) MariaDB [toyu]> MariaDB [toyu]> SELECT DISTINCT s.*, e.* -- [3] -> FROM student AS s, enroll AS e -- [1] -> WHERE s.stuId = e.stuId -- [2] -> ; +--------+---------+---------+-------+-------+------+---------+--------+---------+-------+----------+ | stuId | fname | lname | major | minor | ach | advisor | stuId | classId | grade | n_alerts | +--------+---------+---------+-------+-------+------+---------+--------+---------+-------+----------+ | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10000 | A | 0 | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100001 | 10000 | NULL | NULL | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100002 | 10000 | B- | 3 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10001 | A | 2 | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100001 | 10001 | A- | 0 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10002 | B+ | 1 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100002 | 10002 | B+ | 2 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10003 | C | 0 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100002 | 10003 | D | 4 | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 100004 | 10003 | A | 0 | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100005 | 10003 | NULL | NULL | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10004 | A- | 1 | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 100004 | 10004 | B+ | NULL | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100005 | 10004 | A- | 0 | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100006 | 10004 | C+ | NULL | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100005 | 10005 | A- | 0 | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100006 | 10005 | A | NULL | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100005 | 10006 | B+ | NULL | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 100007 | 10007 | F | 4 | | 100008 | Bill | Ching | ARTS | NULL | 90 | NULL | 100008 | 10007 | C- | 0 | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 100007 | 10008 | A- | 0 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 11001 | D | 4 | +--------+---------+---------+-------+-------+------+---------+--------+---------+-------+----------+ 22 rows in set (0.001 sec) MariaDB [toyu]> SELECT DISTINCT s.*, e.* -- [3] -> FROM student AS s INNER JOIN enroll AS e ON (s.stuId = e.stuId); -- [1] +--------+---------+---------+-------+-------+------+---------+--------+---------+-------+----------+ | stuId | fname | lname | major | minor | ach | advisor | stuId | classId | grade | n_alerts | +--------+---------+---------+-------+-------+------+---------+--------+---------+-------+----------+ | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10000 | A | 0 | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100001 | 10000 | NULL | NULL | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100002 | 10000 | B- | 3 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10001 | A | 2 | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100001 | 10001 | A- | 0 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10002 | B+ | 1 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100002 | 10002 | B+ | 2 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10003 | C | 0 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100002 | 10003 | D | 4 | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 100004 | 10003 | A | 0 | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100005 | 10003 | NULL | NULL | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10004 | A- | 1 | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 100004 | 10004 | B+ | NULL | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100005 | 10004 | A- | 0 | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100006 | 10004 | C+ | NULL | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100005 | 10005 | A- | 0 | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100006 | 10005 | A | NULL | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100005 | 10006 | B+ | NULL | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 100007 | 10007 | F | 4 | | 100008 | Bill | Ching | ARTS | NULL | 90 | NULL | 100008 | 10007 | C- | 0 | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 100007 | 10008 | A- | 0 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 11001 | D | 4 | +--------+---------+---------+-------+-------+------+---------+--------+---------+-------+----------+ 22 rows in set (0.001 sec) MariaDB [toyu]> SELECT DISTINCT s.*, e.* -- [3] -> FROM student AS s INNER JOIN enroll AS e ON (s.stuId = e.stuId); -- [1] +--------+---------+---------+-------+-------+------+---------+--------+---------+-------+----------+ | stuId | fname | lname | major | minor | ach | advisor | stuId | classId | grade | n_alerts | +--------+---------+---------+-------+-------+------+---------+--------+---------+-------+----------+ | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10000 | A | 0 | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100001 | 10000 | NULL | NULL | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100002 | 10000 | B- | 3 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10001 | A | 2 | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100001 | 10001 | A- | 0 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10002 | B+ | 1 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100002 | 10002 | B+ | 2 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10003 | C | 0 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100002 | 10003 | D | 4 | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 100004 | 10003 | A | 0 | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100005 | 10003 | NULL | NULL | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10004 | A- | 1 | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 100004 | 10004 | B+ | NULL | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100005 | 10004 | A- | 0 | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100006 | 10004 | C+ | NULL | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100005 | 10005 | A- | 0 | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100006 | 10005 | A | NULL | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100005 | 10006 | B+ | NULL | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 100007 | 10007 | F | 4 | | 100008 | Bill | Ching | ARTS | NULL | 90 | NULL | 100008 | 10007 | C- | 0 | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 100007 | 10008 | A- | 0 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 11001 | D | 4 | +--------+---------+---------+-------+-------+------+---------+--------+---------+-------+----------+ 22 rows in set (0.002 sec) MariaDB [toyu]> WHERE s.minor = 'CINF' OR s.minor = 'ITEC' -- [2] -> ; 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 'WHERE s.minor = 'CINF' OR s.minor = 'ITEC'' at line 1 MariaDB [toyu]> SELECT DISTINCT s.*, e.* -- [3] -> FROM student AS s INNER JOIN enroll AS e ON (s.stuId = e.stuId) -- [1] -> WHERE s.minor = 'CINF' OR s.minor = 'ITEC' -- [2] -> ; +--------+---------+---------+-------+-------+------+---------+--------+---------+-------+----------+ | stuId | fname | lname | major | minor | ach | advisor | stuId | classId | grade | n_alerts | +--------+---------+---------+-------+-------+------+---------+--------+---------+-------+----------+ | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10000 | A | 0 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10001 | A | 2 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10002 | B+ | 1 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10003 | C | 0 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10004 | A- | 1 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 11001 | D | 4 | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100001 | 10000 | NULL | NULL | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100001 | 10001 | A- | 0 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100002 | 10000 | B- | 3 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100002 | 10002 | B+ | 2 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100002 | 10003 | D | 4 | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100006 | 10004 | C+ | NULL | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100006 | 10005 | A | NULL | +--------+---------+---------+-------+-------+------+---------+--------+---------+-------+----------+ 13 rows in set (0.001 sec) MariaDB [toyu]> MariaDB [toyu]> SELECT DISTINCT s.fname, s.lname, e.classId, e.grade -- [3] -> FROM student AS s INNER JOIN enroll AS e ON (s.stuId = e.stuId) -- [1] -> WHERE s.minor = 'CINF' OR s.minor = 'ITEC' -- [2] -> ; +---------+---------+---------+-------+ | 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.001 sec) MariaDB [toyu]> SELECT DISTINCT s.stuId, -> CONCAT(s.fname, s.lname), -> ':', -> e.classId, e.grade -- [3] -> FROM student AS s INNER JOIN enroll AS e ON (s.stuId = e.stuId) -- [1] -> WHERE s.minor = 'CINF' OR s.minor = 'ITEC' -- [2] -> ; +--------+--------------------------+---+---------+-------+ | stuId | CONCAT(s.fname, s.lname) | : | classId | grade | +--------+--------------------------+---+---------+-------+ | 100000 | TonyHawk | : | 10000 | A | | 100000 | TonyHawk | : | 10001 | A | | 100000 | TonyHawk | : | 10002 | B+ | | 100000 | TonyHawk | : | 10003 | C | | 100000 | TonyHawk | : | 10004 | A- | | 100000 | TonyHawk | : | 11001 | D | | 100001 | MaryHawk | : | 10000 | NULL | | 100001 | MaryHawk | : | 10001 | A- | | 100002 | DavidHawk | : | 10000 | B- | | 100002 | DavidHawk | : | 10002 | B+ | | 100002 | DavidHawk | : | 10003 | D | | 100006 | LillianJohnson | : | 10004 | C+ | | 100006 | LillianJohnson | : | 10005 | A | +--------+--------------------------+---+---------+-------+ 13 rows in set (0.003 sec) MariaDB [toyu]> SELECT DISTINCT s.stuId, -> CONCAT(s.major, ': ', s.fname, ' ', s.lname) AS `major:student`, -> ':', -> e.classId, e.grade -- [3] -> FROM student AS s INNER JOIN enroll AS e ON (s.stuId = e.stuId) -- [1] -> WHERE s.minor = 'CINF' OR s.minor = 'ITEC' -- [2] -> ; +--------+-----------------------+---+---------+-------+ | stuId | major:student | : | classId | grade | +--------+-----------------------+---+---------+-------+ | 100000 | CSCI: Tony Hawk | : | 10000 | A | | 100000 | CSCI: Tony Hawk | : | 10001 | A | | 100000 | CSCI: Tony Hawk | : | 10002 | B+ | | 100000 | CSCI: Tony Hawk | : | 10003 | C | | 100000 | CSCI: Tony Hawk | : | 10004 | A- | | 100000 | CSCI: Tony Hawk | : | 11001 | D | | 100001 | CSCI: Mary Hawk | : | 10000 | NULL | | 100001 | CSCI: Mary Hawk | : | 10001 | A- | | 100002 | CSCI: David Hawk | : | 10000 | B- | | 100002 | CSCI: David Hawk | : | 10002 | B+ | | 100002 | CSCI: David Hawk | : | 10003 | D | | 100006 | CINF: Lillian Johnson | : | 10004 | C+ | | 100006 | CINF: Lillian Johnson | : | 10005 | A | +--------+-----------------------+---+---------+-------+ 13 rows in set (0.001 sec) MariaDB [toyu]> SELECT DISTINCT s.stuId, -> CONCAT(s.major, ': ', s.fname, ' ', s.lname) AS major: student, -> ':', -> e.classId, e.grade -- [3] -> FROM student AS s INNER JOIN enroll AS e ON (s.stuId = e.stuId) -- [1] -> WHERE s.minor = 'CINF' OR s.minor = 'ITEC' -- [2] -> ; 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 ': student, ':', e.classId, e.grade FROM student AS s INNER JOIN...' at line 2 MariaDB [toyu]> SELECT DISTINCT s.stuId, -> CONCAT(s.major, ': ', s.fname, ' ', s.lname) AS `major: student`, -> ':', -> e.classId, e.grade -- [3] -> FROM student AS s INNER JOIN enroll AS e ON (s.stuId = e.stuId) -- [1] -> WHERE s.minor = 'CINF' OR s.minor = 'ITEC' -- [2] -> ; +--------+-----------------------+---+---------+-------+ | stuId | major: student | : | classId | grade | +--------+-----------------------+---+---------+-------+ | 100000 | CSCI: Tony Hawk | : | 10000 | A | | 100000 | CSCI: Tony Hawk | : | 10001 | A | | 100000 | CSCI: Tony Hawk | : | 10002 | B+ | | 100000 | CSCI: Tony Hawk | : | 10003 | C | | 100000 | CSCI: Tony Hawk | : | 10004 | A- | | 100000 | CSCI: Tony Hawk | : | 11001 | D | | 100001 | CSCI: Mary Hawk | : | 10000 | NULL | | 100001 | CSCI: Mary Hawk | : | 10001 | A- | | 100002 | CSCI: David Hawk | : | 10000 | B- | | 100002 | CSCI: David Hawk | : | 10002 | B+ | | 100002 | CSCI: David Hawk | : | 10003 | D | | 100006 | CINF: Lillian Johnson | : | 10004 | C+ | | 100006 | CINF: Lillian Johnson | : | 10005 | A | +--------+-----------------------+---+---------+-------+ 13 rows in set (0.001 sec) MariaDB [toyu]> notee