-- What it does: Shows why NULL cannot be compared using = or != -- Why use it: Prevents common beginner mistake ...

Find the average scores of the customers. Uses COALESCE to replace NULL Score with 0.

Well from spending last summer modifing a database, which was not the best design I learned to think twice before you implement a database, since that will reduce the frustration for anybody working ...