How many weeks did the single that entered the charts 14 september 2002 stay on the charts ?
CREATE TABLE table_name_30 (weeks_on_chart__uk_ VARCHAR, entered_chart__uk_ VARCHAR)
SELECT COUNT(weeks_on_chart__uk_) FROM table_name_30 WHERE entered_chart__uk_ = "14 september 2002"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_30 (weeks_on_chart__uk_ VARCHAR, entered_chart__uk_ VARCHAR) Question: How many weeks did the single that entered the charts 14 september 2002 stay on the charts ? [/INST] SELECT COUNT(weeks_on_chart__uk_) FROM table_name_30 WHERE entered_chart__uk_ = "14 september 2002" </s>