Comparisons with NULL
Functions with NULL
COALESCE to the rescue
Instruction
All right. Before we start, we'll introduce our today's guest: Mr. Adams. He is CEO for Highland Furniture. – a company which sells furniture and home accessories. He's agreed to show us a snippet of his product table. Let's see what's in there before we move on.
Exercise
Select all columns for the table product and study the contents.
Stuck? Here's a hint!
Use * to select all columns.
