Introduction to SQL
Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA';

SELECT NAME IN CUSTOMER WHERE STATE = 'V';
SELECT NAME IN CUSTOMER WHERE STATE IN ('VA');
SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA');
SELECT NAME IN CUSTOMER WHERE STATE = 'VA';

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Find the name of cities with all entries whose temperature is in the range of 71 and 89

SELECT * FROM weather WHERE temperature BETWEEN 71 AND 89;
SELECT * FROM weather WHERE temperature NOT IN (71 and 89);
SELECT * FROM weather WHERE temperature NOT BETWEEN 71 to 89;
SELECT * FROM weather WHERE temperature NOT IN (71 to 89);

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
NULL is

the same as blank for character
the same as 0 for integer and blank for character
not a value
the same as 0 for integer

ANSWER DOWNLOAD EXAMIANS APP