SQLで「範囲」を設定するのに利用
例 日別で、salesの範囲を分ける
select ymd, shohin_id, sales , case when sales > 0 and sales <= 1000 then 1000 when sales > 1000 and sales <= 10000 then 10000 when sales > 10000 and sales <= 100000 then 100000 else '99999999' end as salse_dist from sales_tbl;
![範囲を追加](https://apl-py.com/blog/wp-content/uploads/2015/10/8e8c816071c58256636e18bc0d451f68.png)