How to write such a query in SQL?

Question

SQL

How to correctly display data from a range (10:15)

Answer 1

select n.NaklID
from Nakl n
join Nakllines nl on n.NaklID = nl.NaklID
where nl.Article in (10, 15)
  and n.Data > '2021-07-20'
group by n.NaklID
having count(distinct nl.Article) = 2