What is the purpose of HAVING and why not WHERE?
Senior
175
Golang
8397
379
On the stack: what databases, message brokers do you use?
Senior
173
Tell me about the team: who did you interact with, how many people were there?
Middle+
173
Tell me what the code will output? What do you think about this code? // Check if project exists existingID, err := i.projectRepo.GetIDByJiraID(ctx, postgresConn, issue.ID) if err != nil { return 0, fmt.Errorf("failed to check project existence: %w", issue.ID) }
Senior
171
1. Output the TOP 10 by total orders of users who made more than 2 orders in the last 30 days 2. Output the TOP 3 categories by revenue in the last 6 months.
Middle+
171
How many years of cumulative Go development experience do you have?
Middle+
170
HeadHunter has a limit of 16,000 resume views per day, and one broad filter consumes everything — how to solve it?
Senior
170
What are the transaction isolation levels, anomalies, and what does Serializable mean?
Middle
170
In your opinion, why use containers when virtualization exists?
Senior
170
What was the direction of your team?
Middle+
169
How does DISTINCT work?
Senior
168
Write a function that removes all elements equal to val from a slice in-place. Returns a slice without the removed values. func RemoveValue(slice []int, val int) []int { // your code } // Example RemoveValue([]int{1,2,3,2,4}, 2) // -> []int{1,3,4} RemoveValue([]int{1,2,3}, 5) // -> []int{1,2,3} RemoveValue([]int{}, 1) // -> []int{}
Middle+
167
How was it possible to achieve an acceleration of the API for uploading medical files by more than 3 times?
Middle+
167
Tell me, what is calibration and where is this word used?
Middle+
167
Did you write tests? Which ones?
Middle+
167
Write an SQL query that returns the number of orders for each user with a total price greater than or equal to 1000, sorted by the number of orders in descending order, in the following format: +---------+-------------+ | user_id | order_count | +---------+-------------+ | 111 | 2 | | 222 | 1 | | 333 | 1 | +---------+-------------+
Senior
166
What types of JOINs do you know and what are their differences?
Senior
165
Tell me more about your recent projects: technologies, your responsibilities, main tasks.
Middle
165
How are collisions resolved in Go (up to version 1.24) in maps? Tell me about buckets and overflow buckets.
Middle+
165
What tasks are you most proud of and remember?
Senior
165