ShoppingGives Interview Question

How to write a SQL statement that counts and aggregates values from another table.