How to select with condition AND on the field of the connected 1-n table in SQL?

Question

Database

There are two tables: entity and entity properties.

Сущность:
Название | ID

Свойства:
ID сущности | свойство

How to select all entities with properties "1" and "2"?
Namely, so that both property 1 and property 2 are present in these entities.
The platform is Libre Office Base, but I'm just asking about SQL in the most general sense.

Answer 1

He himself invented such a bicycle (which later he made even shorter. See in the comment):

SELECT *
FROM "сущность"
WHERE
  (
    SELECT COUNT(*) FROM "свойства" WHERE "свойства"."ID сущности" = "сущность"."ID" AND
    (
      свойство = '1' OR
      свойство = '2'
    )
  ) = 2 --тут количество свойств на которые накладываются условия!

Seems not bad. If anyone knows better, please share.

Answer 2

WITH cte AS (
SELECT * FROM Свойства 
WHERE свойство in (1,2)
)

SELECT Название 
FROM Сущность 
WHERE ID in (
SELECT distinct c.id 
FROM cte, Сущность c 
WHERE c.id = cte.id
GROUP BY (c.id)
HAVING COUNT(c.id) > 1
)