Stories

Day 10 of #SocialDistancing #Quarantine. It’s hitting me a bit, the isolation, the silence. Things I am doing to cope. News: Starting the day with this. Anything else seems impossible. Looking at the John Hopkins dashboard and then Google news. The pattern is similar. Shit’s hitting the fan, No. of stupid people are not decreasing. There are some really good memes though. Exercise: I go for a run around the block to reset my mind from the news. On average I see 5–6 people walking their dogs and it’s decreasing. But, the small 15 min run definitely helps with starting the day. ...

Comparison operators LIKE is case sensitive ILIKE is not BETWEEN includes the range bounds IS NULL is for missing values. column=NULL will not work. For non null values - use IS NOT NULL. Don’t use NOT IS NULL Aggregate function COUNT COUNT(col) gives of count of col where values are not null. This is the main difference between COUNT(*) and COUNT(col) SUM, AVG and COUNT can only be used for numeric values. (duh!) AVG ignores null values completely. Does not take in the denominator MIN and MAX can be used for numeric, date, chars GROUP BY ...