SQLQuokkaSQLQuokkaMeta's feed team measures how much people engage with their friends' content. Treat 2025-08-15 as today, so yesterday is every moment of 2025-08-14. friendships stores each friendship once, as a pair (user_a, user_b), and the friendship goes both ways. A like counts when it was made yesterday and the liker is friends with the post's author. Likes on your own posts never count. Write an SQL query that returns a single column, friend_likes_yesterday.
Loading…
Try solving the question with the schema explorer and hints first. When ready, reveal the verified canonical query and step-by-step logic breakdown.
Ask questions, share alternate queries, and explore solutions
Your recent query executions and answer checks
This will insert the verified MySQL solution into your editor so you can study how each clause transforms the table.