Introduction to SQL
The HAVING clause does which of the following?

Acts like a WHERE clause but is used for columns rather than groups.
Acts like a WHERE clause but is used for rows rather than columns.
Acts like a WHERE clause but is used for groups rather than rows.
Acts EXACTLY like a WHERE clause.

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 NOT IN (71 to 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;

ANSWER DOWNLOAD EXAMIANS APP