<p>There was a robbery from the ATM at the bank where you work. Some unauthorized withdrawals were made, and you need to help your bank find out more about those withdrawals.</p>

<p>However, the only information you have is that there was more than 1 withdrawal, they were all performed in 10-second gaps, and no legitimate transactions were performed in between two fraudulent withdrawals.</p>

<p>We’re given a table of bank transactions with three columns, <code>user_id</code>, a deposit or withdrawal value <code>transaction_value</code>, and <code>created_at</code> time for each transaction.</p>

<p>Write a query to retrieve all user IDs in ascending order whose transactions have exactly a 10-second gap from one another.</p>

<p><em>Note: Assume that there are only withdrawals from the ATM, which are denoted with a positive <code>transaction_value</code></em></p>

<p><strong>Example:</strong> </p>

<p><strong>Input:</strong></p>

<p><code>bank_transactions</code> table</p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>user_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>created_at</code></td>
<td>DATETIME</td>
</tr>

<tr>
<td><code>transaction_value</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>
<p>For given table <code>bank_transactions</code>:</p>

<table>
<thead>
<tr>
<th><code>user_id</code></th>
<th><code>created_at</code></th>
<th><code>transaction_value</code></th>
</tr>
</thead>

<tbody>
<tr>
<td>1</td>
<td>2017-01-01 10:10:15</td>
<td>10</td>
</tr>

<tr>
<td>2</td>
<td>2017-01-01 11:11:11</td>
<td>20</td>
</tr>

<tr>
<td>3</td>
<td>2017-01-01 12:12:12</td>
<td>10</td>
</tr>

<tr>
<td>4</td>
<td>2017-01-01 10:10:20</td>
<td>30</td>
</tr>

<tr>
<td>5</td>
<td>2017-01-01 10:10:34</td>
<td>40</td>
</tr>

<tr>
<td>6</td>
<td>2017-01-01 11:11:21</td>
<td>50</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

<table>
<thead>
<tr>
<th><code>user_id</code></th>
</tr>
</thead>

<tbody>
<tr>
<td>2</td>
</tr>

<tr>
<td>6</td>
</tr>
</tbody>
</table>


There was a robbery from the ATM at the bank where you work. Some unauthorized withdrawals were made, and you need to help your bank find out more about those withdrawals.

ATM Robbery

Comments