A 3.3.3 Worksheet Answers
sql sql Jane’s Grade is stored as NULL, meaning no value. A column left out of an INSERT is set to NULL unless the table defines a default. sql sql sql sql Only Peter is changed, because John was already moved to 11 in question 1. Question 4: without the WHERE clause the update applies to every row in the table, so every student’s grade increases by 1. John would move from 11 to 12. Jane’s grade would stay NULL,...