Introduction to SQL
Which of the following SQL query is correct for selecting the name of staffs from 'staffinfo' table where salary is 10,000 or 25,000?

Both A and B
SELECT name FROM staffinfo WHERE salary IN (10000, 25000);
None of these
SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000;

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Find the name of all cities with their temperature, humidity and countries.

SELECT city, temperature, humidity, country FROM location;
SELECT weather.city, temperature, humidity, country FROM weather, location;
SELECT weather.city, temperature, humidity, country FROM weather, location WHERE weather.city = location.city;
SELECT weather.city, temperature, humidity FROM weather SELECT country FROM location WHERE weather.city = location.city;

ANSWER DOWNLOAD EXAMIANS APP