A data analyst runs the following command:
SELECT age, country -
FROM my_table -
WHERE age >= 75 AND country = 'canada';
Which of the following tables represents the output of the above command?
A data analyst runs the following command:
SELECT age, country -
FROM my_table -
WHERE age >= 75 AND country = 'canada';
Which of the following tables represents the output of the above command?
The SQL command is selecting rows from 'my_table' where the age is greater than or equal to 75 and the country is 'canada'. Therefore, the output should include rows with 'age' values of 75 or more and 'country' value as 'canada'. The correct table should reflect this condition.
Answer is E
Provided answer is correct
Correct answer is E