Andrey Lukyanenko
Senior DS @ Careem
SELECT user, COUNT(*) FROM user_trips WHERE trip_type = "special" AND day = {date} GROUP BY user
https://andlukyane.com/
https://twitter.com/AndLukyane
Blogpost