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()
Takes the string we hand it in parentheses and returns a part of the string.
Anonymous Quiz
88%
SUBSTR()
12%
TRIM()