Table: capital_artists
Columns: english_name
chinese_name
year_signed
year_separated
reason_for_separation

Question: What is the most current year signed for separation of † and a separation year of 1997?
SQL: SELECT MAX("year_signed") FROM capital_artists WHERE "reason_for_separation" = '†' AND "year_separated" = '1997'

Question: What is the Chinese name for the English name Andy Lau?
SQL: SELECT "chinese_name" FROM capital_artists WHERE "english_name" = 'andy lau'

Question: What year was Wilfred Lau separated because Capital stopped recording music?
SQL: SELECT "year_separated" FROM capital_artists WHERE "reason_for_separation" = 'capital stopped recording music' AND "english_name" = 'wilfred lau'

Question: What is the English name for the Chinese name of 蘇永康 later than 1974?
SQL: SELECT "english_name" FROM capital_artists WHERE "year_signed" > 1974 AND "chinese_name" = '蘇永康'

Question: What was the signed year for the Chinese name 蘇永康 who separated in 1987?
SQL: SELECT "year_signed" FROM capital_artists WHERE "year_separated" = '1987' AND "chinese_name" = '蘇永康'