T
Tech Town
Log InSign Up Free
← Back to Blog

July 18, 2025 · admin

SQL Editor






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