What is PERCENTILE_CONT and what does it return?
Intern
354
Data Analyst
287
0
-- Find the top 5% users with the highest number of orders by name.
Intern
334
Why is LEFT JOIN used instead of other types of JOIN?
Intern
325
How to conduct A/B tests?
Intern
306
What is the 95th percentile?
Intern
134
Можно ли решить задачу проще, без PERCENTILE_CONT? Например, через ROW_NUMBER?
Intern
130
If there are duplicate orders in the data, how do you count unique orders?
Intern
126
Problem: a thousand users place one order each and leave — how is this seen in metrics and what to do?
Intern
120
Why are COUNT and GROUP BY used?
Intern
117
If the North Star metric (number of successful orders) decreases — what to do?
Intern
116
select t.* from userentry t limit 10
Intern
115
Which North Star metric should be chosen for car sharing?
Intern
106
Product case: you are a product analyst in car sharing. How do you evaluate the business and what is needed for growth? What metrics should be monitored?
Intern
102