Introduction to SQL
How to select all data from student table starting the name from letter 'r'?

SELECT * FROM student WHERE name LIKE 'r%';
SELECT * FROM student WHERE name LIKE '_r%';
SELECT * FROM student WHERE name LIKE '%r';
SELECT * FROM student WHERE name LIKE '%r%';

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 NOT IN (SELECT city FROM weather WHERE condition = 'sunny');
SELECT country FROM location WHERE city 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