Table: imvic_test
Columns: species
indole
methyl_red
voges_proskauer
citrate

Question: Which species has a Voges-Proskauer reading of negative and an indole reading of negative?
SQL: SELECT "species" FROM imvic_test WHERE "voges_proskauer" = 'negative' AND "indole" = 'negative'

Question: What is the Voges-Proskauer reading for proteus mirabilis?
SQL: SELECT "voges_proskauer" FROM imvic_test WHERE "species" = 'proteus mirabilis'

Question: What is the methyl red reading for the species that tests positive for indole?
SQL: SELECT "methyl_red" FROM imvic_test WHERE "indole" = 'positive'

Question: What is the methyl red reading for proteus mirabilis?
SQL: SELECT "methyl_red" FROM imvic_test WHERE "species" = 'proteus mirabilis'