LinkedIn·Data Scientist·Technical Phone Screen
- Given a posts table with columns for post id, user id, and creation timestamp, write a SQL query that returns each user and their post count over the past 30 days, sorted by post count descending.
“Straightforward aggregation question.”