Table: m1_bazooka
Columns: name_designation
year_of_intro
country_of_origin
primary_cartridge
type

Question: What is Country of Origin, when Type is Disposable, when Primary Cartridge is 105mm, and when Year of Intro is less than 2008?
SQL: SELECT "country_of_origin" FROM m1_bazooka WHERE "type" = 'disposable' AND "primary_cartridge" = '105mm' AND "year_of_intro" < 2008

Question: What is Country of Origin, when Year of Intro is 1977?
SQL: SELECT "country_of_origin" FROM m1_bazooka WHERE "year_of_intro" = 1977

Question: What is Country of Origin, when Year of Intro is greater than 1985, and when Primary Cartridge is 125mm?
SQL: SELECT "country_of_origin" FROM m1_bazooka WHERE "year_of_intro" > 1985 AND "primary_cartridge" = '125mm'

Question: What is the total number of Year of Intro(s), when Country of Origin is Soviet Union, when Type is Reusable, when Primary Cartridge is 40mm, and when Name/ Designation is RPG-29?
SQL: SELECT COUNT("year_of_intro") FROM m1_bazooka WHERE "country_of_origin" = 'soviet union' AND "type" = 'reusable' AND "primary_cartridge" = '40mm' AND "name_designation" = 'rpg-29'