WHAT IS TOTAL NUMBER OF PR TOP-UPS THAT HAVE A PERCENTAGE OF 0.8%, TOTAL LARGER THAN 1?
CREATE TABLE table_name_92 (pr_top_up VARCHAR, percentage VARCHAR, total VARCHAR)
SELECT COUNT(pr_top_up) FROM table_name_92 WHERE percentage = "0.8%" AND total > 1
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_92 (pr_top_up VARCHAR, percentage VARCHAR, total VARCHAR) Question: WHAT IS TOTAL NUMBER OF PR TOP-UPS THAT HAVE A PERCENTAGE OF 0.8%, TOTAL LARGER THAN 1? [/INST] SELECT COUNT(pr_top_up) FROM table_name_92 WHERE percentage = "0.8%" AND total > 1 </s>