Introduction to SQL
Find all the tuples having temperature greater than '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 > (SELECT * FROM weather WHERE city = 'Paris')
SELECT * FROM weather WHERE temperature > 'Paris' temperature

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA';

SELECT NAME IN CUSTOMER WHERE STATE = 'V';
SELECT NAME IN CUSTOMER WHERE STATE = 'VA';
SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA');
SELECT NAME IN CUSTOMER WHERE STATE IN ('VA');

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Which of the following query finds colors of boats reserved by "Dustin"?

SELECT DISTINCT b.color FROM boats b, reserves r, sailors s WHERE s.sname = 'Dustin' AND s.sid = r.sid
SELECT DISTINCT b.color FROM boats b, sailors s WHERE s.sname = 'Dustin' AND s.sid = b.sid
SELECT DISTINCT b.color FROM boats b, reserves r, sailors s WHERE s.sname = 'Dustin' AND s.sid = r.sid AND r.bid = b.bid;
SELECT DISTINCT b.color FROM boats b, reserves r, sailors s WHERE s.sname = 'Dustin' AND r.bid = b.bid

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Which of the following query finds the names of the sailors who have reserved at least one boat?

SELECT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid;
SELECT DISTINCT s.sname FROM sailors, reserves WHERE s.sid = r.sid;
None of These
SELECT DISTINCT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid;

ANSWER DOWNLOAD EXAMIANS APP