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'.

Console

Code editor

Result

TableConsole