# Unique Chat Conversations — 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/3076/unique-chat-conversations
Source observed: 2026-11-04T23:34:33.490Z
Last checked: 2026-11-04T23:34:33.49+00:00
Indexed: 2026-11-06T16:44:46.425+00:00

---

# Unique Chat Conversations

**Difficulty:** Medium  
**Categories:** [Coding](https://www.aced.io/questions?type=coding), [SQL](https://www.aced.io/questions?type=sql)  
**Interview status:** Coding  
**Last asked:** 3 years ago

## Question

WhatsApp is a messaging platform for real-time text messages, voice notes, and multimedia messages. Users can participate in one-to-one or group chats, and each message has a unique identifier.

We provide a table named `messenger_sends` with these columns:

| Column | Meaning |
|---|---|
| `date` | The date the message was sent. |
| `ts` | The timestamp when the message was sent. |
| `sender_id` | The unique identifier of the sender. |
| `receiver_id` | The unique identifier of the receiver. |
| `message_id` | A unique identifier for each message. |

A conversation thread between users A and B is the same thread whether A sends a message to B or B sends a message to A.

**Task:** Write a SQL query that determines the number of unique conversation threads in `messenger_sends`. Return the result as `unique_conversations`.

## Available actions

- [Upgrade](https://www.aced.io/upgrade?src=questions) to unlock detailed company statistics for this question.
- [Sign up to run code](https://www.aced.io/signup?src=lesson).

The question currently has no community-contributed answers. The interactive question interface includes Question, Solution, and Community sections; code execution requires an account.

## About Aced

We are Aced, formerly Exponent. We provide interview preparation through courses, interview questions, practice, experiences, coaching, and related career services. Our available course areas include Product Management, Forward Deployed Engineering, Engineering Management, Software Engineering, System Design, Data Science, Machine Learning, Data Engineering, AI Engineering, Investment Banking, Generative AI, Security Engineer, TPM, Solutions Architect, UX / Product Design, and BizOps & Strategy.

Other resources include [all questions](https://www.aced.io/questions), [interview courses](https://www.aced.io/courses?src=nav), [practice](https://www.aced.io/practice?src=nav), [coaching](https://www.aced.io/coaching?src=nav), [pricing](https://www.aced.io/upgrade?src=nav), [job referrals](https://www.aced.io/jobs/referrals?src=nav), [the blog](https://www.aced.io/blog?src=nav), [resources](https://www.aced.io/resources?src=nav), [university programs](https://www.aced.io/pages/university?src=nav), [business programs](https://www.aced.io/pages/business?src=nav), and [recruiter job posting](https://www.aced.io/jobs/post?src=nav).

---

[Read this page’s summary](https://www.aced.io/agents/api/public/v1/page-tldr?url=https%3A%2F%2Fwww.aced.io%2Fquestions%2F3076%2Funique-chat-conversations&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%2F3076%2Funique-chat-conversations). Opening a form does not execute a tool.