Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 151 Server version: 10.11.6-MariaDB-0+deb12u1 Debian 12 Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> use sksunivdemo Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed MariaDB [sksunivdemo]> show tables; +-----------------------+ | Tables_in_sksunivdemo | +-----------------------+ | advisor | | classroom | | course | | department | | instructor | | prereq | | section | | student | | takes | | teaches | | time_slot | +-----------------------+ 11 rows in set (0.001 sec) MariaDB [sksunivdemo]> describe instructor; +-----------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+--------------+------+-----+---------+-------+ | ID | varchar(5) | NO | PRI | NULL | | | name | varchar(20) | NO | | NULL | | | dept_name | varchar(20) | YES | MUL | NULL | | | salary | decimal(8,2) | YES | | NULL | | +-----------+--------------+------+-----+---------+-------+ 4 rows in set (0.027 sec) MariaDB [sksunivdemo]> select * from instructor; +-------+------------+------------+----------+ | ID | name | dept_name | salary | +-------+------------+------------+----------+ | 10101 | Srinivasan | Comp. Sci. | 65000.00 | | 12121 | Wu | Finance | 90000.00 | | 15151 | Mozart | Music | 40000.00 | | 22222 | Einstein | Physics | 95000.00 | | 32343 | El Said | History | 60000.00 | | 33456 | Gold | Physics | 87000.00 | | 45565 | Katz | Comp. Sci. | 75000.00 | | 58583 | Califieri | History | 62000.00 | | 76543 | Singh | Finance | 80000.00 | | 76766 | Crick | Biology | 72000.00 | | 83821 | Brandt | Comp. Sci. | 92000.00 | | 98345 | Kim | Elec. Eng. | 80000.00 | +-------+------------+------------+----------+ 12 rows in set (0.083 sec) MariaDB [sksunivdemo]> select name from instructor; +------------+ | name | +------------+ | Srinivasan | | Wu | | Mozart | | Einstein | | El Said | | Gold | | Katz | | Califieri | | Singh | | Crick | | Brandt | | Kim | +------------+ 12 rows in set (0.001 sec) MariaDB [sksunivdemo]> select dept_name from instructor; +------------+ | dept_name | +------------+ | Biology | | Comp. Sci. | | Comp. Sci. | | Comp. Sci. | | Elec. Eng. | | Finance | | Finance | | History | | History | | Music | | Physics | | Physics | +------------+ 12 rows in set (0.001 sec) MariaDB [sksunivdemo]> select distinct dept_name from instructor; +------------+ | dept_name | +------------+ | Biology | | Comp. Sci. | | Elec. Eng. | | Finance | | History | | Music | | Physics | +------------+ 7 rows in set (0.079 sec) MariaDB [sksunivdemo]> select salary from instructor; +----------+ | salary | +----------+ | 65000.00 | | 90000.00 | | 40000.00 | | 95000.00 | | 60000.00 | | 87000.00 | | 75000.00 | | 62000.00 | | 80000.00 | | 72000.00 | | 92000.00 | | 80000.00 | +----------+ 12 rows in set (0.001 sec) MariaDB [sksunivdemo]> select distinct salary from instructor; +----------+ | salary | +----------+ | 65000.00 | | 90000.00 | | 40000.00 | | 95000.00 | | 60000.00 | | 87000.00 | | 75000.00 | | 62000.00 | | 80000.00 | | 72000.00 | | 92000.00 | +----------+ 11 rows in set (0.001 sec) MariaDB [sksunivdemo]> insert into instructor(ID,name) values('99999','ABCDE'); Query OK, 1 row affected (0.017 sec) MariaDB [sksunivdemo]> select * from instructor; +-------+------------+------------+----------+ | ID | name | dept_name | salary | +-------+------------+------------+----------+ | 10101 | Srinivasan | Comp. Sci. | 65000.00 | | 12121 | Wu | Finance | 90000.00 | | 15151 | Mozart | Music | 40000.00 | | 22222 | Einstein | Physics | 95000.00 | | 32343 | El Said | History | 60000.00 | | 33456 | Gold | Physics | 87000.00 | | 45565 | Katz | Comp. Sci. | 75000.00 | | 58583 | Califieri | History | 62000.00 | | 76543 | Singh | Finance | 80000.00 | | 76766 | Crick | Biology | 72000.00 | | 83821 | Brandt | Comp. Sci. | 92000.00 | | 98345 | Kim | Elec. Eng. | 80000.00 | | 99999 | ABCDE | NULL | NULL | +-------+------------+------------+----------+ 13 rows in set (0.001 sec) MariaDB [sksunivdemo]> delete from instructor where ID = '99999'; Query OK, 1 row affected (0.081 sec) MariaDB [sksunivdemo]> select * from instructor; +-------+------------+------------+----------+ | ID | name | dept_name | salary | +-------+------------+------------+----------+ | 10101 | Srinivasan | Comp. Sci. | 65000.00 | | 12121 | Wu | Finance | 90000.00 | | 15151 | Mozart | Music | 40000.00 | | 22222 | Einstein | Physics | 95000.00 | | 32343 | El Said | History | 60000.00 | | 33456 | Gold | Physics | 87000.00 | | 45565 | Katz | Comp. Sci. | 75000.00 | | 58583 | Califieri | History | 62000.00 | | 76543 | Singh | Finance | 80000.00 | | 76766 | Crick | Biology | 72000.00 | | 83821 | Brandt | Comp. Sci. | 92000.00 | | 98345 | Kim | Elec. Eng. | 80000.00 | +-------+------------+------------+----------+ 12 rows in set (0.001 sec) MariaDB [sksunivdemo]> describe instructor; +-----------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+--------------+------+-----+---------+-------+ | ID | varchar(5) | NO | PRI | NULL | | | name | varchar(20) | NO | | NULL | | | dept_name | varchar(20) | YES | MUL | NULL | | | salary | decimal(8,2) | YES | | NULL | | +-----------+--------------+------+-----+---------+-------+ 4 rows in set (0.002 sec) MariaDB [sksunivdemo]> insert into instructor(ID) values('99999'); ERROR 1364 (HY000): Field 'name' doesn't have a default value MariaDB [sksunivdemo]> insert into instructor(name) values('ABCDE'); ERROR 1364 (HY000): Field 'ID' doesn't have a default value MariaDB [sksunivdemo]> select * from teaches as T1, teaches as T2; +-------+-----------+--------+----------+------+-------+-----------+--------+----------+------+ | ID | course_id | sec_id | semester | year | ID | course_id | sec_id | semester | year | +-------+-----------+--------+----------+------+-------+-----------+--------+----------+------+ | 10101 | CS-101 | 1 | Fall | 2017 | 10101 | CS-101 | 1 | Fall | 2017 | | 10101 | CS-315 | 1 | Spring | 2018 | 10101 | CS-101 | 1 | Fall | 2017 | | 10101 | CS-347 | 1 | Fall | 2017 | 10101 | CS-101 | 1 | Fall | 2017 | | 12121 | FIN-201 | 1 | Spring | 2018 | 10101 | CS-101 | 1 | Fall | 2017 | | 15151 | MU-199 | 1 | Spring | 2018 | 10101 | CS-101 | 1 | Fall | 2017 | | 22222 | PHY-101 | 1 | Fall | 2017 | 10101 | CS-101 | 1 | Fall | 2017 | | 32343 | HIS-351 | 1 | Spring | 2018 | 10101 | CS-101 | 1 | Fall | 2017 | | 45565 | CS-101 | 1 | Spring | 2018 | 10101 | CS-101 | 1 | Fall | 2017 | | 45565 | CS-319 | 1 | Spring | 2018 | 10101 | CS-101 | 1 | Fall | 2017 | | 76766 | BIO-101 | 1 | Summer | 2017 | 10101 | CS-101 | 1 | Fall | 2017 | | 76766 | BIO-301 | 1 | Summer | 2018 | 10101 | CS-101 | 1 | Fall | 2017 | | 83821 | CS-190 | 1 | Spring | 2017 | 10101 | CS-101 | 1 | Fall | 2017 | | 83821 | CS-190 | 2 | Spring | 2017 | 10101 | CS-101 | 1 | Fall | 2017 | | 83821 | CS-319 | 2 | Spring | 2018 | 10101 | CS-101 | 1 | Fall | 2017 | | 98345 | EE-181 | 1 | Spring | 2017 | 10101 | CS-101 | 1 | Fall | 2017 | | 10101 | CS-101 | 1 | Fall | 2017 | 10101 | CS-315 | 1 | Spring | 2018 | | 10101 | CS-315 | 1 | Spring | 2018 | 10101 | CS-315 | 1 | Spring | 2018 | | 10101 | CS-347 | 1 | Fall | 2017 | 10101 | CS-315 | 1 | Spring | 2018 | | 12121 | FIN-201 | 1 | Spring | 2018 | 10101 | CS-315 | 1 | Spring | 2018 | | 15151 | MU-199 | 1 | Spring | 2018 | 10101 | CS-315 | 1 | Spring | 2018 | | 22222 | PHY-101 | 1 | Fall | 2017 | 10101 | CS-315 | 1 | Spring | 2018 | | 32343 | HIS-351 | 1 | Spring | 2018 | 10101 | CS-315 | 1 | Spring | 2018 | | 45565 | CS-101 | 1 | Spring | 2018 | 10101 | CS-315 | 1 | Spring | 2018 | | 45565 | CS-319 | 1 | Spring | 2018 | 10101 | CS-315 | 1 | Spring | 2018 | | 76766 | BIO-101 | 1 | Summer | 2017 | 10101 | CS-315 | 1 | Spring | 2018 | | 76766 | BIO-301 | 1 | Summer | 2018 | 10101 | CS-315 | 1 | Spring | 2018 | | 83821 | CS-190 | 1 | Spring | 2017 | 10101 | CS-315 | 1 | Spring | 2018 | | 83821 | CS-190 | 2 | Spring | 2017 | 10101 | CS-315 | 1 | Spring | 2018 | | 83821 | CS-319 | 2 | Spring | 2018 | 10101 | CS-315 | 1 | Spring | 2018 | | 98345 | EE-181 | 1 | Spring | 2017 | 10101 | CS-315 | 1 | Spring | 2018 | | 10101 | CS-101 | 1 | Fall | 2017 | 10101 | CS-347 | 1 | Fall | 2017 | | 10101 | CS-315 | 1 | Spring | 2018 | 10101 | CS-347 | 1 | Fall | 2017 | | 10101 | CS-347 | 1 | Fall | 2017 | 10101 | CS-347 | 1 | Fall | 2017 | | 12121 | FIN-201 | 1 | Spring | 2018 | 10101 | CS-347 | 1 | Fall | 2017 | | 15151 | MU-199 | 1 | Spring | 2018 | 10101 | CS-347 | 1 | Fall | 2017 | | 22222 | PHY-101 | 1 | Fall | 2017 | 10101 | CS-347 | 1 | Fall | 2017 | | 32343 | HIS-351 | 1 | Spring | 2018 | 10101 | CS-347 | 1 | Fall | 2017 | | 45565 | CS-101 | 1 | Spring | 2018 | 10101 | CS-347 | 1 | Fall | 2017 | | 45565 | CS-319 | 1 | Spring | 2018 | 10101 | CS-347 | 1 | Fall | 2017 | | 76766 | BIO-101 | 1 | Summer | 2017 | 10101 | CS-347 | 1 | Fall | 2017 | | 76766 | BIO-301 | 1 | Summer | 2018 | 10101 | CS-347 | 1 | Fall | 2017 | | 83821 | CS-190 | 1 | Spring | 2017 | 10101 | CS-347 | 1 | Fall | 2017 | | 83821 | CS-190 | 2 | Spring | 2017 | 10101 | CS-347 | 1 | Fall | 2017 | | 83821 | CS-319 | 2 | Spring | 2018 | 10101 | CS-347 | 1 | Fall | 2017 | | 98345 | EE-181 | 1 | Spring | 2017 | 10101 | CS-347 | 1 | Fall | 2017 | | 10101 | CS-101 | 1 | Fall | 2017 | 12121 | FIN-201 | 1 | Spring | 2018 | | 10101 | CS-315 | 1 | Spring | 2018 | 12121 | FIN-201 | 1 | Spring | 2018 | | 10101 | CS-347 | 1 | Fall | 2017 | 12121 | FIN-201 | 1 | Spring | 2018 | | 12121 | FIN-201 | 1 | Spring | 2018 | 12121 | FIN-201 | 1 | Spring | 2018 | | 15151 | MU-199 | 1 | Spring | 2018 | 12121 | FIN-201 | 1 | Spring | 2018 | | 22222 | PHY-101 | 1 | Fall | 2017 | 12121 | FIN-201 | 1 | Spring | 2018 | | 32343 | HIS-351 | 1 | Spring | 2018 | 12121 | FIN-201 | 1 | Spring | 2018 | | 45565 | CS-101 | 1 | Spring | 2018 | 12121 | FIN-201 | 1 | Spring | 2018 | | 45565 | CS-319 | 1 | Spring | 2018 | 12121 | FIN-201 | 1 | Spring | 2018 | | 76766 | BIO-101 | 1 | Summer | 2017 | 12121 | FIN-201 | 1 | Spring | 2018 | | 76766 | BIO-301 | 1 | Summer | 2018 | 12121 | FIN-201 | 1 | Spring | 2018 | | 83821 | CS-190 | 1 | Spring | 2017 | 12121 | FIN-201 | 1 | Spring | 2018 | | 83821 | CS-190 | 2 | Spring | 2017 | 12121 | FIN-201 | 1 | Spring | 2018 | | 83821 | CS-319 | 2 | Spring | 2018 | 12121 | FIN-201 | 1 | Spring | 2018 | | 98345 | EE-181 | 1 | Spring | 2017 | 12121 | FIN-201 | 1 | Spring | 2018 | | 10101 | CS-101 | 1 | Fall | 2017 | 15151 | MU-199 | 1 | Spring | 2018 | | 10101 | CS-315 | 1 | Spring | 2018 | 15151 | MU-199 | 1 | Spring | 2018 | | 10101 | CS-347 | 1 | Fall | 2017 | 15151 | MU-199 | 1 | Spring | 2018 | | 12121 | FIN-201 | 1 | Spring | 2018 | 15151 | MU-199 | 1 | Spring | 2018 | | 15151 | MU-199 | 1 | Spring | 2018 | 15151 | MU-199 | 1 | Spring | 2018 | | 22222 | PHY-101 | 1 | Fall | 2017 | 15151 | MU-199 | 1 | Spring | 2018 | | 32343 | HIS-351 | 1 | Spring | 2018 | 15151 | MU-199 | 1 | Spring | 2018 | | 45565 | CS-101 | 1 | Spring | 2018 | 15151 | MU-199 | 1 | Spring | 2018 | | 45565 | CS-319 | 1 | Spring | 2018 | 15151 | MU-199 | 1 | Spring | 2018 | | 76766 | BIO-101 | 1 | Summer | 2017 | 15151 | MU-199 | 1 | Spring | 2018 | | 76766 | BIO-301 | 1 | Summer | 2018 | 15151 | MU-199 | 1 | Spring | 2018 | | 83821 | CS-190 | 1 | Spring | 2017 | 15151 | MU-199 | 1 | Spring | 2018 | | 83821 | CS-190 | 2 | Spring | 2017 | 15151 | MU-199 | 1 | Spring | 2018 | | 83821 | CS-319 | 2 | Spring | 2018 | 15151 | MU-199 | 1 | Spring | 2018 | | 98345 | EE-181 | 1 | Spring | 2017 | 15151 | MU-199 | 1 | Spring | 2018 | | 10101 | CS-101 | 1 | Fall | 2017 | 22222 | PHY-101 | 1 | Fall | 2017 | | 10101 | CS-315 | 1 | Spring | 2018 | 22222 | PHY-101 | 1 | Fall | 2017 | | 10101 | CS-347 | 1 | Fall | 2017 | 22222 | PHY-101 | 1 | Fall | 2017 | | 12121 | FIN-201 | 1 | Spring | 2018 | 22222 | PHY-101 | 1 | Fall | 2017 | | 15151 | MU-199 | 1 | Spring | 2018 | 22222 | PHY-101 | 1 | Fall | 2017 | | 22222 | PHY-101 | 1 | Fall | 2017 | 22222 | PHY-101 | 1 | Fall | 2017 | | 32343 | HIS-351 | 1 | Spring | 2018 | 22222 | PHY-101 | 1 | Fall | 2017 | | 45565 | CS-101 | 1 | Spring | 2018 | 22222 | PHY-101 | 1 | Fall | 2017 | | 45565 | CS-319 | 1 | Spring | 2018 | 22222 | PHY-101 | 1 | Fall | 2017 | | 76766 | BIO-101 | 1 | Summer | 2017 | 22222 | PHY-101 | 1 | Fall | 2017 | | 76766 | BIO-301 | 1 | Summer | 2018 | 22222 | PHY-101 | 1 | Fall | 2017 | | 83821 | CS-190 | 1 | Spring | 2017 | 22222 | PHY-101 | 1 | Fall | 2017 | | 83821 | CS-190 | 2 | Spring | 2017 | 22222 | PHY-101 | 1 | Fall | 2017 | | 83821 | CS-319 | 2 | Spring | 2018 | 22222 | PHY-101 | 1 | Fall | 2017 | | 98345 | EE-181 | 1 | Spring | 2017 | 22222 | PHY-101 | 1 | Fall | 2017 | | 10101 | CS-101 | 1 | Fall | 2017 | 32343 | HIS-351 | 1 | Spring | 2018 | | 10101 | CS-315 | 1 | Spring | 2018 | 32343 | HIS-351 | 1 | Spring | 2018 | | 10101 | CS-347 | 1 | Fall | 2017 | 32343 | HIS-351 | 1 | Spring | 2018 | | 12121 | FIN-201 | 1 | Spring | 2018 | 32343 | HIS-351 | 1 | Spring | 2018 | | 15151 | MU-199 | 1 | Spring | 2018 | 32343 | HIS-351 | 1 | Spring | 2018 | | 22222 | PHY-101 | 1 | Fall | 2017 | 32343 | HIS-351 | 1 | Spring | 2018 | | 32343 | HIS-351 | 1 | Spring | 2018 | 32343 | HIS-351 | 1 | Spring | 2018 | | 45565 | CS-101 | 1 | Spring | 2018 | 32343 | HIS-351 | 1 | Spring | 2018 | | 45565 | CS-319 | 1 | Spring | 2018 | 32343 | HIS-351 | 1 | Spring | 2018 | | 76766 | BIO-101 | 1 | Summer | 2017 | 32343 | HIS-351 | 1 | Spring | 2018 | | 76766 | BIO-301 | 1 | Summer | 2018 | 32343 | HIS-351 | 1 | Spring | 2018 | | 83821 | CS-190 | 1 | Spring | 2017 | 32343 | HIS-351 | 1 | Spring | 2018 | | 83821 | CS-190 | 2 | Spring | 2017 | 32343 | HIS-351 | 1 | Spring | 2018 | | 83821 | CS-319 | 2 | Spring | 2018 | 32343 | HIS-351 | 1 | Spring | 2018 | | 98345 | EE-181 | 1 | Spring | 2017 | 32343 | HIS-351 | 1 | Spring | 2018 | | 10101 | CS-101 | 1 | Fall | 2017 | 45565 | CS-101 | 1 | Spring | 2018 | | 10101 | CS-315 | 1 | Spring | 2018 | 45565 | CS-101 | 1 | Spring | 2018 | | 10101 | CS-347 | 1 | Fall | 2017 | 45565 | CS-101 | 1 | Spring | 2018 | | 12121 | FIN-201 | 1 | Spring | 2018 | 45565 | CS-101 | 1 | Spring | 2018 | | 15151 | MU-199 | 1 | Spring | 2018 | 45565 | CS-101 | 1 | Spring | 2018 | | 22222 | PHY-101 | 1 | Fall | 2017 | 45565 | CS-101 | 1 | Spring | 2018 | | 32343 | HIS-351 | 1 | Spring | 2018 | 45565 | CS-101 | 1 | Spring | 2018 | | 45565 | CS-101 | 1 | Spring | 2018 | 45565 | CS-101 | 1 | Spring | 2018 | | 45565 | CS-319 | 1 | Spring | 2018 | 45565 | CS-101 | 1 | Spring | 2018 | | 76766 | BIO-101 | 1 | Summer | 2017 | 45565 | CS-101 | 1 | Spring | 2018 | | 76766 | BIO-301 | 1 | Summer | 2018 | 45565 | CS-101 | 1 | Spring | 2018 | | 83821 | CS-190 | 1 | Spring | 2017 | 45565 | CS-101 | 1 | Spring | 2018 | | 83821 | CS-190 | 2 | Spring | 2017 | 45565 | CS-101 | 1 | Spring | 2018 | | 83821 | CS-319 | 2 | Spring | 2018 | 45565 | CS-101 | 1 | Spring | 2018 | | 98345 | EE-181 | 1 | Spring | 2017 | 45565 | CS-101 | 1 | Spring | 2018 | | 10101 | CS-101 | 1 | Fall | 2017 | 45565 | CS-319 | 1 | Spring | 2018 | | 10101 | CS-315 | 1 | Spring | 2018 | 45565 | CS-319 | 1 | Spring | 2018 | | 10101 | CS-347 | 1 | Fall | 2017 | 45565 | CS-319 | 1 | Spring | 2018 | | 12121 | FIN-201 | 1 | Spring | 2018 | 45565 | CS-319 | 1 | Spring | 2018 | | 15151 | MU-199 | 1 | Spring | 2018 | 45565 | CS-319 | 1 | Spring | 2018 | | 22222 | PHY-101 | 1 | Fall | 2017 | 45565 | CS-319 | 1 | Spring | 2018 | | 32343 | HIS-351 | 1 | Spring | 2018 | 45565 | CS-319 | 1 | Spring | 2018 | | 45565 | CS-101 | 1 | Spring | 2018 | 45565 | CS-319 | 1 | Spring | 2018 | | 45565 | CS-319 | 1 | Spring | 2018 | 45565 | CS-319 | 1 | Spring | 2018 | | 76766 | BIO-101 | 1 | Summer | 2017 | 45565 | CS-319 | 1 | Spring | 2018 | | 76766 | BIO-301 | 1 | Summer | 2018 | 45565 | CS-319 | 1 | Spring | 2018 | | 83821 | CS-190 | 1 | Spring | 2017 | 45565 | CS-319 | 1 | Spring | 2018 | | 83821 | CS-190 | 2 | Spring | 2017 | 45565 | CS-319 | 1 | Spring | 2018 | | 83821 | CS-319 | 2 | Spring | 2018 | 45565 | CS-319 | 1 | Spring | 2018 | | 98345 | EE-181 | 1 | Spring | 2017 | 45565 | CS-319 | 1 | Spring | 2018 | | 10101 | CS-101 | 1 | Fall | 2017 | 76766 | BIO-101 | 1 | Summer | 2017 | | 10101 | CS-315 | 1 | Spring | 2018 | 76766 | BIO-101 | 1 | Summer | 2017 | | 10101 | CS-347 | 1 | Fall | 2017 | 76766 | BIO-101 | 1 | Summer | 2017 | | 12121 | FIN-201 | 1 | Spring | 2018 | 76766 | BIO-101 | 1 | Summer | 2017 | | 15151 | MU-199 | 1 | Spring | 2018 | 76766 | BIO-101 | 1 | Summer | 2017 | | 22222 | PHY-101 | 1 | Fall | 2017 | 76766 | BIO-101 | 1 | Summer | 2017 | | 32343 | HIS-351 | 1 | Spring | 2018 | 76766 | BIO-101 | 1 | Summer | 2017 | | 45565 | CS-101 | 1 | Spring | 2018 | 76766 | BIO-101 | 1 | Summer | 2017 | | 45565 | CS-319 | 1 | Spring | 2018 | 76766 | BIO-101 | 1 | Summer | 2017 | | 76766 | BIO-101 | 1 | Summer | 2017 | 76766 | BIO-101 | 1 | Summer | 2017 | | 76766 | BIO-301 | 1 | Summer | 2018 | 76766 | BIO-101 | 1 | Summer | 2017 | | 83821 | CS-190 | 1 | Spring | 2017 | 76766 | BIO-101 | 1 | Summer | 2017 | | 83821 | CS-190 | 2 | Spring | 2017 | 76766 | BIO-101 | 1 | Summer | 2017 | | 83821 | CS-319 | 2 | Spring | 2018 | 76766 | BIO-101 | 1 | Summer | 2017 | | 98345 | EE-181 | 1 | Spring | 2017 | 76766 | BIO-101 | 1 | Summer | 2017 | | 10101 | CS-101 | 1 | Fall | 2017 | 76766 | BIO-301 | 1 | Summer | 2018 | | 10101 | CS-315 | 1 | Spring | 2018 | 76766 | BIO-301 | 1 | Summer | 2018 | | 10101 | CS-347 | 1 | Fall | 2017 | 76766 | BIO-301 | 1 | Summer | 2018 | | 12121 | FIN-201 | 1 | Spring | 2018 | 76766 | BIO-301 | 1 | Summer | 2018 | | 15151 | MU-199 | 1 | Spring | 2018 | 76766 | BIO-301 | 1 | Summer | 2018 | | 22222 | PHY-101 | 1 | Fall | 2017 | 76766 | BIO-301 | 1 | Summer | 2018 | | 32343 | HIS-351 | 1 | Spring | 2018 | 76766 | BIO-301 | 1 | Summer | 2018 | | 45565 | CS-101 | 1 | Spring | 2018 | 76766 | BIO-301 | 1 | Summer | 2018 | | 45565 | CS-319 | 1 | Spring | 2018 | 76766 | BIO-301 | 1 | Summer | 2018 | | 76766 | BIO-101 | 1 | Summer | 2017 | 76766 | BIO-301 | 1 | Summer | 2018 | | 76766 | BIO-301 | 1 | Summer | 2018 | 76766 | BIO-301 | 1 | Summer | 2018 | | 83821 | CS-190 | 1 | Spring | 2017 | 76766 | BIO-301 | 1 | Summer | 2018 | | 83821 | CS-190 | 2 | Spring | 2017 | 76766 | BIO-301 | 1 | Summer | 2018 | | 83821 | CS-319 | 2 | Spring | 2018 | 76766 | BIO-301 | 1 | Summer | 2018 | | 98345 | EE-181 | 1 | Spring | 2017 | 76766 | BIO-301 | 1 | Summer | 2018 | | 10101 | CS-101 | 1 | Fall | 2017 | 83821 | CS-190 | 1 | Spring | 2017 | | 10101 | CS-315 | 1 | Spring | 2018 | 83821 | CS-190 | 1 | Spring | 2017 | | 10101 | CS-347 | 1 | Fall | 2017 | 83821 | CS-190 | 1 | Spring | 2017 | | 12121 | FIN-201 | 1 | Spring | 2018 | 83821 | CS-190 | 1 | Spring | 2017 | | 15151 | MU-199 | 1 | Spring | 2018 | 83821 | CS-190 | 1 | Spring | 2017 | | 22222 | PHY-101 | 1 | Fall | 2017 | 83821 | CS-190 | 1 | Spring | 2017 | | 32343 | HIS-351 | 1 | Spring | 2018 | 83821 | CS-190 | 1 | Spring | 2017 | | 45565 | CS-101 | 1 | Spring | 2018 | 83821 | CS-190 | 1 | Spring | 2017 | | 45565 | CS-319 | 1 | Spring | 2018 | 83821 | CS-190 | 1 | Spring | 2017 | | 76766 | BIO-101 | 1 | Summer | 2017 | 83821 | CS-190 | 1 | Spring | 2017 | | 76766 | BIO-301 | 1 | Summer | 2018 | 83821 | CS-190 | 1 | Spring | 2017 | | 83821 | CS-190 | 1 | Spring | 2017 | 83821 | CS-190 | 1 | Spring | 2017 | | 83821 | CS-190 | 2 | Spring | 2017 | 83821 | CS-190 | 1 | Spring | 2017 | | 83821 | CS-319 | 2 | Spring | 2018 | 83821 | CS-190 | 1 | Spring | 2017 | | 98345 | EE-181 | 1 | Spring | 2017 | 83821 | CS-190 | 1 | Spring | 2017 | | 10101 | CS-101 | 1 | Fall | 2017 | 83821 | CS-190 | 2 | Spring | 2017 | | 10101 | CS-315 | 1 | Spring | 2018 | 83821 | CS-190 | 2 | Spring | 2017 | | 10101 | CS-347 | 1 | Fall | 2017 | 83821 | CS-190 | 2 | Spring | 2017 | | 12121 | FIN-201 | 1 | Spring | 2018 | 83821 | CS-190 | 2 | Spring | 2017 | | 15151 | MU-199 | 1 | Spring | 2018 | 83821 | CS-190 | 2 | Spring | 2017 | | 22222 | PHY-101 | 1 | Fall | 2017 | 83821 | CS-190 | 2 | Spring | 2017 | | 32343 | HIS-351 | 1 | Spring | 2018 | 83821 | CS-190 | 2 | Spring | 2017 | | 45565 | CS-101 | 1 | Spring | 2018 | 83821 | CS-190 | 2 | Spring | 2017 | | 45565 | CS-319 | 1 | Spring | 2018 | 83821 | CS-190 | 2 | Spring | 2017 | | 76766 | BIO-101 | 1 | Summer | 2017 | 83821 | CS-190 | 2 | Spring | 2017 | | 76766 | BIO-301 | 1 | Summer | 2018 | 83821 | CS-190 | 2 | Spring | 2017 | | 83821 | CS-190 | 1 | Spring | 2017 | 83821 | CS-190 | 2 | Spring | 2017 | | 83821 | CS-190 | 2 | Spring | 2017 | 83821 | CS-190 | 2 | Spring | 2017 | | 83821 | CS-319 | 2 | Spring | 2018 | 83821 | CS-190 | 2 | Spring | 2017 | | 98345 | EE-181 | 1 | Spring | 2017 | 83821 | CS-190 | 2 | Spring | 2017 | | 10101 | CS-101 | 1 | Fall | 2017 | 83821 | CS-319 | 2 | Spring | 2018 | | 10101 | CS-315 | 1 | Spring | 2018 | 83821 | CS-319 | 2 | Spring | 2018 | | 10101 | CS-347 | 1 | Fall | 2017 | 83821 | CS-319 | 2 | Spring | 2018 | | 12121 | FIN-201 | 1 | Spring | 2018 | 83821 | CS-319 | 2 | Spring | 2018 | | 15151 | MU-199 | 1 | Spring | 2018 | 83821 | CS-319 | 2 | Spring | 2018 | | 22222 | PHY-101 | 1 | Fall | 2017 | 83821 | CS-319 | 2 | Spring | 2018 | | 32343 | HIS-351 | 1 | Spring | 2018 | 83821 | CS-319 | 2 | Spring | 2018 | | 45565 | CS-101 | 1 | Spring | 2018 | 83821 | CS-319 | 2 | Spring | 2018 | | 45565 | CS-319 | 1 | Spring | 2018 | 83821 | CS-319 | 2 | Spring | 2018 | | 76766 | BIO-101 | 1 | Summer | 2017 | 83821 | CS-319 | 2 | Spring | 2018 | | 76766 | BIO-301 | 1 | Summer | 2018 | 83821 | CS-319 | 2 | Spring | 2018 | | 83821 | CS-190 | 1 | Spring | 2017 | 83821 | CS-319 | 2 | Spring | 2018 | | 83821 | CS-190 | 2 | Spring | 2017 | 83821 | CS-319 | 2 | Spring | 2018 | | 83821 | CS-319 | 2 | Spring | 2018 | 83821 | CS-319 | 2 | Spring | 2018 | | 98345 | EE-181 | 1 | Spring | 2017 | 83821 | CS-319 | 2 | Spring | 2018 | | 10101 | CS-101 | 1 | Fall | 2017 | 98345 | EE-181 | 1 | Spring | 2017 | | 10101 | CS-315 | 1 | Spring | 2018 | 98345 | EE-181 | 1 | Spring | 2017 | | 10101 | CS-347 | 1 | Fall | 2017 | 98345 | EE-181 | 1 | Spring | 2017 | | 12121 | FIN-201 | 1 | Spring | 2018 | 98345 | EE-181 | 1 | Spring | 2017 | | 15151 | MU-199 | 1 | Spring | 2018 | 98345 | EE-181 | 1 | Spring | 2017 | | 22222 | PHY-101 | 1 | Fall | 2017 | 98345 | EE-181 | 1 | Spring | 2017 | | 32343 | HIS-351 | 1 | Spring | 2018 | 98345 | EE-181 | 1 | Spring | 2017 | | 45565 | CS-101 | 1 | Spring | 2018 | 98345 | EE-181 | 1 | Spring | 2017 | | 45565 | CS-319 | 1 | Spring | 2018 | 98345 | EE-181 | 1 | Spring | 2017 | | 76766 | BIO-101 | 1 | Summer | 2017 | 98345 | EE-181 | 1 | Spring | 2017 | | 76766 | BIO-301 | 1 | Summer | 2018 | 98345 | EE-181 | 1 | Spring | 2017 | | 83821 | CS-190 | 1 | Spring | 2017 | 98345 | EE-181 | 1 | Spring | 2017 | | 83821 | CS-190 | 2 | Spring | 2017 | 98345 | EE-181 | 1 | Spring | 2017 | | 83821 | CS-319 | 2 | Spring | 2018 | 98345 | EE-181 | 1 | Spring | 2017 | | 98345 | EE-181 | 1 | Spring | 2017 | 98345 | EE-181 | 1 | Spring | 2017 | +-------+-----------+--------+----------+------+-------+-----------+--------+----------+------+ 225 rows in set (0.080 sec) MariaDB [sksunivdemo]> select * from teaches as T1, teaches as T2 where T1.ID = T2.ID and T1.course_id <> T2.course_id; +-------+-----------+--------+----------+------+-------+-----------+--------+----------+------+ | ID | course_id | sec_id | semester | year | ID | course_id | sec_id | semester | year | +-------+-----------+--------+----------+------+-------+-----------+--------+----------+------+ | 10101 | CS-101 | 1 | Fall | 2017 | 10101 | CS-315 | 1 | Spring | 2018 | | 10101 | CS-101 | 1 | Fall | 2017 | 10101 | CS-347 | 1 | Fall | 2017 | | 10101 | CS-315 | 1 | Spring | 2018 | 10101 | CS-101 | 1 | Fall | 2017 | | 10101 | CS-315 | 1 | Spring | 2018 | 10101 | CS-347 | 1 | Fall | 2017 | | 10101 | CS-347 | 1 | Fall | 2017 | 10101 | CS-101 | 1 | Fall | 2017 | | 10101 | CS-347 | 1 | Fall | 2017 | 10101 | CS-315 | 1 | Spring | 2018 | | 45565 | CS-101 | 1 | Spring | 2018 | 45565 | CS-319 | 1 | Spring | 2018 | | 45565 | CS-319 | 1 | Spring | 2018 | 45565 | CS-101 | 1 | Spring | 2018 | | 76766 | BIO-101 | 1 | Summer | 2017 | 76766 | BIO-301 | 1 | Summer | 2018 | | 76766 | BIO-301 | 1 | Summer | 2018 | 76766 | BIO-101 | 1 | Summer | 2017 | | 83821 | CS-190 | 1 | Spring | 2017 | 83821 | CS-319 | 2 | Spring | 2018 | | 83821 | CS-190 | 2 | Spring | 2017 | 83821 | CS-319 | 2 | Spring | 2018 | | 83821 | CS-319 | 2 | Spring | 2018 | 83821 | CS-190 | 1 | Spring | 2017 | | 83821 | CS-319 | 2 | Spring | 2018 | 83821 | CS-190 | 2 | Spring | 2017 | +-------+-----------+--------+----------+------+-------+-----------+--------+----------+------+ 14 rows in set (0.010 sec) MariaDB [sksunivdemo]> select ID from teaches as T1, teaches as T2 where T1.ID = T2.ID and T1.course_id <> T2.course_id; ERROR 1052 (23000): Column 'ID' in field list is ambiguous MariaDB [sksunivdemo]> select T1.ID from teaches as T1, teaches as T2 where T1.ID = T2.ID and T1.course_id <> T2.course_id; +-------+ | ID | +-------+ | 10101 | | 10101 | | 10101 | | 10101 | | 10101 | | 10101 | | 45565 | | 45565 | | 76766 | | 76766 | | 83821 | | 83821 | | 83821 | | 83821 | +-------+ 14 rows in set (0.001 sec) MariaDB [sksunivdemo]> select distinct T1.ID from teaches as T1, teaches as T2 where T1.ID = T2.ID and T1.course_id <> T2.course_id; +-------+ | ID | +-------+ | 10101 | | 45565 | | 76766 | | 83821 | +-------+ 4 rows in set (0.001 sec) MariaDB [sksunivdemo]> exit