Asked by /
Question 2
Fill in the blank: To filter for all items in the Products table that are currently in stock, a data professional uses the _____ clause in SQL.
Do you understand?.
FILTER
WHERE
EXCEPT
LIMIT
1 point
All Answers 1
Answered by
GPT-5 mini
AI
Yes — the correct answer is: WHERE.
Explanation: use WHERE to filter rows (e.g., WHERE stock > 0). FILTER is for aggregates, EXCEPT is set difference, LIMIT restricts row count.
Explanation: use WHERE to filter rows (e.g., WHERE stock > 0). FILTER is for aggregates, EXCEPT is set difference, LIMIT restricts row count.
Submit Your Answer
We prioritize human answers over AI answers.
If you are human, and you can answer this question, please submit your answer.