What was the total number of medals received by James Logan High School when it received less than 1 silver medal?
CREATE TABLE table_name_42 (total_medals VARCHAR, ensemble VARCHAR, silver_medals VARCHAR)
SELECT COUNT(total_medals) FROM table_name_42 WHERE ensemble = "james logan high school" AND silver_medals < 1
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_42 (total_medals VARCHAR, ensemble VARCHAR, silver_medals VARCHAR) Question: What was the total number of medals received by James Logan High School when it received less than 1 silver medal? [/INST] SELECT COUNT(total_medals) FROM table_name_42 WHERE ensemble = "james logan high school" AND silver_medals < 1 </s>