How to set SQL query with aggregation from several tables?

Question

SQL

Hello. Please tell me how to make a request.
Given:
- table main (id, ...);
- table first (id, id_main, ...) associated with main as many to one;
- table second (id, id_main, ...) associated with main as many to one.
It is required to receive a response of the form:
main.id, count(first.id_main), count(second.id_main).
At me both count all time are multiplied.
Thank you.

Answer 1

Use subqueries to count the number.

Answer 2

Take out counts in subqueries.