MariaDB [(none)]> use toyu Database changed MariaDB [toyu]> MariaDB [toyu]> SELECT s.major, COUNT(stuId) AS numMajor, -> GROUP_CONCAT(CONCAT(s.fname, ' ', s.lname)) AS students -> FROM Student AS s -> GROUP BY s.major; +-------+----------+--------------------------------+ | major | numMajor | students | +-------+----------+--------------------------------+ | NULL | 2 | Ben Zico,Cathy Johanson | | ARTS | 2 | Bill Ching,Linda King | | CINF | 2 | Linda Johnson,Lillian Johnson | | CSCI | 3 | Tony Hawk,Mary Hawk,David Hawk | | ITEC | 2 | Catherine Lim,Larry Johnson | +-------+----------+--------------------------------+ 5 rows in set (0.010 sec) MariaDB [toyu]> SELECT s.major, COUNT(stuId) AS numMajor, -> GROUP_CONCAT(CONCAT(s.fname, ' ', s.lname) -> ORDER BY s.lname ASC, s.fname ASC ) AS students -> FROM Student AS s -> GROUP BY s.major; +-------+----------+--------------------------------+ | major | numMajor | students | +-------+----------+--------------------------------+ | NULL | 2 | Cathy Johanson,Ben Zico | | ARTS | 2 | Bill Ching,Linda King | | CINF | 2 | Lillian Johnson,Linda Johnson | | CSCI | 3 | David Hawk,Mary Hawk,Tony Hawk | | ITEC | 2 | Larry Johnson,Catherine Lim | +-------+----------+--------------------------------+ 5 rows in set (0.001 sec) MariaDB [toyu]> select 1 union select 2; +---+ | 1 | +---+ | 1 | | 2 | +---+ 2 rows in set (0.003 sec) MariaDB [toyu]> SELECT * -> FROM studentAS s CROSS JOIN enroll AS e; ERROR 1146 (42S02): Table 'toyu.studentas' doesn't exist MariaDB [toyu]> MariaDB [toyu]> SELECT * -> FROM student AS s CROSS JOIN enroll AS e; +--------+-----------+----------+-------+-------+------+---------+--------+---------+-------+----------+ | 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 | | 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 | | 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 | | 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 | | 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 | | 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 | | 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 | | 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 | | 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 | | 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 | | 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 | | 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 | | 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 | | 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 | | 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 | | 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 | | 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 | | 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 | | 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 | | 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 | | 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 | | 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 | +--------+-----------+----------+-------+-------+------+---------+--------+---------+-------+----------+ 242 rows in set (0.002 sec) MariaDB [toyu]> MariaDB [toyu]> -- equi-join MariaDB [toyu]> MariaDB [toyu]> SELECT * -> FROM student AS s CROSS JOIN enroll AS e USING (stuId); +--------+---------+---------+-------+-------+------+---------+---------+-------+----------+ | stuId | fname | lname | major | minor | ach | advisor | classId | grade | n_alerts | +--------+---------+---------+-------+-------+------+---------+---------+-------+----------+ | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 10000 | A | 0 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 10001 | A | 2 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 10002 | B+ | 1 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 10003 | C | 0 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 10004 | A- | 1 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 11001 | D | 4 | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 10000 | NULL | NULL | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 10001 | A- | 0 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 10000 | B- | 3 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 10002 | B+ | 2 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 10003 | D | 4 | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 10003 | A | 0 | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 10004 | B+ | NULL | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 10003 | NULL | NULL | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 10004 | A- | 0 | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 10005 | A- | 0 | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 10006 | B+ | NULL | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 10004 | C+ | NULL | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 10005 | A | NULL | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 10007 | F | 4 | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 10008 | A- | 0 | | 100008 | Bill | Ching | ARTS | NULL | 90 | NULL | 10007 | C- | 0 | +--------+---------+---------+-------+-------+------+---------+---------+-------+----------+ 22 rows in set (0.009 sec) MariaDB [toyu]> SELECT s.*, e.* -> FROM student AS s CROSS JOIN enroll AS e USING (stuId); +--------+---------+---------+-------+-------+------+---------+--------+---------+-------+----------+ | 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 | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 100004 | 10003 | A | 0 | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 100004 | 10004 | B+ | NULL | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100005 | 10003 | NULL | NULL | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100005 | 10004 | A- | 0 | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100005 | 10005 | A- | 0 | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100005 | 10006 | B+ | NULL | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100006 | 10004 | C+ | NULL | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100006 | 10005 | A | NULL | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 100007 | 10007 | F | 4 | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 100007 | 10008 | A- | 0 | | 100008 | Bill | Ching | ARTS | NULL | 90 | NULL | 100008 | 10007 | C- | 0 | +--------+---------+---------+-------+-------+------+---------+--------+---------+-------+----------+ 22 rows in set (0.002 sec) MariaDB [toyu]> SELECT * -> FROM student NATURAL JOIN enroll; +--------+---------+---------+-------+-------+------+---------+---------+-------+----------+ | stuId | fname | lname | major | minor | ach | advisor | classId | grade | n_alerts | +--------+---------+---------+-------+-------+------+---------+---------+-------+----------+ | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 10000 | A | 0 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 10001 | A | 2 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 10002 | B+ | 1 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 10003 | C | 0 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 10004 | A- | 1 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 11001 | D | 4 | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 10000 | NULL | NULL | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 10001 | A- | 0 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 10000 | B- | 3 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 10002 | B+ | 2 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 10003 | D | 4 | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 10003 | A | 0 | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 10004 | B+ | NULL | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 10003 | NULL | NULL | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 10004 | A- | 0 | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 10005 | A- | 0 | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 10006 | B+ | NULL | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 10004 | C+ | NULL | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 10005 | A | NULL | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 10007 | F | 4 | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 10008 | A- | 0 | | 100008 | Bill | Ching | ARTS | NULL | 90 | NULL | 10007 | C- | 0 | +--------+---------+---------+-------+-------+------+---------+---------+-------+----------+ 22 rows in set (0.001 sec) MariaDB [toyu]> notee