How to count the number of elements?

Question

MySQL

Hi friends!
I can't figure out how to calculate.
It is necessary to make a selection from the test table sorted by date and with a limit of 10 records
And then from these 10 records count how many of them in the ff_id field is equal to 2
How will such a query look correctly?

Answer 1

SELECT COUNT(*) FROM (
   SELECT ff_id FROM test ORDER BY date_added LIMIT 10 
) test_outer
WHERE ff_id=2

именование результирующей таблицы обязательно.