# Instagram Likes — SQL interview question

Aced (formerly Exponent) publishes a public search API over its indexed pages; the guide is at https://www.aced.io/agents/agent-access.

Source: https://www.aced.io/questions/3049/instagram-likes
Source observed: 2026-11-04T21:34:44.488Z
Last checked: 2026-11-04T21:34:44.488+00:00
Indexed: 2026-11-05T02:52:45.274+00:00

---

# Instagram Likes

We provide this medium-difficulty SQL interview question for **Data Engineer**, **Data Scientist**, and **Data Analyst** roles. It is categorized under **Coding** and **SQL**. The question interface shows **4 interviews**, and the page indicates it was last asked **a year ago**. The solution is locked, and there are currently no answers contributed by the community.

## Problem context

Instagram is a social media platform where users share photos and videos with followers. Users upload images and videos to their profiles; other users can follow accounts, see posts in their feeds, and like, comment on, or share content.

## Schema

You are given two tables: `users` and `posts`.

### `users`

| Column | Type |
| --- | --- |
| `user_id` | integer |
| `username` | string |
| `email` | string |
| `date_joined` | date |

### `posts`

| Column | Type |
| --- | --- |
| `post_id` | integer |
| `user_id` | integer |
| `likes` | integer |
| `post_date` | date |

## Task

Write a SQL query that returns a table with the columns `username` and `num_popular_posts`. Return the **top 3 users** who have created the highest number of posts with **at least 100 likes**.

The page includes an SQL editor with `SQLlite` selected, plus **Output**, **Test Results**, and **Console** panels. We invite users to [sign up to run code](https://www.aced.io/signup?src=lesson). The page also offers an [Upgrade](https://www.aced.io/upgrade?src=questions) option for detailed company statistics.

## Related questions

- [Design Instagram.](https://www.aced.io/questions/1303/design-instagram)
- [How many 'likes' happen on Instagram each day?](https://www.aced.io/questions/2560/daily-instagram-likes-count)

## Related courses

### [Data Analyst Interview Prep](https://www.aced.io/courses/data-analytics)

![Data Analyst Interview Prep](https://images.ctfassets.net/x78yjrjc11pq/72OTqij57b2TklhaD2vrdV/be0dae6242904970d1696e5a4d858e18/AdobeStock_1357126576.jpeg?w=800&h=800&fm=webp&q=75)

We help candidates prepare for data analyst interviews for product, marketing, and business analyst roles through real take-home case studies, technical and dashboarding practice, and strategies from interviewers at technology companies and startups.

### [Data Science Interview Prep](https://www.aced.io/courses/data-science)

![Data Science Interview Prep](https://images.ctfassets.net/x78yjrjc11pq/3U4C5C0OkDR0UeGch4AmlE/7ad489430b676a088cb973307fe77884/Data_Science_Interview_Prep_Course.jpeg?w=800&h=800&fm=webp&q=75)

We help candidates prepare for data science roles at Google, Amazon, Microsoft, Meta, Apple, and other companies with mock interviews, frameworks, and advice from senior candidates. Topics include statistics, experimentation, coding, SQL, machine learning, behavioral interviews, and more.

## Browse related Aced content

- [All questions](https://www.aced.io/questions)
- [Data Engineer questions](https://www.aced.io/questions?role=data-engineer)
- [Data Scientist questions](https://www.aced.io/questions?role=data-science)
- [Data Analyst questions](https://www.aced.io/questions?role=data-analyst)
- [Coding questions](https://www.aced.io/questions?type=coding)
- [SQL questions](https://www.aced.io/questions?type=sql)

Aced was formerly known as Exponent.

---

[Read this page’s summary](https://www.aced.io/agents/api/public/v1/page-tldr?url=https%3A%2F%2Fwww.aced.io%2Fquestions%2F3049%2Finstagram-likes&trace=t_679ff9ab98f3)

## Ask a follow-up about this page

Need a more specific answer? Ask the exact question you have. It returns a fresh, cited answer from Aced (formerly Exponent)’s knowledge base. No account or API key required.

Open this URL with your own question, URL-encoded. Include your question in q. All research inputs are optional; no account or setup.

`GET https://www.aced.io/agents/agent/faq?q={question}&trace=t_679ff9ab98f3`

[Tool guide and examples](https://www.aced.io/agents/agent-access) · [OpenAPI](https://www.aced.io/agents/api/public/v1/openapi.json) · [Page TLDR form](https://www.aced.io/agents/agent-tools/page-tldr?url=https%3A%2F%2Fwww.aced.io%2Fquestions%2F3049%2Finstagram-likes). Opening a form does not execute a tool.