CREATE TABLE table_name_30 (weeks_on_chart__uk_ VARCHAR, entered_chart__uk_ VARCHAR)

How many weeks did the single that entered the charts 14 september 2002 stay on the charts ?
SELECT COUNT(weeks_on_chart__uk_) FROM table_name_30 WHERE entered_chart__uk_ = "14 september 2002"
SELECT COUNT("weeks_on_chart__uk_") FROM "table_name_30" WHERE "14 september 2002" = "entered_chart__uk_"