![](/static/253f0d9b/assets/icons/icon-96x96.png)
![](https://fry.gs/pictrs/image/c6832070-8625-4688-b9e5-5d519541e092.png)
6·
1 year agoCounterpoint to lightbulb planned obsolescence: https://youtu.be/zb7Bs98KmnY?si=h-i2U3Q8YE5tHW7G
Counterpoint to lightbulb planned obsolescence: https://youtu.be/zb7Bs98KmnY?si=h-i2U3Q8YE5tHW7G
More then you ever thought you needed to know about lightbulbs! (Including the fact that inconsistent light bulbs are not vacuumes, they just have no oxygen, so they heat up via normal connection)
It has been years since I wrote any SQL, so I may just be missing something but:
Why is the “As it could be” example for the second example using sub selects?!
Especially the one in the where clause where they are selecting two tables that they already joined in the from clause?
And wouldn’t it be quicker to join the review table and use a group by?
Exactly!