2020年銷售額
SELECT SUM(base_grand_total) FROM sales_order_grid WHERE created_at>='2020-03-21 17:13:40' AND created_at<='20201231 23:59:59' AND (status='shipped' OR status='processing') ; 28696.36

2020年加州含Tax銷售額
SELECT SUM(base_grand_total) FROM sales_order_grid WHERE created_at>='2020-03-21 17:13:40' AND created_at<='20201231 23:59:59' AND (status='shipped' OR status='processing') AND billing_address LIKE '%california%' ; 4892.37

2020年非加州銷售額
SELECT SUM(base_grand_total) FROM sales_order_grid WHERE created_at>='2020-03-21 17:13:40' AND created_at<='20201231 23:59:59' AND (status='shipped' OR status='processing') AND (billing_address NOT LIKE '%california%') ; 23803.69

2020年加州Sale Tax金額
SELECT SUM(amount) FROM sales_order_grid INNER JOIN sales_order_tax ON sales_order_grid.entity_id=sales_order_tax.order_id WHERE created_at>='2020-03-21 17:13:40' AND created_at<='20201231 23:59:59' AND (status='shipped' OR status='processing') ; 424.26