Cacher is the code snippet organizer for pro developers

SELECT COUNT(current_car_id) as doubled, car_registration_number as reg_num
    FROM taxijakt.wave_drivers
    WHERE car_registration_number is not NULL AND car_registration_number != ''
    GROUP BY car_registration_numberoccurrences
    HAVING COUNT(car_registration_number) > 1
ORDER BY 1 DESC;