Name the guest judge for first audition date being july 9, 2009
CREATE TABLE table_22897967_1 (guest_judge VARCHAR, first_audition_date VARCHAR)
SELECT COUNT(guest_judge) FROM table_22897967_1 WHERE first_audition_date = "July 9, 2009"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_22897967_1 (guest_judge VARCHAR, first_audition_date VARCHAR) Question: Name the guest judge for first audition date being july 9, 2009 [/INST] SELECT COUNT(guest_judge) FROM table_22897967_1 WHERE first_audition_date = "July 9, 2009" </s>