Table: six_sigma_metrics
Columns: sigma_level
sigma_with_1_5_shift
dpmo
percent_defective
percentage_yield
short_term_c_pk
long_term_c_pk

Question: What is the percentage yield for a DPMO of 3.4?
SQL: SELECT "percentage_yield" FROM six_sigma_metrics WHERE "dpmo" = '3.4'

Question: How many percentage yield figures are there when 6.7% are defective?
SQL: SELECT COUNT("percentage_yield") FROM six_sigma_metrics WHERE "percent_defective" = '6.7%'

Question: What is long-term C PK when the short-term C PK is 2.00?
SQL: SELECT "long_term_c_pk" FROM six_sigma_metrics WHERE "short_term_c_pk" = '2.00'

Question: What is the sigma (with 1.5σ shift) when there are 69% defective?
SQL: SELECT "sigma_with_1_5_shift" FROM six_sigma_metrics WHERE "percent_defective" = '69%'

Question: When sigma (with 1.5σ shift) is 2.5, what percent is defective?
SQL: SELECT "percent_defective" FROM six_sigma_metrics WHERE "sigma_with_1_5_shift" = '2.5'