What is the main difference between window functions and aggregate functions with GROUP BY?
Middle
144
Data Analyst
296
0
Problem Solving Solve the problem and indicate the correct answer 1. Two territories are equal in area. One of them is square with a side of 90 m. The other is rectangular, with a width of 45 m. What is its length? 120 m 270 m 135 m 150 m 180 m 2. The arithmetic mean of 10, 40, and 60 is: [phone]. The train travels x kilometers in 3 minutes. How many kilometers ... [text truncated]
144
Was the task difficult, interesting, or simple for you?
144
create table table1 ( t1 int null ); insert into table1(t1) values (1),(3),(3),(4),(5),(5);
Middle
144
# input: list[str] = ["abba", "bbaa", "hello", "leohl", "llm"] # output: list[list[str]] = [["abba", "bbaa"], ["hello", "leohl"], ["llm"]]
Intern
144
What main tasks do you perform in MPStats and what stack do you work with?
Middle
144
There are three incandescent lamps in the room, outside are three switches. All are off, and you can only enter the room once. How can you determine which switch controls each lamp?
Middle
144
Propose an algorithm to determine the subscriber's birthday using only call and SMS logs: incoming and outgoing numbers, date-time, duration, and event type.
Middle
144
What is the name of the sorting operator in SQL and when is it executed? Where is LIMIT in the order of execution?
Intern
144
How do you explain to employees with traditional views the need for innovations and automation?
Junior
143
How to add a calculated field to a DataFrame based on an existing field?
Middle
143
// When updating an order, we need to send order data to several (possibly thousands) third-party services // We wrote the code, everything was fine at first, but over time our service started consuming a lot of resources func (s *orderService) SendOrder(ctx context.Context, hosts []string, order Order) { for i := 0; i < len(hosts); i++ { go func() { // Imagine this is a long network call response, err := s.httpClient.Send(ctx, hosts[i], order) if err != nil { s.logger.Error(ctx, "failed to send", err) return } s.logger.Info(ctx, "success", response) }() } }
Principal
143
What qualities do you think one should possess to demonstrate achievements?
Senior
143
What is the complexity of your anagram grouping solution?
Intern
142
Have you had experience working with B2B products in cybersecurity? What features do you see in working with such a product?
Middle+
142
Have you had experience working with Agile frameworks (Scrum, Kanban)? What is your opinion on this?
Senior
142
What are table indexes in databases used for?
Middle
142
We have ClickHouse with a DBT query that runs regularly but takes a long time. What could be the reasons and how would you approach optimization?
Senior
142
What specifically interested you about the company and this position? What strengths do you highlight in yourself and how will you be useful?
Middle
142
Task 1. Counting clients by status Requirement: Write a query that outputs the number of clients in each status (active, inactive, blocked, etc.). The result should contain two columns: status and cnt.
Intern
141