What is the result of SELECT COUNT(field) FROM a table containing the values 1, 1, 2, and NULL?

The COUNT(column) aggregate function counts only non‑NULL values in the specified column. In a table with the rows 1, 1, 2, and NULL, COUNT(field) will return 3 because the NULL value is excluded. If you used COUNT(*) instead, it would count all rows, including the NULL, and return 4. The WHERE clause "1 = 1" is a tautology and does not filter any rows, so it has no effect on the result. Therefore, the correct answer to the query is 3.