
Answer-first summary for fast verification
Answer: WHERE
The SELECT clause (A) is used to specify the columns to be retrieved from the database, but it does not provide filtering capabilities based on time ranges. The FROM clause (B) specifies the table or tables from which to retrieve data, but it does not filter the data based on time. The GROUP BY clause (D) is used for aggregating data based on one or more columns, but it does not filter data based on time ranges. The WHERE clause (C) is used to filter the data based on specific conditions, including time ranges. By using the WHERE clause with appropriate time range conditions, you can effectively filter the time-series data for analysis.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.