ByteDance·Data Scientist·Technical Phone Screen
- Write a SQL query to find the total number of distinct users who both registered and published at least one post on the same day. Note that a single user can publish multiple posts in one day.
“The interviewer nudged me about duplicates partway through, which made me realize I'd written something that would count the same user multiple times if they posted more than once that day.”