Table: tridentine_calendar
Columns: date
doubles_i_class
doubles_ii_class
greater_doubles
doubles
semidoubles
total

Question: What is the lowest Greater Doubles, when Doubles, I Class is 23, and when Doubles, II Class is less than 27?
SQL: SELECT MIN("greater_doubles") FROM tridentine_calendar WHERE "doubles_i_class" = 23 AND "doubles_ii_class" < 27

Question: What is the highest Doubles, II Class, when Doubles, I Class is less than 19?
SQL: SELECT MAX("doubles_ii_class") FROM tridentine_calendar WHERE "doubles_i_class" < 19

Question: What is the lowest Semidoubles, when Doubles, II Class is 18, and when Total is less than 164?
SQL: SELECT MIN("semidoubles") FROM tridentine_calendar WHERE "doubles_ii_class" = 18 AND "total" < 164

Question: What is the lowest Date, when Doubles, II Class is 18, and when Total is less than 164?
SQL: SELECT MIN("date") FROM tridentine_calendar WHERE "doubles_ii_class" = 18 AND "total" < 164