Sql - Challenge
Code Life
By Pierre Marsaa
Sightings audit: Step 1
Professor Pi is auditing the field reports and needs three queries from you.
Loading data...
Step 1: who really reports. Return reporter (trimmed and lowercase), reports (number of sightings) and first_seen (the earliest seen_on) — one row per real person, sorted by reporter.
↗️
Loading editor...
↶
↷
💡 Show Solution
Continue