Day 4 SQL — Article Views | Learn DISTINCT and GROUP BY | LeetCode 1148 Explained

Welcome back to Day 4 of the LeetCode SQL Study Plan!
Today we solve LeetCode 1148 — Article Views I, a classic interview question where you learn:

How to filter rows using conditions

The difference between DISTINCT and GROUP BY

Returning sorted and unique results

Real interview-level thinking with SQL

This problem helps you understand when to use DISTINCT to avoid duplicate rows and identify authors who viewed their own articles.

📌 Problem:
Find all authors who viewed at least one of their own articles.

📌 Key Concepts:

DISTINCT keyword

GROUP BY clause

WHERE filtering

Sorting results

If you’re following the SQL study plan, don’t forget this is Day 4 — keep the momentum!

💬 Drop your doubts in the comments — I respond to everyone :)

Видео Day 4 SQL — Article Views | Learn DISTINCT and GROUP BY | LeetCode 1148 Explained канала The Algorithm