Retrieve all values from ‘state’ column
Anonymous Quiz
13%
SELECT contributors FROM state
61%
SELECT state FROM contributors
2%
SELECT VALUE state FROM contributors
24%
All of the above
Every row's state value would be changed to "NE“
Anonymous Quiz
16%
UPDATE contributors WHERE state = ‘NE’
63%
UPDATE contributors SET state = ‘NE’
21%
UPDATE contributors SET state = ‘NE’ WHERE state = ‘Nebraska’
Nebraska row's state value would be changed to "NE“
Anonymous Quiz
87%
UPDATE contributors SET state = ‘NE’ WHERE state = ‘Nebraska’
5%
UPDATE contributors SET state = ‘NE’ *
8%
UPDATE contributors WHERE state = ‘NE’
To exclude last_name NULL values the query should be
Anonymous Quiz
57%
SELECT id FROM contributors WHERE state = ’VA’ AND last_name IS NULL
43%
SELECT id FROM contributors WHERE state = ’VA’ AND last_name IS NOT NULL