0 of 50 solved/50

1148. Article Views I

SQL 50 · Select (day 1). Decode it with the hints, solve it on LeetCode, then compare with the reference solution in MySQLPostgreSQL.

Your work

Status Notes Your solution (MySQLPostgreSQL)

Open one at a time. Try to finish with as few as you can.

1. What does one output row represent?

One author who viewed their own article.

2. Approach

WHERE author_id = viewer_id, SELECT DISTINCT, alias it as id, ORDER BY id.

3. The trap

The same author can match many rows; DISTINCT removes repeats.

Tested on MySQL 8.0 and PostgreSQL 16. Switch dialect at the top of the page.

Show the MySQLPostgreSQL solution

SELECT DISTINCT author_id AS id
FROM Views
WHERE author_id = viewer_id
ORDER BY id;