oreilly_getting_started_with_sql
oreilly_getting_started_with_sql copied to clipboard
thomasnield
Syntax doesn't work as expected
On page 51 the author introduces an example of COALESCE() function. But it doesn't work. I mean, there are still NULL fields. Here is the statement:
SELECT * FROM station_data
WHERE coalesce(precipitation, 0) <= 0.5;
Hello @leoosalles, for me also doesn't work. I tried on SQLite Online and VSCode and didn't work either. I sent a errata on official site informing this, now I'm waiting for some response. But did you get how to make that instruction work somehow?
