this post was submitted on 17 Jun 2023
-3 points (20.0% liked)
General Programming Discussion
7809 readers
5 users here now
A general programming discussion community.
Rules:
- Be civil.
- Please start discussions that spark conversation
Other communities
Systems
Functional Programming
Also related
founded 5 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
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?
I think the example is trying to optimize for readability to show that it can be pretty intuitive, but I think you're right.