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

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

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Find the name of those cities with temperature and condition whose condition is either sunny or cloudy but temperature must be greater than 70oF.

SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' OR condition = 'cloudy' AND temperature > 70;
SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' AND condition = 'cloudy' AND temperature > 70;
SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' OR condition = 'cloudy' OR temperature > 70;
SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' AND condition = 'cloudy' OR temperature > 70;

ANSWER DOWNLOAD EXAMIANS APP