SQL Queries | MCQs

Explanation

The single equals sign = is used for comparison in SQL conditions.

The query correctly filters rows where the Job column matches the string 'Clerk'.

Explanation

• The correct answer is: Dept_id should not be used in group by clause (although this is not the case in the given query, as it uses dept_name)
• The error in the statement is that the ID column is not included in the GROUP BY clause. When using an aggregate function like AVG, all non-aggregated columns in the SELECT clause must be included in the GROUP BY clause.

Explanation

Create Table By Entering Data. Design View. While Using Wizard.