Kk @

![20210119_134543](https://user-images.githubusercontent.com/77664305/105007144-a1ec2c00-5a5d-11eb-8766-4337c288c3df.jpg)

The Slide for Exercise 4.1 is repeated twice in the file sqlfundamentalslides.pdf. (pg 37 & 38)

I appreciate for publishing such a wonderful book.

The top page link is not found. (19/5/1 now)
https://www.dropbox.com/s/e0d67e5wqsxsqmp/getting_started_with_sql_mac.zip?dl=1

Could you retell the link to the contents?

• I've already signed in Dropbox.

Thanks!

Hi, when trying to open weather_stations, it doesn't allow me, saying that "this database is already on the list under name: weather_station".

After installing sqlite studio and downloading the sample databases, I try to open any of them as illustrated on page 13. They all return the error messages such as

could not add database rexon_metals.db

Sqlite Studio works and create a new databases, etc.

Suggestions?

The link that will download a zipped folder containing everything you need, including SQLiteStudio for Mac and the database files doesn't seem to work.

--> https://www.dropbox.com/s/e0d67e5wqsxsqmp/getting_started_with_sql_mac.zip?dl=1

I've downloaded SQLiteStudio, looking for the databases.

TIA!

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;