Question

Study the query below and choose a statement that describes it correctly. SELECT fname, lname FROM employee WHERE salary > (SELECT salary from EMPLOYEE WHERE fname = 'John' and lname = 'Smith') Question 1 options: The query will return FNAME and LNAME of all employees whose salary is greater than any employee with FNAME as 'John' as 'Smith' The query will return FNAME and LNAME of all employees whose salary is greater than any employee with fname as either 'John' or 'Smith'. The query will return FNAME and LNAME of all employees whose salary is greater than any employee with FNAME as 'John' or LNAME as 'Smith' The query will return the salary for employee with fname as 'John' or 'Smith'

          Study the query below and choose a statement that describes it correctly.
SELECT fname, lname
FROM employee
WHERE salary > (SELECT salary from EMPLOYEE WHERE fname = 'John' and lname = 'Smith')
Question 1 options:
The query will return FNAME and LNAME of all employees whose salary is greater than any employee with FNAME as 'John' as 'Smith'
The query will return FNAME and LNAME of all employees whose salary is greater than any employee with fname as either 'John' or 'Smith'.
The query will return FNAME and LNAME of all employees whose salary is greater than any employee with FNAME as 'John' or LNAME as 'Smith'
The query will return the salary for employee with fname as 'John' or 'Smith'

Added by Jose Carlos B.

Question

Please give Ace some feedback