Table: bacteria_imvic
Columns: species
indole
methyl_red
voges_proskauer
citrate

Question: What is the result for salmonella spp. if you use citrate?
SQL: SELECT COUNT("citrate") FROM bacteria_imvic WHERE "species" = 'Salmonella spp.'

Question: Which species show a negative result with both voges-proskauer and indole?
SQL: SELECT "species" FROM bacteria_imvic WHERE "voges_proskauer" = 'Negative' AND "indole" = 'Negative'

Question: What are the results for testing the species with voges-proskauer when citrate yields a positive result?
SQL: SELECT "voges_proskauer" FROM bacteria_imvic WHERE "citrate" = 'Positive'

Question: What is the result of proteus mirabilis tested with indole?
SQL: SELECT "indole" FROM bacteria_imvic WHERE "species" = 'Proteus mirabilis'