MariaDB [toyu]> source createtoyu.sql Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 8 rows affected (0.223 sec) Query OK, 1 row affected (0.003 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.000 sec) 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.000 sec) 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.022 sec) Query OK, 0 rows affected, 1 warning (0.027 sec) Query OK, 0 rows affected, 1 warning (0.040 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, 1 warning (0.028 sec) Query OK, 0 rows affected, 1 warning (0.032 sec) Query OK, 0 rows affected, 1 warning (0.036 sec) Query OK, 0 rows affected (0.012 sec) Query OK, 0 rows affected (0.011 sec) Query OK, 0 rows affected (0.009 sec) Query OK, 0 rows affected (0.010 sec) Query OK, 0 rows affected (0.014 sec) Query OK, 15 rows affected (0.006 sec) Records: 15 Duplicates: 0 Warnings: 0 Query OK, 4 rows affected (0.007 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.008 sec) Records: 11 Duplicates: 0 Warnings: 0 Query OK, 11 rows affected (0.013 sec) Records: 11 Duplicates: 0 Warnings: 0 Query OK, 14 rows affected (0.011 sec) Records: 14 Duplicates: 0 Warnings: 0 Query OK, 11 rows affected (0.007 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.000 sec) Query OK, 0 rows affected (0.000 sec) MariaDB [toyu]> SELECT * FROM student -> WHERE stuId = 100000; +--------+-------+-------+-------+-------+------+---------+ | stuId | fname | lname | major | minor | ach | advisor | +--------+-------+-------+-------+-------+------+---------+ | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | +--------+-------+-------+-------+-------+------+---------+ 1 row in set (0.001 sec) MariaDB [toyu]> SELECT * FROM student -> WHERE major = 'CSCI'; +--------+-------+-------+-------+-------+------+---------+ | 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.000 sec) MariaDB [toyu]> INSERT INTO Student(stuId, fname, lname, major, minor, ach, advisor) VALUES -> (100000,'Bun','YUe','CSCI','MATH',40,1011); ERROR 1062 (23000): Duplicate entry '100000' for key 'PRIMARY' MariaDB [toyu]> MariaDB [toyu]> INSERT INTO Student(stuId, fname, lname, major, minor, ach, advisor) VALUES -> (200000,'Bun','YUe','CSCI','MATH',40,1011); Query OK, 1 row affected (0.004 sec) MariaDB [toyu]> SELECT * FROM student -> WHERE stuId = 100000; +--------+-------+-------+-------+-------+------+---------+ | stuId | fname | lname | major | minor | ach | advisor | +--------+-------+-------+-------+-------+------+---------+ | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | +--------+-------+-------+-------+-------+------+---------+ 1 row in set (0.001 sec) MariaDB [toyu]> MariaDB [toyu]> SELECT * FROM enroll -> WHERE stuId = 100000; +--------+---------+-------+----------+ | stuId | classId | grade | n_alerts | +--------+---------+-------+----------+ | 100000 | 10000 | A | 0 | | 100000 | 10001 | A | 2 | | 100000 | 10002 | B+ | 1 | | 100000 | 10003 | C | 0 | | 100000 | 10004 | A- | 1 | | 100000 | 11001 | D | 4 | +--------+---------+-------+----------+ 6 rows in set (0.000 sec) MariaDB [toyu]> INSERT INTO Student(stuId, fname, lname, major, minor, ach, advisor) VALUES -> (300000,'Bun_C1','Yue','MAGI','MATH',40,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 -> ('MAGI','Magic','CSE',4), -> ; 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 Department(deptCode, deptName, schoolCode, numStaff) VALUES -> ('MAGI','Magic','CSE,4); '> '; 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 Department(deptCode, deptName, schoolCode, numStaff) VALUES -> ('MAGI','Magic','CSE',4); Query OK, 1 row affected (0.005 sec) MariaDB [toyu]> INSERT INTO Student(stuId, fname, lname, major, minor, ach, advisor) VALUES -> (300000,'Bun_C1','Yue','MAGI','MATH',40,1011); Query OK, 1 row affected (0.002 sec) MariaDB [toyu]> INSERT INTO Student(stuId, fname, lname, major, minor, ach, advisor) VALUES -> (500000,'Bun_C1123','Yue','MAGI','MUSI',40,1565); 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',14); Query OK, 1 row affected (0.002 sec) MariaDB [toyu]> INSERT INTO Student(stuId, fname, lname, major, minor, ach, advisor) VALUES -> (500000,'Bun_C1123','Yue','MAGI','MUSI',40,1565); 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 -> (1565,'Joe','Smith','MUSI','Professor'); Query OK, 1 row affected (0.003 sec) MariaDB [toyu]> INSERT INTO Student(stuId, fname, lname, major, minor, ach, advisor) VALUES -> (500000,'Bun_C1123','Yue','MAGI','MUSI',40,1565); Query OK, 1 row affected (0.002 sec) MariaDB [toyu]> SELECT DISTINCT s.fname, s.lname, e.classId, e.grade -- [3] -> FROM student AS s, enroll AS e; +-----------+----------+---------+-------+ | fname | lname | classId | grade | +-----------+----------+---------+-------+ | Tony | Hawk | 10000 | NULL | | Mary | Hawk | 10000 | NULL | | David | Hawk | 10000 | NULL | | Catherine | Lim | 10000 | NULL | | Larry | Johnson | 10000 | NULL | | Linda | Johnson | 10000 | NULL | | Lillian | Johnson | 10000 | NULL | | Ben | Zico | 10000 | NULL | | Bill | Ching | 10000 | NULL | | Linda | King | 10000 | NULL | | Cathy | Johanson | 10000 | NULL | | Bun | YUe | 10000 | NULL | | Bun_C1 | Yue | 10000 | NULL | | Bun_C1123 | Yue | 10000 | NULL | | Tony | Hawk | 10003 | NULL | | Mary | Hawk | 10003 | NULL | | David | Hawk | 10003 | NULL | | Catherine | Lim | 10003 | NULL | | Larry | Johnson | 10003 | NULL | | Linda | Johnson | 10003 | NULL | | Lillian | Johnson | 10003 | NULL | | Ben | Zico | 10003 | NULL | | Bill | Ching | 10003 | NULL | | Linda | King | 10003 | NULL | | Cathy | Johanson | 10003 | NULL | | Bun | YUe | 10003 | NULL | | Bun_C1 | Yue | 10003 | NULL | | Bun_C1123 | Yue | 10003 | NULL | | Tony | Hawk | 10000 | A | | Mary | Hawk | 10000 | A | | David | Hawk | 10000 | A | | Catherine | Lim | 10000 | A | | Larry | Johnson | 10000 | A | | Linda | Johnson | 10000 | A | | Lillian | Johnson | 10000 | A | | Ben | Zico | 10000 | A | | Bill | Ching | 10000 | A | | Linda | King | 10000 | A | | Cathy | Johanson | 10000 | A | | Bun | YUe | 10000 | A | | Bun_C1 | Yue | 10000 | A | | Bun_C1123 | Yue | 10000 | A | | Tony | Hawk | 10001 | A | | Mary | Hawk | 10001 | A | | David | Hawk | 10001 | A | | Catherine | Lim | 10001 | A | | Larry | Johnson | 10001 | A | | Linda | Johnson | 10001 | A | | Lillian | Johnson | 10001 | A | | Ben | Zico | 10001 | A | | Bill | Ching | 10001 | A | | Linda | King | 10001 | A | | Cathy | Johanson | 10001 | A | | Bun | YUe | 10001 | A | | Bun_C1 | Yue | 10001 | A | | Bun_C1123 | Yue | 10001 | A | | Tony | Hawk | 10003 | A | | Mary | Hawk | 10003 | A | | David | Hawk | 10003 | A | | Catherine | Lim | 10003 | A | | Larry | Johnson | 10003 | A | | Linda | Johnson | 10003 | A | | Lillian | Johnson | 10003 | A | | Ben | Zico | 10003 | A | | Bill | Ching | 10003 | A | | Linda | King | 10003 | A | | Cathy | Johanson | 10003 | A | | Bun | YUe | 10003 | A | | Bun_C1 | Yue | 10003 | A | | Bun_C1123 | Yue | 10003 | A | | Tony | Hawk | 10005 | A | | Mary | Hawk | 10005 | A | | David | Hawk | 10005 | A | | Catherine | Lim | 10005 | A | | Larry | Johnson | 10005 | A | | Linda | Johnson | 10005 | A | | Lillian | Johnson | 10005 | A | | Ben | Zico | 10005 | A | | Bill | Ching | 10005 | A | | Linda | King | 10005 | A | | Cathy | Johanson | 10005 | A | | Bun | YUe | 10005 | A | | Bun_C1 | Yue | 10005 | A | | Bun_C1123 | Yue | 10005 | A | | Tony | Hawk | 10001 | A- | | Mary | Hawk | 10001 | A- | | David | Hawk | 10001 | A- | | Catherine | Lim | 10001 | A- | | Larry | Johnson | 10001 | A- | | Linda | Johnson | 10001 | A- | | Lillian | Johnson | 10001 | A- | | Ben | Zico | 10001 | A- | | Bill | Ching | 10001 | A- | | Linda | King | 10001 | A- | | Cathy | Johanson | 10001 | A- | | Bun | YUe | 10001 | A- | | Bun_C1 | Yue | 10001 | A- | | Bun_C1123 | Yue | 10001 | A- | | Tony | Hawk | 10004 | A- | | Mary | Hawk | 10004 | A- | | David | Hawk | 10004 | A- | | Catherine | Lim | 10004 | A- | | Larry | Johnson | 10004 | A- | | Linda | Johnson | 10004 | A- | | Lillian | Johnson | 10004 | A- | | Ben | Zico | 10004 | A- | | Bill | Ching | 10004 | A- | | Linda | King | 10004 | A- | | Cathy | Johanson | 10004 | A- | | Bun | YUe | 10004 | A- | | Bun_C1 | Yue | 10004 | A- | | Bun_C1123 | Yue | 10004 | A- | | Tony | Hawk | 10005 | A- | | Mary | Hawk | 10005 | A- | | David | Hawk | 10005 | A- | | Catherine | Lim | 10005 | A- | | Larry | Johnson | 10005 | A- | | Linda | Johnson | 10005 | A- | | Lillian | Johnson | 10005 | A- | | Ben | Zico | 10005 | A- | | Bill | Ching | 10005 | A- | | Linda | King | 10005 | A- | | Cathy | Johanson | 10005 | A- | | Bun | YUe | 10005 | A- | | Bun_C1 | Yue | 10005 | A- | | Bun_C1123 | Yue | 10005 | A- | | Tony | Hawk | 10008 | A- | | Mary | Hawk | 10008 | A- | | David | Hawk | 10008 | A- | | Catherine | Lim | 10008 | A- | | Larry | Johnson | 10008 | A- | | Linda | Johnson | 10008 | A- | | Lillian | Johnson | 10008 | A- | | Ben | Zico | 10008 | A- | | Bill | Ching | 10008 | A- | | Linda | King | 10008 | A- | | Cathy | Johanson | 10008 | A- | | Bun | YUe | 10008 | A- | | Bun_C1 | Yue | 10008 | A- | | Bun_C1123 | Yue | 10008 | A- | | Tony | Hawk | 10002 | B+ | | Mary | Hawk | 10002 | B+ | | David | Hawk | 10002 | B+ | | Catherine | Lim | 10002 | B+ | | Larry | Johnson | 10002 | B+ | | Linda | Johnson | 10002 | B+ | | Lillian | Johnson | 10002 | B+ | | Ben | Zico | 10002 | B+ | | Bill | Ching | 10002 | B+ | | Linda | King | 10002 | B+ | | Cathy | Johanson | 10002 | B+ | | Bun | YUe | 10002 | B+ | | Bun_C1 | Yue | 10002 | B+ | | Bun_C1123 | Yue | 10002 | B+ | | Tony | Hawk | 10004 | B+ | | Mary | Hawk | 10004 | B+ | | David | Hawk | 10004 | B+ | | Catherine | Lim | 10004 | B+ | | Larry | Johnson | 10004 | B+ | | Linda | Johnson | 10004 | B+ | | Lillian | Johnson | 10004 | B+ | | Ben | Zico | 10004 | B+ | | Bill | Ching | 10004 | B+ | | Linda | King | 10004 | B+ | | Cathy | Johanson | 10004 | B+ | | Bun | YUe | 10004 | B+ | | Bun_C1 | Yue | 10004 | B+ | | Bun_C1123 | Yue | 10004 | B+ | | Tony | Hawk | 10006 | B+ | | Mary | Hawk | 10006 | B+ | | David | Hawk | 10006 | B+ | | Catherine | Lim | 10006 | B+ | | Larry | Johnson | 10006 | B+ | | Linda | Johnson | 10006 | B+ | | Lillian | Johnson | 10006 | B+ | | Ben | Zico | 10006 | B+ | | Bill | Ching | 10006 | B+ | | Linda | King | 10006 | B+ | | Cathy | Johanson | 10006 | B+ | | Bun | YUe | 10006 | B+ | | Bun_C1 | Yue | 10006 | B+ | | Bun_C1123 | Yue | 10006 | B+ | | Tony | Hawk | 10000 | B- | | Mary | Hawk | 10000 | B- | | David | Hawk | 10000 | B- | | Catherine | Lim | 10000 | B- | | Larry | Johnson | 10000 | B- | | Linda | Johnson | 10000 | B- | | Lillian | Johnson | 10000 | B- | | Ben | Zico | 10000 | B- | | Bill | Ching | 10000 | B- | | Linda | King | 10000 | B- | | Cathy | Johanson | 10000 | B- | | Bun | YUe | 10000 | B- | | Bun_C1 | Yue | 10000 | B- | | Bun_C1123 | Yue | 10000 | B- | | Tony | Hawk | 10003 | C | | Mary | Hawk | 10003 | C | | David | Hawk | 10003 | C | | Catherine | Lim | 10003 | C | | Larry | Johnson | 10003 | C | | Linda | Johnson | 10003 | C | | Lillian | Johnson | 10003 | C | | Ben | Zico | 10003 | C | | Bill | Ching | 10003 | C | | Linda | King | 10003 | C | | Cathy | Johanson | 10003 | C | | Bun | YUe | 10003 | C | | Bun_C1 | Yue | 10003 | C | | Bun_C1123 | Yue | 10003 | C | | Tony | Hawk | 10004 | C+ | | Mary | Hawk | 10004 | C+ | | David | Hawk | 10004 | C+ | | Catherine | Lim | 10004 | C+ | | Larry | Johnson | 10004 | C+ | | Linda | Johnson | 10004 | C+ | | Lillian | Johnson | 10004 | C+ | | Ben | Zico | 10004 | C+ | | Bill | Ching | 10004 | C+ | | Linda | King | 10004 | C+ | | Cathy | Johanson | 10004 | C+ | | Bun | YUe | 10004 | C+ | | Bun_C1 | Yue | 10004 | C+ | | Bun_C1123 | Yue | 10004 | C+ | | Tony | Hawk | 10007 | C- | | Mary | Hawk | 10007 | C- | | David | Hawk | 10007 | C- | | Catherine | Lim | 10007 | C- | | Larry | Johnson | 10007 | C- | | Linda | Johnson | 10007 | C- | | Lillian | Johnson | 10007 | C- | | Ben | Zico | 10007 | C- | | Bill | Ching | 10007 | C- | | Linda | King | 10007 | C- | | Cathy | Johanson | 10007 | C- | | Bun | YUe | 10007 | C- | | Bun_C1 | Yue | 10007 | C- | | Bun_C1123 | Yue | 10007 | C- | | Tony | Hawk | 10003 | D | | Mary | Hawk | 10003 | D | | David | Hawk | 10003 | D | | Catherine | Lim | 10003 | D | | Larry | Johnson | 10003 | D | | Linda | Johnson | 10003 | D | | Lillian | Johnson | 10003 | D | | Ben | Zico | 10003 | D | | Bill | Ching | 10003 | D | | Linda | King | 10003 | D | | Cathy | Johanson | 10003 | D | | Bun | YUe | 10003 | D | | Bun_C1 | Yue | 10003 | D | | Bun_C1123 | Yue | 10003 | D | | Tony | Hawk | 11001 | D | | Mary | Hawk | 11001 | D | | David | Hawk | 11001 | D | | Catherine | Lim | 11001 | D | | Larry | Johnson | 11001 | D | | Linda | Johnson | 11001 | D | | Lillian | Johnson | 11001 | D | | Ben | Zico | 11001 | D | | Bill | Ching | 11001 | D | | Linda | King | 11001 | D | | Cathy | Johanson | 11001 | D | | Bun | YUe | 11001 | D | | Bun_C1 | Yue | 11001 | D | | Bun_C1123 | Yue | 11001 | D | | Tony | Hawk | 10007 | F | | Mary | Hawk | 10007 | F | | David | Hawk | 10007 | F | | Catherine | Lim | 10007 | F | | Larry | Johnson | 10007 | F | | Linda | Johnson | 10007 | F | | Lillian | Johnson | 10007 | F | | Ben | Zico | 10007 | F | | Bill | Ching | 10007 | F | | Linda | King | 10007 | F | | Cathy | Johanson | 10007 | F | | Bun | YUe | 10007 | F | | Bun_C1 | Yue | 10007 | F | | Bun_C1123 | Yue | 10007 | F | +-----------+----------+---------+-------+ 280 rows in set (0.002 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 | | 200000 | Bun | YUe | CSCI | MATH | 40 | 1011 | 100000 | 10000 | A | 0 | | 300000 | Bun_C1 | Yue | MAGI | MATH | 40 | 1011 | 100000 | 10000 | A | 0 | | 500000 | Bun_C1123 | Yue | MAGI | MUSI | 40 | 1565 | 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 | | 200000 | Bun | YUe | CSCI | MATH | 40 | 1011 | 100001 | 10000 | NULL | NULL | | 300000 | Bun_C1 | Yue | MAGI | MATH | 40 | 1011 | 100001 | 10000 | NULL | NULL | | 500000 | Bun_C1123 | Yue | MAGI | MUSI | 40 | 1565 | 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 | | 200000 | Bun | YUe | CSCI | MATH | 40 | 1011 | 100002 | 10000 | B- | 3 | | 300000 | Bun_C1 | Yue | MAGI | MATH | 40 | 1011 | 100002 | 10000 | B- | 3 | | 500000 | Bun_C1123 | Yue | MAGI | MUSI | 40 | 1565 | 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 | | 200000 | Bun | YUe | CSCI | MATH | 40 | 1011 | 100000 | 10001 | A | 2 | | 300000 | Bun_C1 | Yue | MAGI | MATH | 40 | 1011 | 100000 | 10001 | A | 2 | | 500000 | Bun_C1123 | Yue | MAGI | MUSI | 40 | 1565 | 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 | | 200000 | Bun | YUe | CSCI | MATH | 40 | 1011 | 100001 | 10001 | A- | 0 | | 300000 | Bun_C1 | Yue | MAGI | MATH | 40 | 1011 | 100001 | 10001 | A- | 0 | | 500000 | Bun_C1123 | Yue | MAGI | MUSI | 40 | 1565 | 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 | | 200000 | Bun | YUe | CSCI | MATH | 40 | 1011 | 100000 | 10002 | B+ | 1 | | 300000 | Bun_C1 | Yue | MAGI | MATH | 40 | 1011 | 100000 | 10002 | B+ | 1 | | 500000 | Bun_C1123 | Yue | MAGI | MUSI | 40 | 1565 | 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 | | 200000 | Bun | YUe | CSCI | MATH | 40 | 1011 | 100002 | 10002 | B+ | 2 | | 300000 | Bun_C1 | Yue | MAGI | MATH | 40 | 1011 | 100002 | 10002 | B+ | 2 | | 500000 | Bun_C1123 | Yue | MAGI | MUSI | 40 | 1565 | 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 | | 200000 | Bun | YUe | CSCI | MATH | 40 | 1011 | 100000 | 10003 | C | 0 | | 300000 | Bun_C1 | Yue | MAGI | MATH | 40 | 1011 | 100000 | 10003 | C | 0 | | 500000 | Bun_C1123 | Yue | MAGI | MUSI | 40 | 1565 | 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 | | 200000 | Bun | YUe | CSCI | MATH | 40 | 1011 | 100002 | 10003 | D | 4 | | 300000 | Bun_C1 | Yue | MAGI | MATH | 40 | 1011 | 100002 | 10003 | D | 4 | | 500000 | Bun_C1123 | Yue | MAGI | MUSI | 40 | 1565 | 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 | | 200000 | Bun | YUe | CSCI | MATH | 40 | 1011 | 100004 | 10003 | A | 0 | | 300000 | Bun_C1 | Yue | MAGI | MATH | 40 | 1011 | 100004 | 10003 | A | 0 | | 500000 | Bun_C1123 | Yue | MAGI | MUSI | 40 | 1565 | 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 | | 200000 | Bun | YUe | CSCI | MATH | 40 | 1011 | 100005 | 10003 | NULL | NULL | | 300000 | Bun_C1 | Yue | MAGI | MATH | 40 | 1011 | 100005 | 10003 | NULL | NULL | | 500000 | Bun_C1123 | Yue | MAGI | MUSI | 40 | 1565 | 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 | | 200000 | Bun | YUe | CSCI | MATH | 40 | 1011 | 100000 | 10004 | A- | 1 | | 300000 | Bun_C1 | Yue | MAGI | MATH | 40 | 1011 | 100000 | 10004 | A- | 1 | | 500000 | Bun_C1123 | Yue | MAGI | MUSI | 40 | 1565 | 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 | | 200000 | Bun | YUe | CSCI | MATH | 40 | 1011 | 100004 | 10004 | B+ | NULL | | 300000 | Bun_C1 | Yue | MAGI | MATH | 40 | 1011 | 100004 | 10004 | B+ | NULL | | 500000 | Bun_C1123 | Yue | MAGI | MUSI | 40 | 1565 | 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 | | 200000 | Bun | YUe | CSCI | MATH | 40 | 1011 | 100005 | 10004 | A- | 0 | | 300000 | Bun_C1 | Yue | MAGI | MATH | 40 | 1011 | 100005 | 10004 | A- | 0 | | 500000 | Bun_C1123 | Yue | MAGI | MUSI | 40 | 1565 | 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 | | 200000 | Bun | YUe | CSCI | MATH | 40 | 1011 | 100006 | 10004 | C+ | NULL | | 300000 | Bun_C1 | Yue | MAGI | MATH | 40 | 1011 | 100006 | 10004 | C+ | NULL | | 500000 | Bun_C1123 | Yue | MAGI | MUSI | 40 | 1565 | 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 | | 200000 | Bun | YUe | CSCI | MATH | 40 | 1011 | 100005 | 10005 | A- | 0 | | 300000 | Bun_C1 | Yue | MAGI | MATH | 40 | 1011 | 100005 | 10005 | A- | 0 | | 500000 | Bun_C1123 | Yue | MAGI | MUSI | 40 | 1565 | 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 | | 200000 | Bun | YUe | CSCI | MATH | 40 | 1011 | 100006 | 10005 | A | NULL | | 300000 | Bun_C1 | Yue | MAGI | MATH | 40 | 1011 | 100006 | 10005 | A | NULL | | 500000 | Bun_C1123 | Yue | MAGI | MUSI | 40 | 1565 | 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 | | 200000 | Bun | YUe | CSCI | MATH | 40 | 1011 | 100005 | 10006 | B+ | NULL | | 300000 | Bun_C1 | Yue | MAGI | MATH | 40 | 1011 | 100005 | 10006 | B+ | NULL | | 500000 | Bun_C1123 | Yue | MAGI | MUSI | 40 | 1565 | 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 | | 200000 | Bun | YUe | CSCI | MATH | 40 | 1011 | 100007 | 10007 | F | 4 | | 300000 | Bun_C1 | Yue | MAGI | MATH | 40 | 1011 | 100007 | 10007 | F | 4 | | 500000 | Bun_C1123 | Yue | MAGI | MUSI | 40 | 1565 | 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 | | 200000 | Bun | YUe | CSCI | MATH | 40 | 1011 | 100008 | 10007 | C- | 0 | | 300000 | Bun_C1 | Yue | MAGI | MATH | 40 | 1011 | 100008 | 10007 | C- | 0 | | 500000 | Bun_C1123 | Yue | MAGI | MUSI | 40 | 1565 | 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 | | 200000 | Bun | YUe | CSCI | MATH | 40 | 1011 | 100007 | 10008 | A- | 0 | | 300000 | Bun_C1 | Yue | MAGI | MATH | 40 | 1011 | 100007 | 10008 | A- | 0 | | 500000 | Bun_C1123 | Yue | MAGI | MUSI | 40 | 1565 | 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 | | 200000 | Bun | YUe | CSCI | MATH | 40 | 1011 | 100000 | 11001 | D | 4 | | 300000 | Bun_C1 | Yue | MAGI | MATH | 40 | 1011 | 100000 | 11001 | D | 4 | | 500000 | Bun_C1123 | Yue | MAGI | MUSI | 40 | 1565 | 100000 | 11001 | D | 4 | +--------+-----------+----------+-------+-------+------+---------+--------+---------+-------+----------+ 308 rows in set (0.002 sec) MariaDB [toyu]> SELECT DISTINCT s.*, e.* -- [3] -> FROM student AS s, enroll AS e -- [1] -> WHERE s.stuId = e.stuId; +--------+---------+---------+-------+-------+------+---------+--------+---------+-------+----------+ | 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]> 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] -> WHERE (minor = 'CINF' OR 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]> 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 (minor = 'CINF' OR 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, '[', s.major, ']') AS student, e.classId, e.grade -- [3] -> FROM student AS s INNER JOIN enroll AS e ON (s.stuId = e.stuId)-- [1] -> WHERE (minor = 'CINF' OR minor = 'ITEC'); -- [2] +--------+-----------------------+---------+-------+ | stuId | student | classId | grade | +--------+-----------------------+---------+-------+ | 100000 | Tony Hawk[CSCI] | 10000 | A | | 100000 | Tony Hawk[CSCI] | 10001 | A | | 100000 | Tony Hawk[CSCI] | 10002 | B+ | | 100000 | Tony Hawk[CSCI] | 10003 | C | | 100000 | Tony Hawk[CSCI] | 10004 | A- | | 100000 | Tony Hawk[CSCI] | 11001 | D | | 100001 | Mary Hawk[CSCI] | 10000 | NULL | | 100001 | Mary Hawk[CSCI] | 10001 | A- | | 100002 | David Hawk[CSCI] | 10000 | B- | | 100002 | David Hawk[CSCI] | 10002 | B+ | | 100002 | David Hawk[CSCI] | 10003 | D | | 100006 | Lillian Johnson[CINF] | 10004 | C+ | | 100006 | Lillian Johnson[CINF] | 10005 | A | +--------+-----------------------+---------+-------+ 13 rows in set (0.001 sec) MariaDB [toyu]> notee