Table: machine_taper_0
Columns: morse_taper_number
taper
b_max
c_max
d_max

Question: What is the B (max) average when the C (max) is greater than 156, the taper is 1:19.231, and the D (max) is less than 34.9?
SQL: SELECT AVG("b_max") FROM machine_taper_0 WHERE "c_max" > 156 AND "taper" = '1:19.231' AND "d_max" < 34.9

Question: With a Morse Taper number less than 3 and a C (max) of 59.5 what is the total of D (max)?
SQL: SELECT COUNT("d_max") FROM machine_taper_0 WHERE "morse_taper_number" < 3 AND "c_max" = 59.5

Question: What's the total of the Morse Taper number when the D (max) is 20 and the B (max) greater than 94?
SQL: SELECT SUM("morse_taper_number") FROM machine_taper_0 WHERE "d_max" = 20 AND "b_max" > 94

Question: What total D (max) has a taper of 1:20.047, and a C (max) bigger than 65.5?
SQL: SELECT SUM("d_max") FROM machine_taper_0 WHERE "taper" = '1:20.047' AND "c_max" > 65.5

Question: What is the minimum D (max) when the Morse Taper number is less than 0?
SQL: SELECT MIN("d_max") FROM machine_taper_0 WHERE "morse_taper_number" < 0