Tell me about your work experience and projects
Intern
312
Product Analyst
129
0
How do you see your future career path? Why did you respond to our vacancy and why do you want to leave your current position?
Middle+
308
What quality metrics were used in the medical startup? Why those specific thresholds?
Intern
306
How to solve the task of filling in gaps in a brute-force way without ready-made functions in SQL?
Middle
296
**SQL tasks** 1) Highlight the number of orders with status "processing" for each executor for March 2024 ONLY for high priority orders (priority = 'high').
Intern
294
What features does a many-to-many relationship have?
Middle
290
What are window functions in SQL and how do they differ from GROUP BY?
Intern
287
Task 1 Display the ids of all students who sent friend requests to those studying 2 grades lower. Task 2 In the social network, users have the following achievements: 1. "School Star" awarded to the student with the highest number of friends. 2. "Hachiko" awarded to the student who sent the most friend requests, but no one confirmed the friendship. Display the ids of students who received achievements and the name of their achievement.
Intern
284
Why did you leave the sales manager position at [company]?
Intern
282
Task 4 List all companies that have no transactions in the last 30 days. Use JOIN (without subquery in WHERE).
Intern
281
Tell me how you understood this module (recovery strategies). What is a strategy, a step, a selection condition?
Middle+
278
Regarding payment — do you currently have more or less, and how comfortable are the proposed conditions?
Middle
276
What is distribution and why is it needed for an analyst?
Intern
268
There is a normal distribution with a mean of 5 and a variance of 9. What are the mode and median?
Intern
268
How did you address issues related to certification and processing of medical data (152-FZ) in a medical startup?
Intern
261
**Python tasks** A Pandas DataFrame with data from orders_log is called df. 1) Filter the rows: status "processing" AND revenue > 50000 AND priority "high". Display the result. 2) Create a column 'revenue_group' according to the rules: ‘Small’ (< 50000), ‘Medium’ (50000 <= revenue < 90000), ‘Large’ (>= 90000). Then count the number of orders in each group by categories (Category) and display the result. 1) df[(df["state"] == "processing") & (df["revenue"] > 50000) & (df["priority"] == "high")] 2)
Intern
257
Why do you have no questions for the interviewers?
Middle+
255
Have you had experience with product development and direct interaction with developers?
Middle+
255
What types of relationships between tables exist in SQL?
Middle
253
Where will the median and mean be located in a right-skewed distribution?
Intern
253