Lasso Interview Questions

Written by IQ Team

IQ Team

Published December 11, 2025

Estimated reading time: 4 minutes

Back to company list

Table of contents

Lasso Interview Guides

Lasso Interview Questions

Discussion & Interview Experiences

Lasso Interview Guides

Click or hover over a slice to explore questions for that topic.

SQL

(1)

Lasso Interview Questions

Practice for the Lasso interview with these recently asked interview questions.

Question Topic Difficulty

Monthly Product Sales

SQL

Medium

Given a table containing data for monthly sales, write a query to find the total amount of each product sold for each month with each product as its own column in the output table.

Schema

Input:

monthly_sales table

`month`	`product_id`	`amount_sold`
2021-01-01	1	100
2021-01-01	2	300
2021-02-01	3	200
2021-03-01	4	250

Output:

month	1	2	3	4
2021-01-01	100	0	300	0
2021-02-01	0	200	0	0
2021-03-01	0	0	0	250

Example

Input:

monthly_sales table

month	product_id	amount_sold
2021-01-01	1	100
2021-01-01	2	0
2021-01-01	3	250
2021-01-01	4	300
2021-02-01	1	50
2021-02-01	2	200
2021-02-01	3	0
2021-02-01	4	300
2021-03-01	1	400
2021-03-01	2	150
2021-03-01	3	200
2021-03-01	4	300
2021-04-01	1	150
2021-04-01	2	200
2021-04-01	3	50
2021-04-01	4	300
2021-05-01	1	100
2021-05-01	2	150
2021-05-01	3	0
2021-05-01	4	300

Output:

month	1	2	3	4
2021-01-01	100	0	250	300
2021-02-01	50	200	0	300
2021-03-01	400	150	200	300
2021-04-01	150	200	50	300
2021-05-01	100	150	0	300

View Question

Show Solution

Loading pricing options

Calculate Moving Average	SQL	Easy
Predict Customer Churn	Machine Learning	Medium
A/B Test Significance	Statistics	Medium
Optimize Query Performance	SQL	Hard
Feature Importance Analysis	Machine Learning	Medium
Clean Missing Data	Python	Easy
Neural Network Architecture	Deep Learning	Hard
Calculate Cohort Retention	SQL	Medium
Bayesian Probability	Statistics	Easy
Recommend Similar Products	Machine Learning	Hard