Shop My Shelf interview question

Write a SQL query that gets all users and their favorite products.