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
To obtain the top 15 contributors by contribution, let's utilize the … keyword
Anonymous Quiz
89%
LIMIT
10%
WHERE
1%
IF
To make sure that the last character must be a period we use the query …
Anonymous Quiz
66%
SELECT id FROM contributors WHERE first_name LIKE ‘%_.’
13%
SELECT id FROM contributors WHERE first_name LIKE ‘%._’
21%
SELECT id FROM contributors WHERE first_name LIKE ‘_.%’
search will return the lower-case version
Anonymous Quiz
2%
SUBSTR()
2%
TRIM()
3%
UPPER()
93%
LOWER()