Table: victoria_crosses_schools
Columns: school
location
total
crimean_war
persian_war
indian_mutiny
1860_1878
zulu_war
second_afghan_war

Question: How many Persian Wars have a School of rashtriya indian military college, and an 1860-1878 smaller than 0?
SQL: SELECT COUNT("persian_war") FROM victoria_crosses_schools WHERE "school" = 'rashtriya indian military college' AND "1860_1878" < 0

Question: What is the largest Persian War with a Crimean War of 0, an 1860-1878 larger than 0, a Location of united kingdom, and a Zulu War smaller than 1?
SQL: SELECT MAX("persian_war") FROM victoria_crosses_schools WHERE "crimean_war" = 0 AND "1860_1878" > 0 AND "location" = 'united kingdom' AND "zulu_war" < 1

Question: What is the average Crimean War with a Second Afghan War totaling 1, and a School of hamblin and porter's school, cork?
SQL: SELECT AVG("crimean_war") FROM victoria_crosses_schools WHERE "second_afghan_war" = '1' AND "school" = 'hamblin and porter''s school, cork'

Question: Which Crimean War has a 1860-1878 of 0, a Total of 1, and an Indian Mutiny larger than 0?
SQL: SELECT "crimean_war" FROM victoria_crosses_schools WHERE "1860_1878" = 0 AND "total" = 1 AND "indian_mutiny" > 0

Question: Which school has an 1860-1878 larger than 0, and a Second Afghan War of 0?
SQL: SELECT "school" FROM victoria_crosses_schools WHERE "1860_1878" > 0 AND "second_afghan_war" = '0'