Final answer:
B. False. The claim regarding aggregate functions and usage of the WHERE and HAVING clauses is false. The WHERE clause filters records before grouping, whereas the HAVING clause filters groups after aggregate functions are applied.
Step-by-step explanation:
The statement "When using Aggregate functions because WHERE applies to individual records, it is not used; the HAVING clause is used instead" is false. The WHERE and HAVING clauses serve different purposes in SQL. The WHERE clause is indeed used to filter individual records based on a specified condition before any grouping operations occur. In contrast, the HAVING clause is used to filter groups after the Aggregate functions have been applied.
For example, if we want to select departments with a total salary greater than a certain amount, we first use a GROUP BY to group the salaries by department, and then apply the HAVING clause to filter departments with the sum of salaries above the specified threshold. The WHERE clause cannot be used in this scenario after grouping, because it does not work on aggregated data.