mysql> SELECT * FROM Student, Grade WHERE Student.SID = Grade.SID AND Student.SI D = 857 AND Grade.CID = CPS130; ERROR 1054 (42S22): Unknown column 'CPS130' in 'where clause' mysql> SELECT * FROM Student, Grade WHERE Student.SID = Grade.SID AND Student.SI D = 857 AND Grade.CID = 'CPS130'; +-----+------+--------------+------+--------+-------+ | SID | name | email | SID | CID | grade | +-----+------+--------------+------+--------+-------+ | 857 | Lisa | lisa@fox.com | 857 | CPS130 | A+ | +-----+------+--------------+------+--------+-------+ 1 row in set (0.00 sec) mysql> SELECT grade FROM Student, Grade WHERE Student.SID = Grade.SID AND Studen t.SID = 857 AND CID = 'CPS130'; +-------+ | grade | +-------+ | A+ | +-------+ 1 row in set (0.00 sec) mysql> SELECT grade FROM Student, Grade WHERE Student.SID = Grade.SID AND name = 'Bart' AND CID = 'CPS130'; Empty set (0.00 sec) mysql> SELECT grade FROM Student, Grade WHERE Student.SID = Grade.SID AND name = 'Bart' AND CID = 'CPS116'; +-------+ | grade | +-------+ | B- | +-------+ 1 row in set (0.00 sec) mysql> SELECT grade FROM Student, Grade; +-------+ | grade | +-------+ | B- | | B- | | B- | | B- | | B | | B | | B | | B | | B+ | | B+ | | B+ | | B+ | | A+ | | A+ | | A+ | | A+ | | A+ | | A+ | | A+ | | A+ | | C | | C | | C | | C | +-------+ 24 rows in set (0.00 sec) mysql> SELECT * FROM Student, Grade; +-----+----------+------------------+------+--------+-------+ | SID | name | email | SID | CID | grade | +-----+----------+------------------+------+--------+-------+ | 123 | Milhouse | milhouse@fox.com | 142 | CPS116 | B- | | 142 | Bart | bart@fox.com | 142 | CPS116 | B- | | 456 | Ralph | ralph@fox.com | 142 | CPS116 | B- | | 857 | Lisa | lisa@fox.com | 142 | CPS116 | B- | | 123 | Milhouse | milhouse@fox.com | 142 | CPS114 | B | | 142 | Bart | bart@fox.com | 142 | CPS114 | B | | 456 | Ralph | ralph@fox.com | 142 | CPS114 | B | | 857 | Lisa | lisa@fox.com | 142 | CPS114 | B | | 123 | Milhouse | milhouse@fox.com | 123 | CPS116 | B+ | | 142 | Bart | bart@fox.com | 123 | CPS116 | B+ | | 456 | Ralph | ralph@fox.com | 123 | CPS116 | B+ | | 857 | Lisa | lisa@fox.com | 123 | CPS116 | B+ | | 123 | Milhouse | milhouse@fox.com | 857 | CPS116 | A+ | | 142 | Bart | bart@fox.com | 857 | CPS116 | A+ | | 456 | Ralph | ralph@fox.com | 857 | CPS116 | A+ | | 857 | Lisa | lisa@fox.com | 857 | CPS116 | A+ | | 123 | Milhouse | milhouse@fox.com | 857 | CPS130 | A+ | | 142 | Bart | bart@fox.com | 857 | CPS130 | A+ | | 456 | Ralph | ralph@fox.com | 857 | CPS130 | A+ | | 857 | Lisa | lisa@fox.com | 857 | CPS130 | A+ | | 123 | Milhouse | milhouse@fox.com | 456 | CPS114 | C | | 142 | Bart | bart@fox.com | 456 | CPS114 | C | | 456 | Ralph | ralph@fox.com | 456 | CPS114 | C | | 857 | Lisa | lisa@fox.com | 456 | CPS114 | C | +-----+----------+------------------+------+--------+-------+ 24 rows in set (0.00 sec) mysql> SELECT grade FROM Student, Grade WHERE Student.SID = Grade.SID AND name = 'Bart' AND CID = 'CPS116'; +-------+ | grade | +-------+ | B- | +-------+ 1 row in set (0.00 sec) mysql> SELECT * -> FROM Student s1, Student s2 -> WHERE s1.SID < s2.SID;SELECT * +-----+----------+------------------+-----+-------+---------------+ | SID | name | email | SID | name | email | +-----+----------+------------------+-----+-------+---------------+ | 123 | Milhouse | milhouse@fox.com | 142 | Bart | bart@fox.com | | 123 | Milhouse | milhouse@fox.com | 456 | Ralph | ralph@fox.com | | 142 | Bart | bart@fox.com | 456 | Ralph | ralph@fox.com | | 123 | Milhouse | milhouse@fox.com | 857 | Lisa | lisa@fox.com | | 142 | Bart | bart@fox.com | 857 | Lisa | lisa@fox.com | | 456 | Ralph | ralph@fox.com | 857 | Lisa | lisa@fox.com | +-----+----------+------------------+-----+-------+---------------+ 6 rows in set (0.00 sec) -> FROM Student s1, Student s2 -> WHERE s1.SID < s2.SID; +-----+----------+------------------+-----+-------+---------------+ | SID | name | email | SID | name | email | +-----+----------+------------------+-----+-------+---------------+ | 123 | Milhouse | milhouse@fox.com | 142 | Bart | bart@fox.com | | 123 | Milhouse | milhouse@fox.com | 456 | Ralph | ralph@fox.com | | 142 | Bart | bart@fox.com | 456 | Ralph | ralph@fox.com | | 123 | Milhouse | milhouse@fox.com | 857 | Lisa | lisa@fox.com | | 142 | Bart | bart@fox.com | 857 | Lisa | lisa@fox.com | | 456 | Ralph | ralph@fox.com | 857 | Lisa | lisa@fox.com | +-----+----------+------------------+-----+-------+---------------+ 6 rows in set (0.00 sec) mysql> SELECT * -> FROM Student s1, Student s2 -> WHERE s1.SID < s2.SID; +-----+----------+------------------+-----+-------+---------------+ | SID | name | email | SID | name | email | +-----+----------+------------------+-----+-------+---------------+ | 123 | Milhouse | milhouse@fox.com | 142 | Bart | bart@fox.com | | 123 | Milhouse | milhouse@fox.com | 456 | Ralph | ralph@fox.com | | 142 | Bart | bart@fox.com | 456 | Ralph | ralph@fox.com | | 123 | Milhouse | milhouse@fox.com | 857 | Lisa | lisa@fox.com | | 142 | Bart | bart@fox.com | 857 | Lisa | lisa@fox.com | | 456 | Ralph | ralph@fox.com | 857 | Lisa | lisa@fox.com | +-----+----------+------------------+-----+-------+---------------+ 6 rows in set (0.00 sec) mysql> SELECT * FROM Student s1, Student s2; +-----+----------+------------------+-----+----------+------------------+ | SID | name | email | SID | name | email | +-----+----------+------------------+-----+----------+------------------+ | 123 | Milhouse | milhouse@fox.com | 123 | Milhouse | milhouse@fox.com | | 142 | Bart | bart@fox.com | 123 | Milhouse | milhouse@fox.com | | 456 | Ralph | ralph@fox.com | 123 | Milhouse | milhouse@fox.com | | 857 | Lisa | lisa@fox.com | 123 | Milhouse | milhouse@fox.com | | 123 | Milhouse | milhouse@fox.com | 142 | Bart | bart@fox.com | | 142 | Bart | bart@fox.com | 142 | Bart | bart@fox.com | | 456 | Ralph | ralph@fox.com | 142 | Bart | bart@fox.com | | 857 | Lisa | lisa@fox.com | 142 | Bart | bart@fox.com | | 123 | Milhouse | milhouse@fox.com | 456 | Ralph | ralph@fox.com | | 142 | Bart | bart@fox.com | 456 | Ralph | ralph@fox.com | | 456 | Ralph | ralph@fox.com | 456 | Ralph | ralph@fox.com | | 857 | Lisa | lisa@fox.com | 456 | Ralph | ralph@fox.com | | 123 | Milhouse | milhouse@fox.com | 857 | Lisa | lisa@fox.com | | 142 | Bart | bart@fox.com | 857 | Lisa | lisa@fox.com | | 456 | Ralph | ralph@fox.com | 857 | Lisa | lisa@fox.com | | 857 | Lisa | lisa@fox.com | 857 | Lisa | lisa@fox.com | +-----+----------+------------------+-----+----------+------------------+ 16 rows in set (0.00 sec) mysql> SELECT * FROM Student s1, Student s2 WHERE s1.SID < s2.SID; +-----+----------+------------------+-----+-------+---------------+ | SID | name | email | SID | name | email | +-----+----------+------------------+-----+-------+---------------+ | 123 | Milhouse | milhouse@fox.com | 142 | Bart | bart@fox.com | | 123 | Milhouse | milhouse@fox.com | 456 | Ralph | ralph@fox.com | | 142 | Bart | bart@fox.com | 456 | Ralph | ralph@fox.com | | 123 | Milhouse | milhouse@fox.com | 857 | Lisa | lisa@fox.com | | 142 | Bart | bart@fox.com | 857 | Lisa | lisa@fox.com | | 456 | Ralph | ralph@fox.com | 857 | Lisa | lisa@fox.com | +-----+----------+------------------+-----+-------+---------------+ 6 rows in set (0.00 sec) mysql> SELECT * FROM Grade; +------+--------+-------+ | SID | CID | grade | +------+--------+-------+ | 142 | CPS116 | B- | | 142 | CPS114 | B | | 123 | CPS116 | B+ | | 857 | CPS116 | A+ | | 857 | CPS130 | A+ | | 456 | CPS114 | C | +------+--------+-------+ 6 rows in set (0.00 sec) mysql> SELECT * FROM Grade WHERE SID = 142 OR SID = 857; +------+--------+-------+ | SID | CID | grade | +------+--------+-------+ | 142 | CPS116 | B- | | 142 | CPS114 | B | | 857 | CPS116 | A+ | | 857 | CPS130 | A+ | +------+--------+-------+ 4 rows in set (0.00 sec) mysql> SELECT * FROM Grade WHERE SID = 142 AND SID = 857; Empty set (0.00 sec) mysql> SELECT * FROM Grade g1, Grade g2; +------+--------+-------+------+--------+-------+ | SID | CID | grade | SID | CID | grade | +------+--------+-------+------+--------+-------+ | 142 | CPS116 | B- | 142 | CPS116 | B- | | 142 | CPS114 | B | 142 | CPS116 | B- | | 123 | CPS116 | B+ | 142 | CPS116 | B- | | 857 | CPS116 | A+ | 142 | CPS116 | B- | | 857 | CPS130 | A+ | 142 | CPS116 | B- | | 456 | CPS114 | C | 142 | CPS116 | B- | | 142 | CPS116 | B- | 142 | CPS114 | B | | 142 | CPS114 | B | 142 | CPS114 | B | | 123 | CPS116 | B+ | 142 | CPS114 | B | | 857 | CPS116 | A+ | 142 | CPS114 | B | | 857 | CPS130 | A+ | 142 | CPS114 | B | | 456 | CPS114 | C | 142 | CPS114 | B | | 142 | CPS116 | B- | 123 | CPS116 | B+ | | 142 | CPS114 | B | 123 | CPS116 | B+ | | 123 | CPS116 | B+ | 123 | CPS116 | B+ | | 857 | CPS116 | A+ | 123 | CPS116 | B+ | | 857 | CPS130 | A+ | 123 | CPS116 | B+ | | 456 | CPS114 | C | 123 | CPS116 | B+ | | 142 | CPS116 | B- | 857 | CPS116 | A+ | | 142 | CPS114 | B | 857 | CPS116 | A+ | | 123 | CPS116 | B+ | 857 | CPS116 | A+ | | 857 | CPS116 | A+ | 857 | CPS116 | A+ | | 857 | CPS130 | A+ | 857 | CPS116 | A+ | | 456 | CPS114 | C | 857 | CPS116 | A+ | | 142 | CPS116 | B- | 857 | CPS130 | A+ | | 142 | CPS114 | B | 857 | CPS130 | A+ | | 123 | CPS116 | B+ | 857 | CPS130 | A+ | | 857 | CPS116 | A+ | 857 | CPS130 | A+ | | 857 | CPS130 | A+ | 857 | CPS130 | A+ | | 456 | CPS114 | C | 857 | CPS130 | A+ | | 142 | CPS116 | B- | 456 | CPS114 | C | | 142 | CPS114 | B | 456 | CPS114 | C | | 123 | CPS116 | B+ | 456 | CPS114 | C | | 857 | CPS116 | A+ | 456 | CPS114 | C | | 857 | CPS130 | A+ | 456 | CPS114 | C | | 456 | CPS114 | C | 456 | CPS114 | C | +------+--------+-------+------+--------+-------+ 36 rows in set (0.00 sec) mysql> SELECT * FROM Grade g1, Grade g2 WHERE g1.CID = g2.CID; +------+--------+-------+------+--------+-------+ | SID | CID | grade | SID | CID | grade | +------+--------+-------+------+--------+-------+ | 142 | CPS116 | B- | 142 | CPS116 | B- | | 123 | CPS116 | B+ | 142 | CPS116 | B- | | 857 | CPS116 | A+ | 142 | CPS116 | B- | | 142 | CPS114 | B | 142 | CPS114 | B | | 456 | CPS114 | C | 142 | CPS114 | B | | 142 | CPS116 | B- | 123 | CPS116 | B+ | | 123 | CPS116 | B+ | 123 | CPS116 | B+ | | 857 | CPS116 | A+ | 123 | CPS116 | B+ | | 142 | CPS116 | B- | 857 | CPS116 | A+ | | 123 | CPS116 | B+ | 857 | CPS116 | A+ | | 857 | CPS116 | A+ | 857 | CPS116 | A+ | | 857 | CPS130 | A+ | 857 | CPS130 | A+ | | 142 | CPS114 | B | 456 | CPS114 | C | | 456 | CPS114 | C | 456 | CPS114 | C | +------+--------+-------+------+--------+-------+ 14 rows in set (0.01 sec) mysql> SELECT * FROM Grade g1, Grade g2 WHERE g1.CID = g2.CID AND g1.SID = 142 A ND g2.SID = 857; +------+--------+-------+------+--------+-------+ | SID | CID | grade | SID | CID | grade | +------+--------+-------+------+--------+-------+ | 142 | CPS116 | B- | 857 | CPS116 | A+ | +------+--------+-------+------+--------+-------+ 1 row in set (0.00 sec) mysql> SELECT g1.CID FROM Grade g1, Grade g2 WHERE g1.CID = g2.CID AND g1.SID = 142 AND g2.SID = 857; +--------+ | CID | +--------+ | CPS116 | +--------+ 1 row in set (0.00 sec) mysql>