Table: tsop_package_specs
Columns: part_number
pins
body_width_mm
body_length_mm
lead_pitch_mm

Question: Which Body Width/mm has a Lead Pitch/mm smaller than 0.55, and a Body Length/mm larger than 18.4?
SQL: SELECT MIN("body_width_mm") FROM tsop_package_specs WHERE "lead_pitch_mm" < 0.55 AND "body_length_mm" > 18.4

Question: Which Body Length/mm has a Lead Pitch/mm smaller than 0.5?
SQL: SELECT AVG("body_length_mm") FROM tsop_package_specs WHERE "lead_pitch_mm" < 0.5

Question: How much Body Width/mm has a Body Length/mm of 18.4, and Pins of 40?
SQL: SELECT COUNT("body_width_mm") FROM tsop_package_specs WHERE "body_length_mm" = 18.4 AND "pins" = '40'

Question: Which Body Width/mm has a Lead Pitch/mm smaller than 0.55, and a Part Number of tsop48?
SQL: SELECT MIN("body_width_mm") FROM tsop_package_specs WHERE "lead_pitch_mm" < 0.55 AND "part_number" = 'tsop48'

Question: Which Lead Pitch/mm has a Part Number of tsop40, and a Body Length/mm larger than 18.4?
SQL: SELECT MAX("lead_pitch_mm") FROM tsop_package_specs WHERE "part_number" = 'tsop40' AND "body_length_mm" > 18.4