**SQL tasks** 1) Count the number of orders with status "processing" for each executor in March 2024 ONLY for high-priority orders. 2) Find the average revenue for each product category. 3) Determine how many unique clients made orders in the "Electronics" category. 4) List orders that were rejected or canceled, if any. 5) Find the executor who processed the most orders with status "completed".
20. Valid Parentheses Given a string s containing just the characters '(', ')', '{', '}', '[' and ']', determine if the input string is valid. An input string is valid if: 1. Open brackets must be closed by the same type of brackets. 2. Open brackets must be closed in the correct order. 3. Every close bracket has a corresponding open bracket of the same type. Example 1: Input: s = "()" Output: true Example 2: Input: s = "()[]{}" Output: true Example 3: Input: s = "(]" Output: false
**SQL tasks** 1) Display the number of orders with status "processing" for each executor in March 2024, ONLY for high-priority orders (priority = 'high'). Sort by descending order count. Exclude executors with 0 orders. 2) Show the number of successfully completed orders by categories, where the average revenue is > 70000, considering only customer orders with ID >= 1002. Exclude categories with unknown average revenue. 3) Add a column 'rank' to the orders_log table, ranking records for each executor by timestamp in ascending order, but only for orders with status "pending" or "processing". Example result (executor=1):
Why did you choose swipe mechanics for searching tenders?
How does request grouping work and why is it a complex task?
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?
How are you with Python and SQL?
Are you isolated as an analyst or part of a product team?
How would you approach expanding the system to a new type of requests — for example, from FAS instead of FNS?
How can a large prompt be shortened? What to do with a huge context?
Tell us about the most vivid case at your current job.
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?
Why can't the average be used to calculate discounts in skewed LTV distribution?
How many hours per week are you willing to work?
Why did you do the test assignment this way? Why is it structured like that?
How does the AI pipeline for assigning performers to residents' requests work? Critique the architecture.
How to retrieve all prime numbers from a set of numbers from 0 to 1000 using SQL?
How do you debug a slow-running SQL query?
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?
/* Task 2 In a social network, users have access to the following achievements: 1. "Star of the School" is awarded to the student with the highest number of friends. 2. "Hachiko" is awarded to the student who sent the highest number of friend requests, but none of the students confirmed the friendship. Output the ids of the students who received the achievement, as well as the name of their achievement. */
