Introduction to SQL
Which of the SQL statements is correct?

SELECT Username, Password WHERE Username = 'user1'
SELECT Username AND Password FROM Users
None of these
SELECT Username, Password FROM Users

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Find the temperature in increasing order of all cities

SELECT city, temperature FROM weather ORDER BY temperature;
SELECT city, temperature FROM weather;
SELECT city FROM weather ORDER BY temperature;
SELECT city, temperature FROM weather ORDER BY city;

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Find all the tuples having temperature greater than 'Paris'.

SELECT * FROM weather WHERE temperature > (SELECT * FROM weather WHERE city = 'Paris')
SELECT * FROM weather WHERE temperature > (SELECT city FROM weather WHERE city = 'Paris')
SELECT * FROM weather WHERE temperature > (SELECT temperature FROM weather WHERE city = 'Paris')
SELECT * FROM weather WHERE temperature > 'Paris' temperature

ANSWER DOWNLOAD EXAMIANS APP