Intern
**SQL tasks** 1) Highlight the number of orders with status "processing" for each executor for March 2024 ONLY for high priority orders (priority = 'high').
sobes.tech AI
Answer from AI
sql SELECT executor, COUNT(*) AS orders_count FROM orders WHERE status = 'processing' AND priority = 'high' AND order_date >= '2024-03-01' AND order_date < '2024-04-01' GROUP BY executor;
In this query, we filter orders by status "processing", priority "high", and date in March 2024, then group by executor and count the number of orders for each.