SyncShift/sql-correction-env

1+
2��i2��
�^R
IH
t
^RIHt]
!RRRRR]R7]
!R	RR3RR]R7]
!RRR
RR]R7]
!RRRRR]R7]
!RRRRR]R7]
!RRRRR]R7]
!RRRRR]R7]
!RRRRR]R7]
!RRRR R]R7]
!R!RR"R#R]R7]
!R$RR%R&R]R7]
!R'RR(R)R]R7]
!R*RR+R,R]R7]
!R-RR.R/R]R7]
!R0RR1R2R]R7.tR#)3�)
�SQLTask)
�grade�4medium_001�mediumz:SELECT name, SUM(salary) FORM employees GRUP BY departmentz;SELECT name, SUM(salary) FROM employees GROUP BY departmentN)�task_id�5difficulty�broken_query�canonical_answer�6error_hint�grader�7medium_002zNSELECT * FROM orders WHER total > 500 AND status = 'active' ORDR BY total DESCzPSELECT * FROM orders WHERE total > 500 AND status = 'active' ORDER BY total DESC�8medium_003z^SELECT department, COUNT(*) AS emp_count FORM employees GROUP BY department HAVNG COUNT(*) > 5z_SELECT department, COUNT(*) AS emp_count FROM employees GROUP BY department HAVING COUNT(*) > 5�9medium_004zPSELCT product_id, SUM(quantity) FROM sales WEHRE year = 2024 GROUP BY product_idzQSELECT product_id, SUM(quantity) FROM sales WHERE year = 2024 GROUP BY product_id�10medium_005zmSELECT e.name, d.dept_name FORM employees e INNE JOIN departments d ON e.dept_id = d.id WHER e.salary > 50000zoSELECT e.name, d.dept_name FROM employees e INNER JOIN departments d ON e.dept_id = d.id WHERE e.salary > 50000�11medium_006z^SELECT category, AVG(price) AS avg_price FORM products GRUP BY category ORDR BY avg_price DESCz`SELECT category, AVG(price) AS avg_price FROM products GROUP BY category ORDER BY avg_price DESC�12medium_007zmSELECT u.email, COUNT(o.id) AS order_count FORM users u LFT JOIN orders o ON u.id = o.user_id GRUP BY u.emailzoSELECT u.email, COUNT(o.id) AS order_count FROM users u LEFT JOIN orders o ON u.id = o.user_id GROUP BY u.email�13medium_008zRSELECT id, title FORM articles WEHRE published = 1 ORDR BY created_at DESC LIMT 10zTSELECT id, title FROM articles WHERE published = 1 ORDER BY created_at DESC LIMIT 10�14medium_009zZSELECT region, SUM(revenue) AS total FORM sales GRUP BY region HAVNG SUM(revenue) > 100000z\SELECT region, SUM(revenue) AS total FROM sales GROUP BY region HAVING SUM(revenue) > 100000�15medium_010zgSELCT p.name, s.quantity FORM products p INNE JOIN stock s ON p.id = s.product_id WEHRE s.quantity < 10ziSELECT p.name, s.quantity FROM products p INNER JOIN stock s ON p.id = s.product_id WHERE s.quantity < 10�16medium_011zcSELECT customer_id, MAX(amount) AS max_order FORM orders GRUP BY customer_id ORDR BY max_order DESCzeSELECT customer_id, MAX(amount) AS max_order FROM orders GROUP BY customer_id ORDER BY max_order DESC�17medium_012zoSELECT t.name, COUNT(e.id) AS member_count FORM teams t LFT JOIN employees e ON t.id = e.team_id GRUP BY t.namezqSELECT t.name, COUNT(e.id) AS member_count FROM teams t LEFT JOIN employees e ON t.id = e.team_id GROUP BY t.name�18medium_013z^SELCT month, SUM(sales) FORM monthly_revenue WEHRE year = 2024 GRUP BY month ORDR BY month ASCzaSELECT month, SUM(sales) FROM monthly_revenue WHERE year = 2024 GROUP BY month ORDER BY month ASC�19medium_014z�SELECT c.name, AVG(r.rating) AS avg_rating FORM courses c INNE JOIN reviews r ON c.id = r.course_id GRUP BY c.name HAVNG AVG(r.rating) >= 4.0z�SELECT c.name, AVG(r.rating) AS avg_rating FROM courses c INNER JOIN reviews r ON c.id = r.course_id GROUP BY c.name HAVING AVG(r.rating) >= 4.0�20medium_015z[SELECT DISTINCT country FORM customers WEHRE signup_date > '2023-01-01' ORDR BY country ASCz\SELECT DISTINCT country FROM customers WHERE signup_date > '2023-01-01' ORDER BY country ASC)�sql_env.modelsr�sql_env.graderr�MEDIUM_TASKS���JC:\Users\srava\Downloads\SQL corrector agent files\sql_env\tasks\medium.py�<module>r!
s�
�


�"� ����Q�V���
����e�k���
����u�z���
����g�l���
����E�K���
����u�{���
����E�K���
����i�o���
����q�w���
����~�E���
����z�A���
����G�M���
����u�|���
����e�l���
����r�w���
�cy
�r