Who is Charleston Southerns head coach where the result is L, 56-6?-
CREATE TABLE table_26240481_1 (charleston_southerns_head_coach VARCHAR, result VARCHAR)
SELECT charleston_southerns_head_coach FROM table_26240481_1 WHERE result = "L, 56-6"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_26240481_1 (charleston_southerns_head_coach VARCHAR, result VARCHAR) Question: Who is Charleston Southerns head coach where the result is L, 56-6?- [/INST] SELECT charleston_southerns_head_coach FROM table_26240481_1 WHERE result = "L, 56-6" </s>