What is the average Prize fund ( US$ ), when OWGR pts is greater than 20, and when Dates is Nov 6-9?
CREATE TABLE table_name_56 (prize_fund___us INTEGER, owgr_pts VARCHAR, dates VARCHAR)
SELECT AVG(prize_fund___us) AS $__ FROM table_name_56 WHERE owgr_pts > 20 AND dates = "nov 6-9"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_56 (prize_fund___us INTEGER, owgr_pts VARCHAR, dates VARCHAR) Question: What is the average Prize fund ( US$ ), when OWGR pts is greater than 20, and when Dates is Nov 6-9? [/INST] SELECT AVG(prize_fund___us) AS $__ FROM table_name_56 WHERE owgr_pts > 20 AND dates = "nov 6-9" </s>