The mistake is thinking they're interchangeable.
The better mental model is:
What am I filtering? -> At what stage?
Once you understand that, these clauses become much easier to reason about.
Which one confused you first HAVING or QUALIFY? π
#SQL #DataEngineering #SQLTips #Database
π¨ France Football explains the reason for the presence of each candidate.
Hereβs what they highlighted about Leo Messi:
"Why is Messi nominated? At 39, Lionel Messi returned to the shortlist after two years away because he again carried Argentina to a World Cup final and proved that his game still leads both scoring and creation. The official Ballon dβOr site framed it as the secret of his longevity. It added: His legacy as a genius was secured from a relatively young age. Messi is universally considered the prototype of the modern 'number 10' and the false '9' . He is a player capable of simultaneously leading the world's elite in playmaking and goal scoring. The other is his ball control in tight spaces: He achieved the highest historical rating for ball retention under pressure. His low center of gravity and frequent touches with his left foot allow him statistically unprecedented ball control,"
π¨ Messiβs stats during the award period:
βοΈ 48 matches
β½ 45 goals
π °οΈ 30 assists
π ΏοΈ 75 G/A
π₯ 30 MOTM
π§ 46 big chances created
π 148 key passes
π¨ 116 successful dribbles
π 244 shots (106 on target!)
πͺ 234 duels won
π MLS Cup Champions
π MLS Eastern Conference Champions
π₯ MLS Season MVP
π₯ MLS Season Golden Boot
π₯ MLS cup playoffs MVP
π₯ 2025 Leagues Cup runner up
π¨ 2026 World Cup stats:
π₯ World Cup runner up
π₯ 2nd Most goals (8)
π₯ 2nd most assists (4)
π₯ 2nd Most G/A (12)
π₯ Most Big chances created (8)
π₯ Most successful dribbles (25)
π₯ Most Chances Created (25)
π₯ Most Accurate crosses (19)
π₯ 2nd most duels won (52)
π₯ Most shots taken (35)
π₯ 2nd most shots on target (18)
β 17 Ballon dβOr nominations.
2006 β‘οΈ 2026
20 YEARS. π
Backend Engineering Concepts Ranked by Difficulty
π’ HTTP β Easy
π’ CRUD APIs β Easy
π’ Authentication β Easy
π’ SQL Queries β Easy
π΅ Caching β Moderate
π΅ Message Queues β Moderate
π΅ Database Indexing β Moderate
π΅ Rate Limiting β Moderate
π Load Balancing β Hard
π Distributed Systems β Hard
π Event Streaming β Hard
π Database Sharding β Hard
π΄ Distributed Consensus β Very Hard
π΄ Data Replication β Very Hard
π΄ Global Consistency β Very Hard
π΄ Multi-Region Failover β Very Hard
Which one belongs you in?
Pydantic is the data building block of FastAPI. π―
In these past years, it became the data building block of AI... and virtually all Python data validation. π
Come and learn directly from @samuelcolvin, the author of @pydantic, how he uses AI to code.
https://t.co/8rPT3CouAP
Building Fitness Space has changed me beyond the code.
It has taught me patience, leadership, resilience, product thinkingβand most importantly, how to build for people, not just users.
Iβve grown a lot through this journey, both professionally and personally.
This THISDAY feature tells a little more of the story. π
Read the story
https://t.co/PN1wUzHBnG
Instead of watching an hour of Netflix, watch this 2-hour Stanford lecture, which will teach you more about how LLMs like ChatGPT and Claude are built than most people working at top AI companies learn in their entire careers.
The Delta State Police Command has arrested Ifeanyi Ogbonna, male, aged 40, also popularly known as "Odogwu of Asaba," in connection with the alleged rape of a 20-year-old woman, who later died. The arrest followed a petition received by the Command alleging that on 1 June 2026, the deceased travelled to Asaba at the invitation of the suspect, who had offered to train her in content creation, a programme he reportedly promoted through his social media platform.
"Upon her arrival in Asaba, the suspect allegedly took her to a hotel, where he allegedly r@ped her and subjected her to physical violence. She later returned home visibly distressed and disclosed the incident to her parents. In the aftermath of the alleged assault, the deceased made a video recording in which she recounted her experience and the emotional distress she suffered following the incident. She subsequently commited su!cide by ingesting a toxic substance and later d! ed despite efforts to save her life" Edafe Bright, spokesperson of the command said