What types of relationships between tables exist in SQL?
Middle
393
Product Analyst
137
0
Where will the median and mean be located in a right-skewed distribution?
Intern
391
Tell me about your work experience and projects
Intern
389
If the significance level α is set, with a probability of Type I error equal to 1, what will happen?
Junior
368
Case: Cybersecurity wants to ban screen sharing in the Alpha segment due to the risk of K1/K2 leakage through guests during open meetings. What would you do?
Middle+
367
**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
365
How can a large prompt be shortened? What to do with a huge context?
Middle+
362
How do you feel about teamwork? Are you more of a solo performer or a team player?
Middle
360
Are you isolated as an analyst or part of a product team?
Middle+
355
Case: a business comes to you with a big task, you don't have time to detail everything, but the developer wants to start. You need to deliver a document in an hour. What will you write and in what format?
Middle+
354
Have you had experience with product development and direct interaction with developers?
Middle+
352
How does request grouping work and why is it a complex task?
Middle+
341
Why can't the average be used to calculate discounts in skewed LTV distribution?
Intern
331
Case: cybersecurity employees do not want to miss a feature because the functionality is not equipped with metrics and it is impossible to find the culprit in an incident. What will you do?
Middle+
328
What window functions have you used most often? How does RANK differ from DENSE_RANK?
Intern
324
Tell me more about the team project: who participated in the team, what was your area of responsibility, and how was communication organized within the team?
Intern
323
How would you approach expanding the system to a new type of requests — for example, from FAS instead of FNS?
Middle
322
Table with 1 column: id --- 1 2 3 4 5 NULL NULL 1) What will the function return in a query like: -- SELECT ... FROM table count(*) = count(1) = count(id) = count("id") = count(NULL) = 2) min(id) = max(id) = sum(id) = avg(id) =
Junior
320
Why are you interested in this position?
Middle
316
How to handle currency exchange rate gaps during holidays and weekends?
Middle
316