August 2011
4 posts
The Unofficial 140 Proof Core Principles
Make everyone look good.
Take risks, and support people when they stick their necks out.
Be solutions-focused or be ignored.
“The match was won on two goals by Lionel Messi of Barcelona. Lionel Messi is...”
– “There Are Only Two Types of Athletes”
“A highly complex and largely discrete set of laws and exemptions from laws has...”
– An Investment Manager’s View on the Top 1%
This SQL query mystifies and awes me.
SELECT SUM(num_imp), fsc.name FROM (SELECT count(*) AS num_imp, i.ad_id FROM impressions_month i WHERE i.verified = true AND i.created_date >= ‘2011-08-02’ AND i.created_date < ‘2011-08-03’ GROUP BY i.ad_id) ad_imp, (SELECT campaigns.id, campaigns.name FROM advertisers, campaigns WHERE advertisers.kind =...
