SQL basics

Counting Rows and Counting Recorded Values Can Produce Different Answers

A table has four rows, but one field contains a missing value. How many observations are there? The answer depends on whether you mean rows, recorded values…