How to create a zip code report for sales in a specific date range

(Last updated on: December 13, 2018)

• Go to Reports | Other reports | Export email.  This is what to put in for the query:

select
    sum(total_tix) as tickets, sum(total_sale) as sales, left(zip,5) as zip
from mainsale
left join customer using(customer_id)
where today_date >= "201x-xx-xx"
    and today_date <= "201x-xx-xx"
group by left(zip,5)
order by zip

• This is what it looks like:

• When the report is run and sent to a spreadsheet, the report looks like this: