SELECT cusarea,COUNT(CASE WHEN cusopen like '01%' THEN cuscode END) as '01',COUNT(CASE WHEN cusopen like '02%' THEN cuscode END) as '02',COUNT(CASE WHEN cusopen like '03%' THEN cuscode END) as '03',COUNT(CASE WHEN cusopen like '04%' THEN cuscode END) as '04',COUNT(CASE WHEN cusopen like '05%' THEN cuscode END) as '05',COUNT(CASE WHEN cusopen like '06%' THEN cuscode END) as '06',COUNT(CASE WHEN cusopen like '07%' THEN cuscode END) as '07',COUNT(CASE WHEN cusopen like '08%' THEN cuscode END) as '08',COUNT(CASE WHEN cusopen like '09%' THEN cuscode END) as '09',COUNT(CASE WHEN cusopen like '10%' THEN cuscode END) as '10',COUNT(CASE WHEN cusopen like '11%' THEN cuscode END) as '11',COUNT(CASE WHEN cusopen like '12%' THEN cuscode END) as '12',COUNT(CASE WHEN cusopen like '13%' THEN cuscode END) as '13',COUNT(CASE WHEN cusopen like '14%' THEN cuscode END) as '14',COUNT(CASE WHEN cusopen like '15%' THEN cuscode END) as '15',COUNT(CASE WHEN cusopen like '16%' THEN cuscode END) as '16',COUNT(CASE WHEN cusopen like '17%' THEN cuscode END) as '17',COUNT(CASE WHEN cusopen like '18%' THEN cuscode END) as '18',COUNT(CASE WHEN cusopen like '19%' THEN cuscode END) as '19',COUNT(CASE WHEN cusopen like '20%' THEN cuscode END) as '20',COUNT(CASE WHEN cusopen like '21%' THEN cuscode END) as '21',COUNT(CASE WHEN cusopen like '22%' THEN cuscode END) as '22',COUNT(CASE WHEN cusopen like '23%' THEN cuscode END) as '23',COUNT(CASE WHEN cusopen like '24%' THEN cuscode END) as '24',COUNT(CASE WHEN cusopen like '25%' THEN cuscode END) as '25',COUNT(CASE WHEN cusopen like '26%' THEN cuscode END) as '26',COUNT(CASE WHEN cusopen like '27%' THEN cuscode END) as '27',COUNT(CASE WHEN cusopen like '28%' THEN cuscode END) as '28',COUNT(CASE WHEN cusopen like '29%' THEN cuscode END) as '29',COUNT(CASE WHEN cusopen like '30%' THEN cuscode END) as '30',COUNT(CASE WHEN cusopen like '31%' THEN cuscode END) as '31'
FROM cust_new_credit
WHERE (cusopen like '%')
AND cuszone=''
GROUP BY cusareaจำนวนร้านค้าเครดิตที่เปิดในเดือน (แยกตามวันที่เปิด)
เขต/พื้นที่ |
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 |
ร้านค้าเปิดใหม่ (แยกตามจังหวัด)
เขต/พื้นที่ | จังหวัด | จำนวน |
|---|
| | นครปฐม | 1 |
| | กรุงเทพมหานคร | 10 |
| รวม | | 11 |
จำนวนร้านค้าที่มีทั้งหมดในปัจจุบัน Credit (แยกตาม Route)เขต/พื้นที่ | 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 |
|---|
| | | | | | | | | | | | | | | | | | | | | | | | | | 13 | 3 | 13 |
| AC100 | | | | | | | | | | | | | | | | | | | | | | | | | | 0 | 0 |
จำนวนร้านค้าทั้งหมด : 13 ราย