Convert Snippet to Image

SELECT DISTINCT ON (location) location, time, report
    FROM weather_reports
    ORDER BY location, time DESC;

Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!