CodeCharge TAIWAN

select sum(invoice_tax+invoice_net) from stick_data where date >= '2005-01-01' and date <= '2005-12-31' and memo <> '作廢' and stick_id regexp '[A-Z][A-Z][0-9]{8}';