Focused SQL Practice Environment


SQL Challenge

đź“‹ Description

Write a solution to find all authors who viewed at least one of their own articles.
Return the result table with a single column `id`, sorted in ascending order.

📦 Table Schema: `Views`

+-------------+------+
| Column      | Type |
+-------------+------+
| article_id  | int  |
| author_id   | int  |
| viewer_id   | int  |
| view_date   | date |
+-------------+

📥 Sample Input

📤 Expected Output

SQL Editor