In MySQL I'm tasked with a big dataset, with data from 1970 to 2010. 
I want to check for consistency: *check if each instance occurs minimum one time per year*. I took a snippet from 1970-1972 as example to demonstrate my problem.

input:

```
id  year    counts
--  ----    ---------
1   1970    1
1   1971    1
2   1970    3
2   1971    8
2   1972    1
3   1970    4

```

expected:

```
id  1970-1972
--  ----------
1   no
2   yes
3   no

```

I though about counting within the date range and then taking those out who had 3 counts: 1970, 1971, 1972. The following query doesn't force the check on each point in the range though. 

```
select id, count(*)
from table1
WHERE (year BETWEEN '1970' AND '1972') AND `no_counts` >= 1
group by id

```

What to do?