เราจะใส่เงื่อนไข ในการนับได้มั้ยครับ (ใน case when)

SELECT 
HOSPCODE as รหัส 
,count(case when PPSPECIAL LIKE '1B20%' then 1 else null end ) as การเคลื่อนไหว
,count(case when PPSPECIAL LIKE '1B21%' then 1 else null end) as กล้ามเนื้อและสติปัญญา
,count(case when PPSPECIAL LIKE '1B22%' or PPSPECIAL LIKE '1B23%' then 1 else null end) as เข้าใจภาษา
,count(case when PPSPECIAL LIKE '1B24%' then 1 else null end) as ช่วยเหลือตัวเองและสังคม
from (
	select p.HOSPCODE, s.PPSPECIAL 
	FROM f43_person p 
	INNER JOIN f43_specialpp s 
		on s.CID = p.CID 
		and TIMESTAMPDIFF(MONTH,p.BIRTH,s.DATE_SERV) <= 12
	WHERE s.DATE_SERV >= '20151001' 
	and p.TYPEAREA in (1,3)
	group by p.HOSPCODE, s.PPSPECIAL
) AS TMP1
group BY HOSPCODE 

select hoscode, count(cid) from (
  select hoscode , cid from
  FROM f43_person p
  where exists( select cid from f43_specialpp where cid = p.cid and DATE_SERV >= '20151001')
  group by hoscode, cid
) tmp group by hoscode

select cus_id, product_id , max(date) as maxdate from table_service  group by cus_id, product_id

select s.* from table_service s 
inner join ( 
    คิวรี่จาก 1,1
) as tmp on s.cus_id=tmp.cus_id and s.product_id=tmp.product_id and s.date=tmp.maxdate

SELECT p.home
,count(case when t.product_id = '1' then 1 else null end) as p1
,count(case when t.product_id = '2' then 1 else null end) as p2
,count(case when t.product_id = '3' then 1 else null end) as p3 
,count(case when t.product_id = '4' then 1 else null end) as p4
FROM table_person p 
inner join (
  คิวรี่จาก 1.2
) as t on p.cus_id=t.cus_id
group BY p.home