Table: ar_15_variants
Columns: colt_model_no
name
stock
fire_control
rear_sight
forward_assist
barrel_length
barrel_profile
barrel_twist
hand_guards
bayonet_lug
muzzle_device

Question: What is the muzzle device on the colt model le1020?
SQL: SELECT "muzzle_device" FROM ar_15_variants WHERE "colt_model_no" = 'LE1020'

Question: What is the barrell profile that goes with the gas piston carbine?
SQL: SELECT "barrel_profile" FROM ar_15_variants WHERE "name" = 'Gas Piston Carbine'

Question: What models have an a2 barrel profile?
SQL: SELECT "name" FROM ar_15_variants WHERE "barrel_profile" = 'A2'

Question: What hand guard system is used with a gas piston commando?
SQL: SELECT "hand_guards" FROM ar_15_variants WHERE "name" = 'Gas Piston Commando'

Question: What is the bayonet lug status for a m4 hbar and m4le carbine equipped?
SQL: SELECT "bayonet_lug" FROM ar_15_variants WHERE "barrel_profile" = 'M4 HBAR' AND "name" = 'M4LE Carbine'

Question: What is the barrel length for a cold model le6921sp?
SQL: SELECT "barrel_length" FROM ar_15_variants WHERE "colt_model_no" = 'LE6921SP'