Prepare for and practice interview questions from Tiger Analytics across topics like Algorithms, SQL, Probability and more.

Tiger Analytics Interview Questions

A/B Testing

Algorithms

Analytics

Machine Learning

Probability

Product Metrics

Python

Statistics

Tiger Analytics Interview Guides

Given a table of students and their SAT test scores, write a query to return the two students with the closest test scores with the score difference.

If there are multiple students with the same minimum score difference, select the student name combination that is higher in the alphabet. 

Example:

Input:

<code>scores</code> table

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

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

<tr>
<td><code>student</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>score</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
Output:

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

<tbody>
<tr>
<td><code>one_student</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>other_student</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>score_diff</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>

Closest SAT Scores

You have an array of integers, <code>nums</code> of length <code>n</code> spanning <code>0</code> to <code>n</code> with one missing. Write a function <code>missing_number</code> that returns the missing number in the array.

Note: Complexity of \(O(n)\) required.

Example:

Input:

<pre tabindex="0" class="chroma"><code>nums = [0,1,2,4,5] 
missing_number(nums) -&gt; 3
</code></pre>

Find the missing integer from a array of consequtive integers

Find the Missing Number

Given an array of integers, write a function <code>min_distance</code> to calculate the minimum absolute distance between two elements then return all pairs having that absolute difference.

Note: Make sure to return the pairs in ascending order.

Example:

Input:

<pre tabindex="0" class="chroma"><code>v = [3, 12, 126, 44, 52, 57, 144, 61, 68, 72, 122]
</code></pre>

Output:

<pre tabindex="0" class="chroma"><code>def min_distance(V) -&gt;

min = 4

[[57, 61], [68, 72], [122, 126]]
</code></pre>

Given an array of integers, write a function to calculate the minimum absolute distance between two elements then return all pairs having that absolute difference.

Tiger Analytics Interview Questions

Tiger Analytics Interview Guides

Tiger Analytics Interview Questions

Tiger Analytics Salaries by Position