Table: schools_info
Columns: information
dysart
shadow_ridge
valley_vista
willow_canyon

Question: What is the dysart of the principal?
SQL: SELECT "dysart" FROM schools_info WHERE "information" = 'Principal'

Question: What is williow canyon of Roberta Lockhart?
SQL: SELECT "willow_canyon" FROM schools_info WHERE "dysart" = 'Roberta Lockhart'

Question: What is the willow canyon of Stallion?
SQL: SELECT "willow_canyon" FROM schools_info WHERE "shadow_ridge" = 'Stallion'

Question: Name the Valley Vista of Anthony Capuano
SQL: SELECT "valley_vista" FROM schools_info WHERE "willow_canyon" = 'Anthony Capuano'

Question: How many informations does Michael Hawkins have?
SQL: SELECT COUNT("information") FROM schools_info WHERE "shadow_ridge" = 'Michael Hawkins'