waist_3034

```sql
#SET @prov_c := '14';
SET @b_year:='2017';
SET @start_d:=concat(@b_year-1,'1001');
SET @end_d:=concat(@b_year,'0930');
#SET @date_3:=concat(@b_year-14,'1001');

select
#if(p.SEX=1,if(n.WAIST_CM<=90,concat(p.HOSPCODE,'-',p.PID),null),if(p.SEX=2,if(n.WAIST_CM<=80,concat(p.HOSPCODE,'-',p.PID),null),null))
COUNT(DISTINCT if(p.SEX=1,if(n.WAIST_CM<=90,concat(p.HOSPCODE,'-',p.PID),null),if(p.SEX=2,if(n.WAIST_CM<=80,concat(p.HOSPCODE,'-',p.PID),null),null))) as A,
COUNT(DISTINCT CONCAT(n.HOSPCODE,'-',n.PID)) as B
from ncdscreen n
inner join person p on p.HOSPCODE=n.HOSPCODE and p.PID=n.PID
where DATE_SERV BETWEEN @start_d AND @end_d
and TIMESTAMPDIFF(YEAR,p.BIRTH,n.DATE_SERV) BETWEEN 30 and 44
and n.WAIST_CM BETWEEN 10 and 500

Review the SQL snippet in issue #15, including the ncdscreen and person tables, the date variables, and the waist and age filters. The issue does not state what should be changed or provide an acceptance criterion, so the intended result must be clarified before implementation.

Written by the indexing model from the issue text.