Section 10 Quiz (Answer all questions in this section) 1. A multiple-row operator expects how many values? Mark for Review (1) Points One or more (*) Only one Two or more None 2. The salary column of the f_staffs table contains the following values: 4000 5050 6000 11000 23000 Which of the following statements will return the last_name and first_name of those employees who earn more than 5000? Mark for Review (1) Points SELECT last_name, first_name FROM f_staffs WHERE salary IN (SELECT last_name, first_name FROM f_staffs WHERE salary <5000 o:p=""> SELECT last_name, first_name FROM f_staffs WHERE salary = (SELECT salary FROM f_staffs WHERE salary < 5000); SELECT last_name, first_name FROM f_staffs WHERE salary IN (SELECT salary FROM f_staffs WHERE salary > 5000); (*) SELEC
Within viewpoint, this kind of vast aim could be handiest towards enrollees. https://imgur.com/a/nrzYMZV https://imgur.com/a/9ygdzFh https://imgur.com/a/sxB8tav https://imgur.com/a/xipHTqC https://imgur.com/a/FT0tjcm https://imgur.com/a/e7jF0pq https://imgur.com/a/TPcD6mv
ReplyDelete