Kodewick
Start learning →
Starter←→0 / 70

Phone or none

#046StarterNULLSELECT3 min

The front desk is printing the owners list, and empty phone boxes look odd. From the owners table, pick the name and the phone; where the phone is empty (NULL), show 'none' instead.

The tables
owners
idnamecityphone
1LenaOslo555-0101
2MarcoRomeNULL
3PriyaOslo555-0103
4OmarCairoNULL
5SofiaRome555-0105
5 rows
pets
idnamekindageweightowner_id
1Biscuitdog3121
2Mochicat541
3Pepperdog8202
4Nemofish1NULL3
5Lunacat233
6Rexdog1130NULL
7Kiwibird4NULL5
8Tofucat75NULL
8 rows
query.sql
-- your code here: the query below with phone changed to COALESCE(phone, 'none') (write it here, delete the one below)
SELECT name, phone
FROM owners;
Ctrl + Enter runs too
Result

Run shows what your query gives. When it looks right, Submit.