เขต/พื้นที่ |
01 | 02 | 03 | 04 | 05 | 06 | 07 | 08 | 09 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | Total |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11 | 11 |
Route Table
เขต/พื้นที่ | R01 | R02 | R03 | R04 | R05 | R06 | R07 | R08 | R09 | R10 | R11 | R12 | R13 | R14 | R15 | R16 | R17 | R18 | R19 | R20 | R21 | R22 | R23 | R24 | R25 | Total |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 9 |
ร้านค้าเปิดใหม่ (แยกตามจังหวัด)
เขต/พื้นที่ | จังหวัด | จำนวน |
|---|---|---|
| กรุงเทพมหานคร | 10 | |
| นครปฐม | 1 | |
| รวม | 11 |
เขต/พื้นที่ | R01 | R02 | R03 | R04 | R05 | R06 | R07 | R08 | R09 | R10 | R11 | R12 | R13 | R14 | R15 | R16 | R17 | R18 | R19 | R20 | R21 | R22 | R23 | R24 | R25 | R | Total | SELECT cu.OKCFC1 as b,
COUNT(CASE WHEN OKCFC3 like 'R01%' THEN OKCUNO END) as 'R01',
COUNT(CASE WHEN OKCFC3 like 'R02%' THEN OKCUNO END) as 'R02',
COUNT(CASE WHEN OKCFC3 like 'R03%' THEN OKCUNO END) as 'R03',
COUNT(CASE WHEN OKCFC3 like 'R04%' THEN OKCUNO END) as 'R04',
COUNT(CASE WHEN OKCFC3 like 'R05%' THEN OKCUNO END) as 'R05',
COUNT(CASE WHEN OKCFC3 like 'R06%' THEN OKCUNO END) as 'R06',
COUNT(CASE WHEN OKCFC3 like 'R07%' THEN OKCUNO END) as 'R07',
COUNT(CASE WHEN OKCFC3 like 'R08%' THEN OKCUNO END) as 'R08',
COUNT(CASE WHEN OKCFC3 like 'R09%' THEN OKCUNO END) as 'R09',
COUNT(CASE WHEN OKCFC3 like 'R10%' THEN OKCUNO END) as 'R10',
COUNT(CASE WHEN OKCFC3 like 'R11%' THEN OKCUNO END) as 'R11',
COUNT(CASE WHEN OKCFC3 like 'R12%' THEN OKCUNO END) as 'R12',
COUNT(CASE WHEN OKCFC3 like 'R13%' THEN OKCUNO END) as 'R13',
COUNT(CASE WHEN OKCFC3 like 'R14%' THEN OKCUNO END) as 'R14',
COUNT(CASE WHEN OKCFC3 like 'R15%' THEN OKCUNO END) as 'R15',
COUNT(CASE WHEN OKCFC3 like 'R16%' THEN OKCUNO END) as 'R16',
COUNT(CASE WHEN OKCFC3 like 'R17%' THEN OKCUNO END) as 'R17',
COUNT(CASE WHEN OKCFC3 like 'R18%' THEN OKCUNO END) as 'R18',
COUNT(CASE WHEN OKCFC3 like 'R19%' THEN OKCUNO END) as 'R19',
COUNT(CASE WHEN OKCFC3 like 'R20%' THEN OKCUNO END) as 'R20',
COUNT(CASE WHEN OKCFC3 like 'R21%' THEN OKCUNO END) as 'R21',
COUNT(CASE WHEN OKCFC3 like 'R22%' THEN OKCUNO END) as 'R22',
COUNT(CASE WHEN OKCFC3 like 'R23%' THEN OKCUNO END) as 'R23',
COUNT(CASE WHEN OKCFC3 like 'R24%' THEN OKCUNO END) as 'R24',
COUNT(CASE WHEN OKCFC3 like 'R25%' THEN OKCUNO END) as 'R25',
COUNT(CASE WHEN OKCFC3='R' THEN OKCUNO END) as 'R'
FROM MVXJDTA.OCUSMA as cu
where (((cu.OKCUNO not like 'V%') and (cu.OKCUNO not like 'V0%') and (cu.OKCUNO <>'COMMISSION')) and (cu.OKCUNM not like '**%'))
and OKCUNO not like 'C%'
and OKCFC1 LIKE '%10%'
and OKCUNO not like 'R0%'
AND cu.OKSDST=''
GROUP BY cu.OKCFC1 ORDER BY OKCFC1
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| AC100 | 0 | 0 | |||||||||||||||||||||||||
| ON101 | 562 | 0 |
จำนวนร้านค้าทั้งหมด : 0 ราย