What is the total number of years active listings where Asian Cup played as a captain is Japan 1992?
CREATE TABLE table_272865_20 (years_active VARCHAR, asian_cup_played_as_a_captain VARCHAR)
SELECT COUNT(years_active) FROM table_272865_20 WHERE asian_cup_played_as_a_captain = "Japan 1992"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_272865_20 (years_active VARCHAR, asian_cup_played_as_a_captain VARCHAR) Question: What is the total number of years active listings where Asian Cup played as a captain is Japan 1992? [/INST] SELECT COUNT(years_active) FROM table_272865_20 WHERE asian_cup_played_as_a_captain = "Japan 1992" </s>