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.