It's Autumn! Prices fall like leaves! - hours only!Up to 80% off on all courses and bundles.-Close
Review
2. Get to know the table
Comparisons with NULL
Functions with NULL
COALESCE to the rescue
NULLIF
Review and practice

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.