> > >

SQL MCQs

Suppose a table CUSTOMERS has the following records:
+---+--------+----------+
| ID | CUSTOMER| INCOME |
+----+---------+---------+
| 1 | Roman | 150000 |
| 2 | Andrew | 200000 |
| 3 | Christi | 240000 |
| 4 | Ivan | 240000 |
| 5 | John | 240000 |
| 6 | Ann | 240000 |
+----+---------+---------+`
Which of the following statements will select the customers with income more than 200000? (check any that apply)

SELECT INCOME FROM CUSTOMERS WHERE ID IN (SELECT INCOME FROM CUSTOMERS WHERE INCOME > 200000);

SELECT * FROM CUSTOMERS WHERE ID IN (SELECT ID FROM CUSTOMERS WHERE INCOME > 200000);

SELECT * FROM CUSTOMERS WHERE INCOME IN (SELECT CUSTOMER FROM CUSTOMERS WHERE INCOME > 200000);

SELECT * FROM CUSTOMERS WHERE ID IN (SELECT ID FROM CUSTOMERS WHERE INCOME >= 200001);

Answer

Correct Answer:

SELECT * FROM CUSTOMERS WHERE ID IN (SELECT ID FROM CUSTOMERS WHERE INCOME >= 200001);

Explanation:

Note: This question has more than 1 correct answers

Note: This Question is unanswered, help us to find answer for this one

SQL Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it