Prepare for and practice interview questions from Intuit across topics like SQL, Product Metrics, Presentation and more.

Intuit Interview Questions

A/B Testing

Algorithms

Analytics

Machine Learning

Probability

Product Metrics

Python

Statistics

Intuit Interview Guides

<p>A man and a dog stand at opposite ends of a football field that is 100 feet long. Both start running towards each other.</p>

<p>Let’s say that the man runs at \(x\) ft/s and the dog runs at twice the speed of the man. Each time the dog reaches the man, the dog runs back to the end of the field where it started and then back to the man and repeat.</p>

<p>What is the total distance the dog covers once the man finally reaches the end of the field?</p>


Running Dog

Brainteasers

<p>Given a table of <code>transactions</code> and <code>products</code>, write a query to retrieve three columns <code>product_id</code>, <code>product_price</code>, and <code>avg_transaction_total</code> where:</p>

<ol>
<li><p><strong><code>avg_transaction_total</code></strong> is the average of <code>(price * quantity)</code> over <em>all transactions</em> for each product.</p></li>

<li><p>We only want products whose <strong><code>product_price</code></strong> is <em>strictly greater than</em> their own <strong><code>avg_transaction_total</code></strong>.</p></li>
</ol>

<p>Notes:
- <em>Round the values to two decimal places.</em></p>

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

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

<p><code>transactions</code> table</p>

<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>user_id</code></td>
<td>INTEGER</td>
</tr>

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

<tr>
<td><code>product_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>quantity</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<p><code>products</code> table</p>

<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>name</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>price</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>


Above Average Product Prices

<p>Suppose there exists a new airline named Jetco that flies domestically across North America. Jetco recently had a study commissioned that tested the boarding time of every airline, and it came out that Jetco had the fastest average boarding times of any airline.</p>

<p>What factors could have biased this result, and what would you look into?</p>


<p>What could potentially bias the average boarding time in favor of an airline that only flies domestically?</p>

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

Boarding Times Bias

A new airline came out as the fastest average boarding times compared to other airlines.  What factors could have biased this result and what would you look into?

Question	Topic	Difficulty	Ask Chance
Running Dog	Brainteasers	Medium	Very High
Above Average Product Prices	SQL	Medium	Low
Boarding Times Bias	Statistics	Medium	Very Low

Intuit Interview Questions

Intuit Interview Guides

Intuit Interview Questions

Intuit Salaries by Position