# Total Transaction Volume — 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/3042/total-transaction-volume
Source observed: 2026-11-04T23:34:24.122Z
Last checked: 2026-11-04T23:34:24.122+00:00
Indexed: 2026-11-07T02:25:53.195+00:00

---

# Total Transaction Volume

We provide this hard SQL interview question through Aced (formerly Exponent), our interview-preparation platform. It asks you to calculate the total transaction value in U.S. dollars for the **Telephones** product line from a supplied e-commerce database schema.

## Question

Write a SQL query that returns the total transaction value in dollars (USD) for the product line `Telephones`. Return the result under the column name `total_amount_in_dollars`.

You must:

- Use the `exchange_rate` table.
- Treat `transactions.amount` as an integer representing hundredths of the base currency.
- Round the result up to two decimal places.

Return a result in this format:

```text
total_amount_in_dollars  -------------------------  float
```

## Database schema

The supplied schema contains these tables and fields:

```text
users
+---------------+---------+
| id            | int     |
| first_name    | varchar |
| last_name     | varchar |
| user_city     | int     |
| email         | int     |
+---------------+---------+

products
+-----------------+---------+
| id              | int     |
| name            | varchar |
| product_line_id  | date    |
| stock           | int     |
+-----------------+---------+

transactions
+---------------+---------+
| id            | int     |
| customer_id   | int     |
| product_id    | int     |
| amount        | int     |
| currency_code | varchar |
| date          | date    |
+---------------+---------+

product_lines
+--------+---------+
| id     | int     |
| name   | varchar |
+--------+---------+

exchange_rate
+----------------------+---------+
| id                   | int     |
| source_currency_code | varchar |
| target_currency_code | varchar |
| rate                 | numeric |
+----------------------+---------+
```

The diagram connects `transactions.customer_id` to `users.id`, `transactions.product_id` to `products.id`, `products.product_line_id` to `product_lines.id`, and currency conversion through `exchange_rate` using the transaction currency and the target currency.

## Access and page controls

The question is categorized as **Coding** and **SQL**, with a **Hard** difficulty rating. We provide Question, Solution, and Community tabs. Detailed company statistics require [Upgrade](https://www.aced.io/upgrade?src=questions). There are currently no community-contributed answers.

Use [Sign up to run code](https://www.aced.io/signup?src=lesson) to run code in the embedded practice environment. The environment includes an editor, output and test-results tabs, and a console.

## Related question

- [Most Recent Transaction](https://www.aced.io/questions/3043/most-recent-transaction)

## Aced interview preparation

We offer interview courses and practice across Product Management, Forward Deployed Engineering, Engineering Management, Software Engineering, System Design, Data Science, Machine Learning, Data Engineering, AI Engineering, Investment Banking, Generative AI, Security Engineering, TPM, Solutions Architecture, UX / Product Design, and BizOps & Strategy. We also offer [Loops](https://www.aced.io/guides?src=nav), [Experiences](https://www.aced.io/experiences?src=nav), [Practice](https://www.aced.io/practice?src=nav), [Coaching](https://www.aced.io/coaching?src=nav), and [Pricing](https://www.aced.io/upgrade?src=nav).

Relevant question directories include [Coding Questions](https://www.aced.io/questions?type=algorithms&filterBy=codeEditor&src=nav), [SQL Questions](https://www.aced.io/questions?type=sql&filterBy=codeEditor&src=nav), and [Browse all questions](https://www.aced.io/questions?src=nav).

[All Questions](https://www.aced.io/questions)

---

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