How to write a SQL query to select from two tables by condition?

Question

SQL

Query logic: display the last name of the patient with the maximum number of entries in the Treatments table in the current year. MS Access Runtime

Answer 1

You can try this:
SELECT Person code
FROM
GROUP BY calls Person code
HAVING COUNT(1) >= ALL(SELECT COUNT(1)
FROM
GROUP BY calls Person code)