Meta·Data Scientist·Technical Phone Screen
- Given a table of buyer-seller listing interactions and a product dimension table, write SQL to find how many sellers have more than 3 distinct products where that product's total interaction count (summed across all rows for that seller-product pair) is greater than 1.
- Among products created in the US within the last 7 days, what percentage of total listing interactions comes from the 'vehicle' category? Return the result as a value between 0 and 100.
“The definition of 'multiple interactions' tripped me up at first.”