We have this absurd combination of people that are working 40,50,60+ hours a week when some of them might prefer less, and people cant find any work so they are stuck at 0 hours a week.
Its slightly immersion breaking, but you can save a lot of time by playing on smaller maps. Also quitting after you're 90% sure you've won and skipping the "mop-up" phase.
As much as people like to bash Red Alert 3, the AI in that game understood how to use most of the mechanics, including shipbuilding and shore bombardment.
I gave up on reddit politics because it has an overwhelming pro establishment, pro-corporate-democrats bias. And in their effort to fight against "fake news" this has gotten worse because they effectively only accept links from pro-establishment sources like the washington post.
Additionally,criticism of the democratic party from the left is frequently met with accusations of being a russian shill.
Also I got tired of seeing overused words like "slammed" in article titles.
This is why I think that the buttcoin subreddit is one of the better places to learn and have an honest discussion about bitcoin. Sure,its not that main purpose of that subreddit and there there is still some bias, but the bias is nothing compared to the alteratives
However annecdotal - I moved out of SF and will not return for exactly this reason. At this point I almost laugh whenever someone approaches me for a position where the main office is in SF and they have a "no remote employees" policy.
You dont need include aggregate functions in your select clause to use them in having and order by.
I suppose I may be glossing over another point, but for the subquery example I would've just done:
SELECT first_name, last_name, email
FROM customer
WHERE customer_id IN
(SELECT DISTINCT customer_id
FROM payment
WHERE extract(month from payment_date) = 4
AND extract(day from payment_date) BETWEEN 10 AND 13
GROUP BY customer_id
HAVING SUM(amount) > 30
ORDER BY SUM(amount) DESC
LIMIT 5);