user: ### NOW ANSWER:
Question: How many appearances did the player for the rayo vallecano club that scored more than 37 goals make?
Columns: ['Name', 'Nationality', 'Position', 'Year of birth', 'Career', 'Appearances', 'Goals', 'Club']
Types: ['text', 'text', 'text', 'real', 'text', 'real', 'real', 'text']
Sample row: ['Quique Álvarez Category:Articles with hCards', 'Spain', 'Defender', 1975.0, '1995–2009', 200.0, 5.0, 'Villareal']
SQL:

assistant: SELECT COUNT("Appearances") FROM "Table" WHERE "Club" = 'rayo vallecano' AND "Goals" > 37.0;