The following SQL statement will compile and produce the a l…
The following SQL statement will compile and produce the a list of cleaning counts by building. Select bldgnum, HKID, count(*) as ‘Cleaning Count’from CLEANINGWhere bldgnum = ‘A’ and HKID like ‘A%’Group by bldgnumHaving count(*) > 5
Read Details