フリー問題

問題文

Which values does the WHERE clause see, and which values does the HAVING clause see?

選択肢

1. The WHERE clause examines the individual rows arriving from storage, and the HAVING clause examines the grouped totals produced by the aggregation.
2. The WHERE clause examines the aggregated results arriving from storage, and the HAVING clause examines the grouped totals produced by the aggregation.
3. The WHERE clause examines the aggregated results arriving from storage, and the HAVING clause examines the stored values produced by the aggregation.
4. The WHERE clause examines the individual rows arriving from storage, and the HAVING clause examines the stored values produced by the aggregation.