You are a sql query generator where you have a database whose column names with its data types are :competition_name VARCHAR,season int,match_id INT,id INT,NAME_1_id INT,ball_number int,ball_runs int,batsman_id INT,batsman_team_id int,batting_phase int, batting_position int,bowl_length varchar,bowl_line varchar,bowl_type varchar,NAME_1_team_id int ,extras int,fielder_angle float, fielder_length_ratio float,innings int,is_beaten int,is_NAME_1_wicket int,is_bye int,is_dot_ball int,is_extra int,is_four int,is_leg_bye int,is_maiden int, is_no_ball int,is_one int,is_six int,is_three int,is_two int,is_uncomfortable int,is_wicket int,is_wide int, non_striker_id int,out_batsman_id int, over_number int,over_text float,runs int,shot_type varchar, wicket_type varchar,x_pitch float,y_pitch float, match_date varchar,winning_team int,is_playoff int, is_title int,target_runs int,venue_id varchar,stadium_name varchar,batsman varchar,striker_batting_type varchar,striker_type varchar, non_striker varchar, non_striker_batting_type varchar,non_striker_type varchar, NAME_1 varchar,NAME_1_sub_type varchar,bowl_major_type varchar,NAME_1_type varchar,out_batsman varchar, batting_team varchar,team_short_name_x varchar,bowling_team varchar,team_short_name_y varchar, match_phase varchar where PRIMARY KEY is id.
The enteries are like: IPL,2010,467,107042,979,1,0,771,21,1.0,1,Good Length,Outside Leg Stump,INSWINGER,16,0,0.0,0.0,1,0.0,1,0,1,0,0,0,1.0,0,0,0,0,0,0.0,1,0, 783,771,1,0.1,0,FLICK,Caught,68.0,104.0, 12 Mar 2010,21.0,0,0.0,,46,DR.DY.PATEL SPORTS ACADEMY,NAME_2,RIGHT HAND BATSMAN,Domestic,NAME_3,RIGHT HAND BATSMAN,Overseas,Chaminda Vaas,LEFT ARM FAST,SEAM,Overseas,NAME_2,3c1550c07f7f44db,Kolkata Knight Riders,KKR,Deccan Chargers,DCH,POWERPLAY 
The table name is df.
Competition name can take values: IPL,CPL,BBL,SA20,BPL,CSAT20,LPL,MSL,PSL,SMA,SUPER_SMASH,T20_INT.
Season can take values between 2010 to 2023.
Bowl_length can take values: Good Length,Short Length,Full Toss,Full Length,Yorker,Bouncerl
Bowl_line can take values: Outside Leg Stump,Outside NAME_4,Middle Stump,Wide Outside NAME_4,NAME_4,Leg Stump,Wide Outside Leg Stump.
Bowl_type can take values: BOUNCER,OFF SPIN,SLOWER BALL,YORKER,LEG SPIN,FASTER ONE,GOOGLY,ARM BALL,REVERSE SWING,DOOSRA,FLIPPER,INCUTTER,SLOW BOUNCER,NIPBACKER,LEGCUTTER,CHINAMAN,ORTHODOX,OFF CUTTER,STRAIGHTER ONE,ANGLED IN,ANGLED ACROSS,CARROM BALL,WRONG ONE,NIPPED AWAY,REVERSESWING YORKER,INSWINGING YORKER,STRAIGHT BALL,NO TURN,BACKHAND SLOWER,SLOW YORKER,BEAMER,TOP SPINNER,SHORT BALL,F Provide your response in exactly 2 paragraphs (separated nearby paragraphs with 3 aterisk symbols ***).
user