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

Acts like a WHERE clause but is used for groups rather than rows.
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 EXACTLY like a WHERE clause.

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Find the names of the countries whose condition is sunny.

SELECT country FROM location WHERE condition = 'sunny';
SELECT country FROM location WHERE city IN (SELECT city FROM weather WHERE condition = sunny');
SELECT country FROM location WHERE city NOT IN (SELECT city FROM weather WHERE condition = 'sunny');
SELECT country FROM location WHERE city UNION (SELECT city FROM weather WHERE condition = 'sunny');

ANSWER DOWNLOAD EXAMIANS APP