Introduction to SQL
Table employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE.The SQL statementSELECT COUNT(*) FROM employee WHERE SALARY > ALL (SELECT SALARY FROM EMPLOYEE);prints

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

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

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Which of the following query is correct for using comparison operators in SQL?

SELECT name, course_name FROM student WHERE age>50 and WHERE age<80;
SELECT name, course_name FROM student WHERE age>50 and <80;
SELECT name, course_name FROM student WHERE age>50 and age <80;
None of these

ANSWER DOWNLOAD EXAMIANS APP