How to select records that have 2 or more related records in another table?

Question

SQL

How to select records that have 2 or more related records in another table?
for such a scheme:

That is, if there are 2 directions or more by id_history, then choose.
Step 2 - then from these two selected, choose the one with the smallest id;

Answer 1

I'm scared to go to the clinic now.
Would you at least suggest some table names for clarity, so as not to compose A and B.

SELECT rr.* 
FROM (
  SELECT MIN(r.id) AS id
  FROM recept r
  JOIN history h ON r.id_history = h.id
  GROUP BY r.id_history
  HAVING COUNT(r.id) >= 2
) ids
JOIN recept rr ON rr.id = ids.id

Answer 2

In principle, it is enough to translate the text of the description into English, remove the parasitic words and get an sql query