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

Final Quiz
3. Exercise 1

Instruction

Here's the first exercise.

Exercise

Show the first, middle, and last name of each person together in one column (name this new column full_name). Format it like this:

First_name Middle_name LASTNAME

In other words, capitalize the first letter of the first and middle names, and show the last name uppercased.

Show this information only for people whose last names are at least 7 characters long. If a person has a NULL middle name, show an empty string for this middle name.