79252999

Date: 2024-12-04 23:29:53
Score: 1
Natty:
Report link

Another way using SELF JOIN

Fiddle

SELECT DISTINCT v1.viewer_id
FROM views v1
JOIN views v2
    ON v1.viewer_id = v2.viewer_id
    AND v1.view_date = v2.view_date
    AND v1.article_id <> v2.article_id
ORDER BY v1.viewer_id;

Output

enter image description here

Reasons:
  • Probably link only (1):
  • Low length (0.5):
  • Has code block (-0.5):
Posted by: samhita