Customers who purchased products from all available categories

  Рет қаралды 164

InsightsLift

InsightsLift

Күн бұрын

Пікірлер: 2
@SunnySingh-mi8db
@SunnySingh-mi8db 21 күн бұрын
thx mam
@shubhamgoyal5227
@shubhamgoyal5227 21 күн бұрын
SELECT customer_id FROM purchases GROUP BY customer_id HAVING COUNT(DISTINCT product_id) = (SELECT COUNT(DISTINCT product_id) FROM products)
Find out Median of salaries .
8:20
Find out Median of salaries .
InsightsLift
Рет қаралды 149
Find the maximum consecutive number of days for which restaurant received an order .
8:09
Find the maximum consecutive number of days for which restaurant received an order .
InsightsLift
Рет қаралды 131
黑天使只对C罗有感觉#short #angel #clown
00:39
黑天使只对C罗有感觉#short #angel #clown
Super Beauty team
Рет қаралды 36 МЛН
Қарғалардың анасы бар ма? | 1 серия | Сериал «‎QARGA 2»‎ | КОНКУРС
41:02
Қарғалардың анасы бар ма? | 1 серия | Сериал «‎QARGA 2»‎ | КОНКУРС
OMIR
Рет қаралды 1,4 МЛН
VIP ACCESS
00:47
VIP ACCESS
Natan por Aí
Рет қаралды 30 МЛН
Мен атып көрмегенмін ! | Qalam | 5 серия
25:41
Мен атып көрмегенмін ! | Qalam | 5 серия
kak budto
Рет қаралды 1,2 МЛН
Find the top 3 most frequent product combinations bought together
4:32
Find the top 3 most frequent product combinations bought together
InsightsLift
Рет қаралды 94
Calculate the moving average of sales for each product over a 7-day window
2:37
Calculate the moving average of sales for each product over a 7-day window
InsightsLift
Рет қаралды 182
SQL Interview Question CTE, WHERE , AGGREGATION Find Revenue of customers who brought Photoshop
5:23
SQL Interview Question CTE, WHERE , AGGREGATION Find Revenue of customers who brought Photoshop
Technical Surani
Рет қаралды 40
Rank stores by their monthly sales performance.
2:10
Rank stores by their monthly sales performance.
InsightsLift
Рет қаралды 54
Write a query that returns the number of unique users per client per month
4:09
Write a query that returns the number of unique users per client per month
InsightsLift
Рет қаралды 113
Output share of US users that are active. Active users are the ones with an "open" status.
2:46
Output share of US users that are active. Active users are the ones with an "open" status.
InsightsLift
Рет қаралды 42
Estimating Sherlock Holmes Book Sales in India (Part 1): A Detective-Style Market Sizing Case
9:09
Estimating Sherlock Holmes Book Sales in India (Part 1): A Detective-Style Market Sizing Case
InsightsLift
Рет қаралды 82
How Many People Ride Delhi Metro Daily? Part 1: Breaking Down a Complex Guesstimate
7:56
How Many People Ride Delhi Metro Daily? Part 1: Breaking Down a Complex Guesstimate
InsightsLift
Рет қаралды 95
黑天使只对C罗有感觉#short #angel #clown
00:39
黑天使只对C罗有感觉#short #angel #clown
Super Beauty team
Рет қаралды 36 МЛН