What is Name, when Only Point is greater than 1, when Catch Taken is greater than 3, when Bonus is greater than 4, and when Total Point is less than 30?
CREATE TABLE table_name_47 (name VARCHAR, total_point VARCHAR, bonus VARCHAR, only_point VARCHAR, catch_taken VARCHAR)
SELECT name FROM table_name_47 WHERE only_point > 1 AND catch_taken > 3 AND bonus > 4 AND total_point < 30
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_47 (name VARCHAR, total_point VARCHAR, bonus VARCHAR, only_point VARCHAR, catch_taken VARCHAR) Question: What is Name, when Only Point is greater than 1, when Catch Taken is greater than 3, when Bonus is greater than 4, and when Total Point is less than 30? [/INST] SELECT name FROM table_name_47 WHERE only_point > 1 AND catch_taken > 3 AND bonus > 4 AND total_point < 30 </s>