Kalletlamadhav/sql-optimization-env
0
1�
2 F��i � � � d dl mZ d dlmZ ed� � Ze� � � re� � � ndZ eddddd ged3d d d
��4 �5 ZdS )� )�Path)�BaseTaskzdata/schemas/pds_schema.sqlaZ CREATE TABLE ration_card_beneficiaries (card_id TEXT PRIMARY KEY, household_head TEXT NOT NULL, state_code CHAR(2) NOT NULL, district_code CHAR(3) NOT NULL, block_code CHAR(5), village_code CHAR(7), card_type TEXT NOT NULL, members_count INTEGER DEFAULT 1, aadhar_linked INTEGER DEFAULT 0, mobile_number TEXT, created_at DATE, last_updated DATE);�pds_select_starz�A state government officer wants a count of BPL card holders by district. The query fetches all columns from 80,000 rows but only needs card_id and district_code. Rewrite it to select only required columns and add appropriate filter.zU6 SELECT * FROM ration_card_beneficiaries7 WHERE card_type = 'BPL'8 � SELECT_STAR�ration_card_beneficiaries�easy� zISELECT * fetches all 12 columns. You only need card_id and district_code.zr9 SELECT card_id, district_code10 FROM ration_card_beneficiaries11 WHERE card_type = 'BPL'12 )13�task_id�goal�14slow_query�expected_pattern�tables�15schema_ddl�16difficulty�curriculum_level�hint�
reference_fixN) �pathlibr �tasks.base_taskr � _schema_file�exists� read_text� _schema_ddl�TASK� � �FC:\open_env_sql_opt\sql-optimization-env\tasks\easy\pds_select_star.py�<module>r s� �� � � � � � � $� $� $� $� $� $� �t�1�2�2� �*6�*=�*=�*?�*?� �l�$�$�&�&�&�+� � �x� � Q�� #� '� (���� T��#� � ���r