How many gold medals has the club with the most coaches won?
CREATE TABLE match_result (
    club_id VARCHAR,
    gold VARCHAR
)

CREATE TABLE coach (
    club_id VARCHAR
)
SELECT T1.club_id, T1.gold FROM match_result AS T1 JOIN coach AS T2 ON T1.club_id = T2.club_id GROUP BY T1.club_id ORDER BY COUNT(*) DESC LIMIT 1
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: How many gold medals has the club with the most coaches won? ### Input: CREATE TABLE match_result (
    club_id VARCHAR,
    gold VARCHAR
)

CREATE TABLE coach (
    club_id VARCHAR
) ### Response: SELECT T1.club_id, T1.gold FROM match_result AS T1 JOIN coach AS T2 ON T1.club_id = T2.club_id GROUP BY T1.club_id ORDER BY COUNT(*) DESC LIMIT 1