Introduction to SQL
Which of the following is illegal?

SELECT SYSDATE - (SYSDATE - 2) FROM DUAL;
SELECT SYSDATE - (SYSDATE + 2) FROM DUAL;
SELECT SYSDATE - SYSDATE FROM DUAL;
None of these

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Find all the cities with temperature, condition and humidity whose humidity is in the range of 63 to 79

SELECT * FROM weather WHERE humidity BETWEEN 63 AND 79
SELECT * FROM weather WHERE humidity NOT BETWEEN 63 AND 79
SELECT * FROM weather WHERE humidity NOT IN (63 AND 79)
SELECT * FROM weather WHERE humidity IN (63 to 79)

ANSWER DOWNLOAD EXAMIANS APP