Last login: Wed Apr 9 12:03:34 on ttyp1 Welcome to Darwin! web019066:~ perkins$ ssh lab2-2.cs.mcgill.ca Password: Password: Last login: Wed Apr 9 12:03:50 2008 from xenix.mcb.mcgill.ca The JVM for this session is: sun-jdk-1.6 The JVM for this session is: sun-jdk-1.6 [perkins][lab2-2][~] ./gosql Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 42398 Server version: 5.0.22 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> SELECT * FROM GeneInfo; +--------+-----------+-------------+ | GeneID | Location | Function | +--------+-----------+-------------+ | G101 | Nucleus | Regulation | | G102 | Cytoplasm | Metabolism | | G103 | Nucleus | Degradation | | G104 | Lysosome | Degradation | | G105 | Cytoplasm | Signaling | | G106 | Cytoplasm | Metabolism | | G107 | Membrane | Signaling | | G108 | Nucleus | Regulation | | G109 | Cytoplasm | Regulation | +--------+-----------+-------------+ 9 rows in set (0.00 sec) mysql> SELECT * FROM GeneExpts; +-------+--------+-----------+ | ExpID | GeneID | Expressed | +-------+--------+-----------+ | E101 | G103 | Yes | | E102 | G104 | No | | E103 | G102 | Yes | | E104 | G107 | Yes | | E105 | G106 | No | | E106 | G104 | Yes | | E107 | G105 | No | | E108 | G101 | Yes | | E109 | G108 | No | | E110 | G109 | Yes | +-------+--------+-----------+ 10 rows in set (0.00 sec) mysql> SELECT * FROM GeneReg; +-----------+-----------+ | Regulator | Regulatee | +-----------+-----------+ | G101 | G102 | | G101 | G105 | | G101 | G106 | | G108 | G104 | | G108 | G102 | | G109 | G105 | | G109 | G108 | +-----------+-----------+ 7 rows in set (0.00 sec) mysql> SELECT * FROM GeneExpts, GeneReg; +-------+--------+-----------+-----------+-----------+ | ExpID | GeneID | Expressed | Regulator | Regulatee | +-------+--------+-----------+-----------+-----------+ | E101 | G103 | Yes | G101 | G102 | | E101 | G103 | Yes | G101 | G105 | | E101 | G103 | Yes | G101 | G106 | | E101 | G103 | Yes | G108 | G104 | | E101 | G103 | Yes | G108 | G102 | | E101 | G103 | Yes | G109 | G105 | | E101 | G103 | Yes | G109 | G108 | | E102 | G104 | No | G101 | G102 | | E102 | G104 | No | G101 | G105 | | E102 | G104 | No | G101 | G106 | | E102 | G104 | No | G108 | G104 | | E102 | G104 | No | G108 | G102 | | E102 | G104 | No | G109 | G105 | | E102 | G104 | No | G109 | G108 | | E103 | G102 | Yes | G101 | G102 | | E103 | G102 | Yes | G101 | G105 | | E103 | G102 | Yes | G101 | G106 | | E103 | G102 | Yes | G108 | G104 | | E103 | G102 | Yes | G108 | G102 | | E103 | G102 | Yes | G109 | G105 | | E103 | G102 | Yes | G109 | G108 | | E104 | G107 | Yes | G101 | G102 | | E104 | G107 | Yes | G101 | G105 | | E104 | G107 | Yes | G101 | G106 | | E104 | G107 | Yes | G108 | G104 | | E104 | G107 | Yes | G108 | G102 | | E104 | G107 | Yes | G109 | G105 | | E104 | G107 | Yes | G109 | G108 | | E105 | G106 | No | G101 | G102 | | E105 | G106 | No | G101 | G105 | | E105 | G106 | No | G101 | G106 | | E105 | G106 | No | G108 | G104 | | E105 | G106 | No | G108 | G102 | | E105 | G106 | No | G109 | G105 | | E105 | G106 | No | G109 | G108 | | E106 | G104 | Yes | G101 | G102 | | E106 | G104 | Yes | G101 | G105 | | E106 | G104 | Yes | G101 | G106 | | E106 | G104 | Yes | G108 | G104 | | E106 | G104 | Yes | G108 | G102 | | E106 | G104 | Yes | G109 | G105 | | E106 | G104 | Yes | G109 | G108 | | E107 | G105 | No | G101 | G102 | | E107 | G105 | No | G101 | G105 | | E107 | G105 | No | G101 | G106 | | E107 | G105 | No | G108 | G104 | | E107 | G105 | No | G108 | G102 | | E107 | G105 | No | G109 | G105 | | E107 | G105 | No | G109 | G108 | | E108 | G101 | Yes | G101 | G102 | | E108 | G101 | Yes | G101 | G105 | | E108 | G101 | Yes | G101 | G106 | | E108 | G101 | Yes | G108 | G104 | | E108 | G101 | Yes | G108 | G102 | | E108 | G101 | Yes | G109 | G105 | | E108 | G101 | Yes | G109 | G108 | | E109 | G108 | No | G101 | G102 | | E109 | G108 | No | G101 | G105 | | E109 | G108 | No | G101 | G106 | | E109 | G108 | No | G108 | G104 | | E109 | G108 | No | G108 | G102 | | E109 | G108 | No | G109 | G105 | | E109 | G108 | No | G109 | G108 | | E110 | G109 | Yes | G101 | G102 | | E110 | G109 | Yes | G101 | G105 | | E110 | G109 | Yes | G101 | G106 | | E110 | G109 | Yes | G108 | G104 | | E110 | G109 | Yes | G108 | G102 | | E110 | G109 | Yes | G109 | G105 | | E110 | G109 | Yes | G109 | G108 | +-------+--------+-----------+-----------+-----------+ 70 rows in set (0.00 sec) mysql> SELECT * FROM GeneExpts, GeneReg WHERE GeneExpts.Expressed='Yes'; +-------+--------+-----------+-----------+-----------+ | ExpID | GeneID | Expressed | Regulator | Regulatee | +-------+--------+-----------+-----------+-----------+ | E101 | G103 | Yes | G101 | G102 | | E101 | G103 | Yes | G101 | G105 | | E101 | G103 | Yes | G101 | G106 | | E101 | G103 | Yes | G108 | G104 | | E101 | G103 | Yes | G108 | G102 | | E101 | G103 | Yes | G109 | G105 | | E101 | G103 | Yes | G109 | G108 | | E103 | G102 | Yes | G101 | G102 | | E103 | G102 | Yes | G101 | G105 | | E103 | G102 | Yes | G101 | G106 | | E103 | G102 | Yes | G108 | G104 | | E103 | G102 | Yes | G108 | G102 | | E103 | G102 | Yes | G109 | G105 | | E103 | G102 | Yes | G109 | G108 | | E104 | G107 | Yes | G101 | G102 | | E104 | G107 | Yes | G101 | G105 | | E104 | G107 | Yes | G101 | G106 | | E104 | G107 | Yes | G108 | G104 | | E104 | G107 | Yes | G108 | G102 | | E104 | G107 | Yes | G109 | G105 | | E104 | G107 | Yes | G109 | G108 | | E106 | G104 | Yes | G101 | G102 | | E106 | G104 | Yes | G101 | G105 | | E106 | G104 | Yes | G101 | G106 | | E106 | G104 | Yes | G108 | G104 | | E106 | G104 | Yes | G108 | G102 | | E106 | G104 | Yes | G109 | G105 | | E106 | G104 | Yes | G109 | G108 | | E108 | G101 | Yes | G101 | G102 | | E108 | G101 | Yes | G101 | G105 | | E108 | G101 | Yes | G101 | G106 | | E108 | G101 | Yes | G108 | G104 | | E108 | G101 | Yes | G108 | G102 | | E108 | G101 | Yes | G109 | G105 | | E108 | G101 | Yes | G109 | G108 | | E110 | G109 | Yes | G101 | G102 | | E110 | G109 | Yes | G101 | G105 | | E110 | G109 | Yes | G101 | G106 | | E110 | G109 | Yes | G108 | G104 | | E110 | G109 | Yes | G108 | G102 | | E110 | G109 | Yes | G109 | G105 | | E110 | G109 | Yes | G109 | G108 | +-------+--------+-----------+-----------+-----------+ 42 rows in set (0.00 sec) mysql> SELECT * FROM GeneExpts, GeneReg WHERE GeneExpts.Expressed='Yes' AND GeneReg.Regulatee=GeneExpts.GeneID; +-------+--------+-----------+-----------+-----------+ | ExpID | GeneID | Expressed | Regulator | Regulatee | +-------+--------+-----------+-----------+-----------+ | E103 | G102 | Yes | G101 | G102 | | E103 | G102 | Yes | G108 | G102 | | E106 | G104 | Yes | G108 | G104 | +-------+--------+-----------+-----------+-----------+ 3 rows in set (0.00 sec) mysql> SELECT * FROM GeneExpts, GeneReg WHERE GeneExpts.Expressed='Yes' AND GeneReg.Regulator=GeneExpts.GeneID; +-------+--------+-----------+-----------+-----------+ | ExpID | GeneID | Expressed | Regulator | Regulatee | +-------+--------+-----------+-----------+-----------+ | E108 | G101 | Yes | G101 | G102 | | E108 | G101 | Yes | G101 | G105 | | E108 | G101 | Yes | G101 | G106 | | E110 | G109 | Yes | G109 | G105 | | E110 | G109 | Yes | G109 | G108 | +-------+--------+-----------+-----------+-----------+ 5 rows in set (0.01 sec) mysql> SELECT GeneReg.Regulatee FROM GeneExpts, GeneReg WHERE GeneExpts.Expressed='Yes' AND GeneReg.Regulator=GeneExpts.GeneID; +-----------+ | Regulatee | +-----------+ | G102 | | G105 | | G106 | | G105 | | G108 | +-----------+ 5 rows in set (0.01 sec) mysql> SELECT DISTINCT GeneReg.Regulatee FROM GeneExpts, GeneReg WHERE GeneExpts.Expressed='Yes' AND GeneReg.Regulator=GeneExpts.GeneID; +-----------+ | Regulatee | +-----------+ | G102 | | G105 | | G106 | | G108 | +-----------+ 4 rows in set (0.00 sec) mysql> SHOW TABLES; +--------------------------------+ | Tables_in_2008Winter364perkins | +--------------------------------+ | C2 | | Contracts | | Cultures | | Dating | | GeneExpts | | GeneExptsBackup | | GeneInfo | | GeneInfoBackup | | GeneInfoHW5 | | GeneReg | | GeneRegBackup | | GeneSeqsHW5 | | GoodStudents | | Grades | | List1 | | List2 | | Movies | | Presidents | | Salaries | | Stu2 | | StudentInfo | | Students | | Students2 | | t | | t2 | +--------------------------------+ 25 rows in set (0.00 sec) mysql> SELECT * FROM Cultures; +------+------+------+------+------------------+ | ID | Init | T1 | T2 | PredT1 | +------+------+------+------+------------------+ | 1 | 10 | 12.2 | 35 | 11.0517091807565 | | 2 | 13.4 | 14.2 | 15.2 | 14.8092903022137 | | 3 | 8 | 13 | 18.2 | 8.84136734460518 | | 4 | 11.1 | 14.6 | 30.2 | 12.2673971906397 | | 5 | 15.1 | 16.6 | 12.2 | 16.6880808629423 | | 6 | 13 | 19 | 81 | 14.3672219349834 | | 7 | 11 | 10 | 0.1 | 12.1568800988321 | +------+------+------+------+------------------+ 7 rows in set (0.02 sec) mysql> SELECT * FROM Dating; +----------+-------+--------+------+ | MemberID | Name | Gender | Age | +----------+-------+--------+------+ | 1001 | Bob | M | 22 | | 1002 | Alice | F | 19 | | 1003 | Norm | M | 28 | | 1004 | Bill | M | 32 | | 1005 | Nancy | F | 24 | +----------+-------+--------+------+ 5 rows in set (0.01 sec) mysql> SHOW TABLES; +--------------------------------+ | Tables_in_2008Winter364perkins | +--------------------------------+ | C2 | | Contracts | | Cultures | | Dating | | GeneExpts | | GeneExptsBackup | | GeneInfo | | GeneInfoBackup | | GeneInfoHW5 | | GeneReg | | GeneRegBackup | | GeneSeqsHW5 | | GoodStudents | | Grades | | List1 | | List2 | | Movies | | Presidents | | Salaries | | Stu2 | | StudentInfo | | Students | | Students2 | | t | | t2 | +--------------------------------+ 25 rows in set (0.00 sec) mysql> CREATE TABLE DatingCopy SELECT * Dating; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Dating' at line 1 mysql> CREATE TABLE DatingCopy SELECT * FROM Dating; Query OK, 5 rows affected (0.01 sec) Records: 5 Duplicates: 0 Warnings: 0 mysql> SELECT * FROM DatingCopy; +----------+-------+--------+------+ | MemberID | Name | Gender | Age | +----------+-------+--------+------+ | 1001 | Bob | M | 22 | | 1002 | Alice | F | 19 | | 1003 | Norm | M | 28 | | 1004 | Bill | M | 32 | | 1005 | Nancy | F | 24 | +----------+-------+--------+------+ 5 rows in set (0.00 sec) mysql> SELECT * FROM Dating, DatingCopy; +----------+-------+--------+------+----------+-------+--------+------+ | MemberID | Name | Gender | Age | MemberID | Name | Gender | Age | +----------+-------+--------+------+----------+-------+--------+------+ | 1001 | Bob | M | 22 | 1001 | Bob | M | 22 | | 1002 | Alice | F | 19 | 1001 | Bob | M | 22 | | 1003 | Norm | M | 28 | 1001 | Bob | M | 22 | | 1004 | Bill | M | 32 | 1001 | Bob | M | 22 | | 1005 | Nancy | F | 24 | 1001 | Bob | M | 22 | | 1001 | Bob | M | 22 | 1002 | Alice | F | 19 | | 1002 | Alice | F | 19 | 1002 | Alice | F | 19 | | 1003 | Norm | M | 28 | 1002 | Alice | F | 19 | | 1004 | Bill | M | 32 | 1002 | Alice | F | 19 | | 1005 | Nancy | F | 24 | 1002 | Alice | F | 19 | | 1001 | Bob | M | 22 | 1003 | Norm | M | 28 | | 1002 | Alice | F | 19 | 1003 | Norm | M | 28 | | 1003 | Norm | M | 28 | 1003 | Norm | M | 28 | | 1004 | Bill | M | 32 | 1003 | Norm | M | 28 | | 1005 | Nancy | F | 24 | 1003 | Norm | M | 28 | | 1001 | Bob | M | 22 | 1004 | Bill | M | 32 | | 1002 | Alice | F | 19 | 1004 | Bill | M | 32 | | 1003 | Norm | M | 28 | 1004 | Bill | M | 32 | | 1004 | Bill | M | 32 | 1004 | Bill | M | 32 | | 1005 | Nancy | F | 24 | 1004 | Bill | M | 32 | | 1001 | Bob | M | 22 | 1005 | Nancy | F | 24 | | 1002 | Alice | F | 19 | 1005 | Nancy | F | 24 | | 1003 | Norm | M | 28 | 1005 | Nancy | F | 24 | | 1004 | Bill | M | 32 | 1005 | Nancy | F | 24 | | 1005 | Nancy | F | 24 | 1005 | Nancy | F | 24 | +----------+-------+--------+------+----------+-------+--------+------+ 25 rows in set (0.00 sec) mysql> CREATE TABLE DatingM FROM Dating WHERE Gender='M'; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM Dating WHERE Gender='M'' at line 1 mysql> CREATE TABLE DatingM SELECT * FROM Dating WHERE Gender='M'; Query OK, 3 rows affected (0.00 sec) Records: 3 Duplicates: 0 Warnings: 0 mysql> SELECT * DatingM; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DatingM' at line 1 mysql> SELECT * FROM DatingM; +----------+------+--------+------+ | MemberID | Name | Gender | Age | +----------+------+--------+------+ | 1001 | Bob | M | 22 | | 1003 | Norm | M | 28 | | 1004 | Bill | M | 32 | +----------+------+--------+------+ 3 rows in set (0.00 sec) mysql> CREATE TABLE DatingF SELECT * FROM Dating WHERE Gender='F'; Query OK, 2 rows affected (0.01 sec) Records: 2 Duplicates: 0 Warnings: 0 mysql> SELECT * FROM DatingF; +----------+-------+--------+------+ | MemberID | Name | Gender | Age | +----------+-------+--------+------+ | 1002 | Alice | F | 19 | | 1005 | Nancy | F | 24 | +----------+-------+--------+------+ 2 rows in set (0.00 sec) mysql> SELECT * FROM DatingM, DatingF; +----------+------+--------+------+----------+-------+--------+------+ | MemberID | Name | Gender | Age | MemberID | Name | Gender | Age | +----------+------+--------+------+----------+-------+--------+------+ | 1001 | Bob | M | 22 | 1002 | Alice | F | 19 | | 1001 | Bob | M | 22 | 1005 | Nancy | F | 24 | | 1003 | Norm | M | 28 | 1002 | Alice | F | 19 | | 1003 | Norm | M | 28 | 1005 | Nancy | F | 24 | | 1004 | Bill | M | 32 | 1002 | Alice | F | 19 | | 1004 | Bill | M | 32 | 1005 | Nancy | F | 24 | +----------+------+--------+------+----------+-------+--------+------+ 6 rows in set (0.01 sec) mysql> SELECT DatingM.Name, DatingF.Name FROM DatingM, DatingF; +------+-------+ | Name | Name | +------+-------+ | Bob | Alice | | Bob | Nancy | | Norm | Alice | | Norm | Nancy | | Bill | Alice | | Bill | Nancy | +------+-------+ 6 rows in set (0.00 sec) mysql> CREATE TABLE DatingF2 SELECT * FROM DatingF; Query OK, 2 rows affected (0.00 sec) Records: 2 Duplicates: 0 Warnings: 0 mysql> SELECT * FROM DatingF2; +----------+-------+--------+------+ | MemberID | Name | Gender | Age | +----------+-------+--------+------+ | 1002 | Alice | F | 19 | | 1005 | Nancy | F | 24 | +----------+-------+--------+------+ 2 rows in set (0.00 sec) mysql> SELECT DatingF.Name, DatingF2.Name FROM DatingF, DatingF2; +-------+-------+ | Name | Name | +-------+-------+ | Alice | Alice | | Nancy | Alice | | Alice | Nancy | | Nancy | Nancy | +-------+-------+ 4 rows in set (0.00 sec) mysql> SELECT DatingF.Name, DatingF2.Name FROM DatingF, DatingF2 WHERE DatingF.MemberID<>DatingF2.MemberID; +-------+-------+ | Name | Name | +-------+-------+ | Nancy | Alice | | Alice | Nancy | +-------+-------+ 2 rows in set (0.00 sec) mysql> SHOW TABLES; +--------------------------------+ | Tables_in_2008Winter364perkins | +--------------------------------+ | C2 | | Contracts | | Cultures | | Dating | | DatingCopy | | DatingF | | DatingF2 | | DatingM | | GeneExpts | | GeneExptsBackup | | GeneInfo | | GeneInfoBackup | | GeneInfoHW5 | | GeneReg | | GeneRegBackup | | GeneSeqsHW5 | | GoodStudents | | Grades | | List1 | | List2 | | Movies | | Presidents | | Salaries | | Stu2 | | StudentInfo | | Students | | Students2 | | t | | t2 | +--------------------------------+ 29 rows in set (0.00 sec) mysql> SELECT * FROM Students; +-----------+------+-------+--------------+ | Name | ID | Grade | PercentGrade | +-----------+------+-------+--------------+ | Bob | 314 | A+ | 96.4 | | Mary | 110 | B | 75.7 | | Frank | 253 | C | 67 | | George | 876 | B- | 73.1 | | Veronique | 129 | NULL | NULL | +-----------+------+-------+--------------+ 5 rows in set (0.03 sec) mysql> SELECT * FROM Students2; +--------+-------+-------+-------+-------+ | Name | Quiz1 | Quiz2 | Final | Grade | +--------+-------+-------+-------+-------+ | Bob | 80 | 82 | 90 | NULL | | Zoe | 70 | 92 | 81 | NULL | | George | 64 | 88 | 89 | NULL | | Smith | 99 | 99 | 99 | NULL | | Carla | 90 | 89 | 88 | NULL | | Noah | 97 | 87 | 76 | NULL | | Tara | 57 | 37 | 66 | NULL | | Tommy | 70 | NULL | 84 | NULL | +--------+-------+-------+-------+-------+ 8 rows in set (0.02 sec) mysql> /* Above average score on final... */ mysql> SELECT AVG(Final) FROM Students2; +------------+ | AVG(Final) | +------------+ | 84.1250 | +------------+ 1 row in set (0.00 sec) mysql> SELECT * FROM Students2 WHERE Final>84.125; +--------+-------+-------+-------+-------+ | Name | Quiz1 | Quiz2 | Final | Grade | +--------+-------+-------+-------+-------+ | Bob | 80 | 82 | 90 | NULL | | George | 64 | 88 | 89 | NULL | | Smith | 99 | 99 | 99 | NULL | | Carla | 90 | 89 | 88 | NULL | +--------+-------+-------+-------+-------+ 4 rows in set (0.00 sec) mysql> /* Assigning average to a variable */ mysql> SELECT @FinalAvg:=AVG(Final) FROM Students2; +-----------------------+ | @FinalAvg:=AVG(Final) | +-----------------------+ | 84.125000000 | +-----------------------+ 1 row in set (0.00 sec) mysql> SELECT @FinalAvg; +--------------+ | @FinalAvg | +--------------+ | 84.125000000 | +--------------+ 1 row in set (0.00 sec) mysql> SELECT * FROM Students2 WHERE Final>@FinalAvg; +--------+-------+-------+-------+-------+ | Name | Quiz1 | Quiz2 | Final | Grade | +--------+-------+-------+-------+-------+ | Bob | 80 | 82 | 90 | NULL | | George | 64 | 88 | 89 | NULL | | Smith | 99 | 99 | 99 | NULL | | Carla | 90 | 89 | 88 | NULL | +--------+-------+-------+-------+-------+ 4 rows in set (0.00 sec) mysql> SELECT * FROM Students2 WHERE Final>@FinalAvg:=AVG(Final);; ERROR 1111 (HY000): Invalid use of group function ERROR: No query specified mysql> SELECT * FROM Students2 WHERE Final>80;+--------+-------+-------+-------+-------+ | Name | Quiz1 | Quiz2 | Final | Grade | +--------+-------+-------+-------+-------+ | Bob | 80 | 82 | 90 | NULL | | Zoe | 70 | 92 | 81 | NULL | | George | 64 | 88 | 89 | NULL | | Smith | 99 | 99 | 99 | NULL | | Carla | 90 | 89 | 88 | NULL | | Tommy | 70 | NULL | 84 | NULL | +--------+-------+-------+-------+-------+ 6 rows in set (0.00 sec) mysql> CREATE VIEW GoodStudents2 AS SELECT * FROM Students2 WHERE Final>80; Query OK, 0 rows affected (0.00 sec) mysql> SELECT * FROM GoodStudents2; +--------+-------+-------+-------+-------+ | Name | Quiz1 | Quiz2 | Final | Grade | +--------+-------+-------+-------+-------+ | Bob | 80 | 82 | 90 | NULL | | Zoe | 70 | 92 | 81 | NULL | | George | 64 | 88 | 89 | NULL | | Smith | 99 | 99 | 99 | NULL | | Carla | 90 | 89 | 88 | NULL | | Tommy | 70 | NULL | 84 | NULL | +--------+-------+-------+-------+-------+ 6 rows in set (0.00 sec) mysql> SELECT * Students2; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Students2' at line 1 mysql> SELECT * FROM Students2; +--------+-------+-------+-------+-------+ | Name | Quiz1 | Quiz2 | Final | Grade | +--------+-------+-------+-------+-------+ | Bob | 80 | 82 | 90 | NULL | | Zoe | 70 | 92 | 81 | NULL | | George | 64 | 88 | 89 | NULL | | Smith | 99 | 99 | 99 | NULL | | Carla | 90 | 89 | 88 | NULL | | Noah | 97 | 87 | 76 | NULL | | Tara | 57 | 37 | 66 | NULL | | Tommy | 70 | NULL | 84 | NULL | +--------+-------+-------+-------+-------+ 8 rows in set (0.00 sec) mysql> UPDATE Students2 SET Final=78 WHERE Name='Carla'; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql> SELECT * FROM Students2; +--------+-------+-------+-------+-------+ | Name | Quiz1 | Quiz2 | Final | Grade | +--------+-------+-------+-------+-------+ | Bob | 80 | 82 | 90 | NULL | | Zoe | 70 | 92 | 81 | NULL | | George | 64 | 88 | 89 | NULL | | Smith | 99 | 99 | 99 | NULL | | Carla | 90 | 89 | 78 | NULL | | Noah | 97 | 87 | 76 | NULL | | Tara | 57 | 37 | 66 | NULL | | Tommy | 70 | NULL | 84 | NULL | +--------+-------+-------+-------+-------+ 8 rows in set (0.00 sec) mysql> SELECT * FROM GoodStudents2; +--------+-------+-------+-------+-------+ | Name | Quiz1 | Quiz2 | Final | Grade | +--------+-------+-------+-------+-------+ | Bob | 80 | 82 | 90 | NULL | | Zoe | 70 | 92 | 81 | NULL | | George | 64 | 88 | 89 | NULL | | Smith | 99 | 99 | 99 | NULL | | Tommy | 70 | NULL | 84 | NULL | +--------+-------+-------+-------+-------+ 5 rows in set (0.00 sec) mysql>