Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Common Functions in PostgreSQL

Introduction
The COALESCE() function
The GREATEST() & LEAST() functions
The NULLIF() function
Summary
16. Exercise 1

Instruction

Okay, let's see how much you remember. Exercise 1 is waiting for you!

Exercise

Show all product names and the 3rd market shop's prices (casted to char). If the price is NULL, display 'unknown'. The price column should be named price.