Only this week, get the SQL Complete Track of 9 courses in a special prize of $330 $89!
Revision
2. Get to know the table
Comparisons with NULL
Functions with NULL
COALESCE to the rescue
NULLIF
Revision and practice

Instruction

Alright. Before we start, we'll introduce our today's guest: Mr Amund. He's the CEO at Hjem for deg – 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'.