Prepare for and practice interview questions from Kroger across topics like Presentation, Analytics, Takehome and more.

Kroger Interview Questions

A/B Testing

Algorithms

Analytics

Machine Learning

Probability

Product Metrics

Python

Statistics

Kroger Interview Guides

<p>You are a chef preparing for an important event. You downloaded three recipes to make and imported each as a separate table: <code>recipe1</code>, <code>recipe2</code>, <code>recipe3</code> into your database. Each recipe requires some grocery items in various quantities.</p>

<p>Write a query that sums up the total mass of each grocery item required across all recipes.</p>

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

<p><code>recipe1</code> table:</p>

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

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

<tr>
<td><code>mass</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<p><code>recipe2</code> table:</p>

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

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

<tr>
<td><code>mass</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<p><code>recipe3</code> table:</p>

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

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

<tr>
<td><code>mass</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

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

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

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


Write a query to generate a shopping list that sums up the total mass of each grocery item required across three recipes.

Generate Shopping List from Recipes

<p>Let’s say we have a table with an <code>id</code> and <code>name</code> fields. The table holds over 100 million rows and we want to sample a random row in the table without throttling the database.</p>

<p>Write a query to randomly sample a row from this table.</p>

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

<p><code>big_table</code> table</p>

<table>
<thead>
<tr>
<th>Columns</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>
</tbody>
</table>


Write a query to randomly sample a row from a big table.

Random SQL Sample

<p>Let’s say that your company is running a standard control and variant AB test on a feature to increase conversion rates on the landing page. The PM checks the results and finds a .04 p-value.</p>

<p>How would you assess the validity of the result?</p>


Kroger Interview Questions

Kroger Interview Guides

Kroger Interview Questions

Kroger Salaries by Position