Company  		Q1 (Jan-Mar)  		Q2 (Apr-Jun)  		Q3 (Jul-Sep)  		Q4 (Oct-Dec)  	Total #  Total $
Intuit Canada 		29 	$2,682.85 	41 	$2,722.70 	27 	$1,542.00 	0 	$0.00 	97 	$6,947.55
City of St. Albert 	18 	$2,468.10 	19 	$2,108.00 	12 	$1,084.00 	1 	$82.50 	50 	$5,742.60
Alberta Blue Cross 	0 	$0.00 		0 	$0.00 		24 	$3,326.65 	0 	$0.00 	24 	$3,326.65
No Company Specified 	2 	$157.00 	3 	$158.50 	6 	$323.50 	0 	$0.00 	11 	$639.00
groupsales.com 		0 	$0.00 		0 	$0.00 		2 	$17.00 		0 	$0.00 	2 	$17.00
 
Totals 			49 	$5,307.95 	63 	$4,989.20 	71 	$6,293.15 	1 	$82.50 	184 	$16,672.80

For Intuit Canada:

Product  		Q1 (Jan-Mar)  		Q2 (Apr-Jun)  		Q3 (Jul-Sep)  		Q4 (Oct-Dec)  	Total # Total $
Cineplex Entert.. 	17 	$544.00 	27 	$446.00 	16 	$535.00 	0 	$0.00 	60 	$1,525.00
Cineplex Entert... 	8 	$192.00 	9 	$438.00 	4 	$97.00 		0 	$0.00 	21 	$727.00
Sunshine Villag.. 	2 	$641.50 	0 	$0.00 		0 	$0.00 		0 	$0.00 	2 	$641.50
West Edmonton .. 	4 	$300.00 	1 	$64.00 		1 	$32.00 		0 	$0.00 	6 	$396.00
Empire Theatre..	5 	$81.00 		2 	$64.80 		4 	$129.60 	0 	$0.00 	11 	$275.40
Edmonton Oiler..	1 	$168.00 	0 	$0.00 		0 	$0.00 		0 	$0.00 	1 	$168.00
Calgary Zoo Ad..	0 	$0.00 		3 	$136.00 	1 	$24.00 		0 	$0.00 	4 	$160.00
Fort Edmonton P.. 	0 	$0.00 		0 	$0.00 		4 	$80.00 		0 	$0.00 	4 	$80.00
Edmonton Oil Ki..	0 	$0.00 		0 	$0.00 		2 	$64.00 		0 	$0.00 	2 	$64.00
Calgary Zoo Pas..	0 	$0.00 		3 	$22.00 		1 	$16.00 		0 	$0.00 	4 	$38.00
Cineplex Enter.. 	0 	$0.00 		2 	$21.60 		1 	$10.50 		0 	$0.00 	3 	$32.10
Kidtropolis We.. 	0 	$0.00 		0 	$0.00 		1 	$30.00 		0 	$0.00 	1 	$30.00
Edmonton Valle.. 	0 	$0.00 		1 	$12.80 		1 	$12.80 		0 	$0.00 	2 	$25.60
Edmonton Mutta.. 	0 	$0.00 		1 	$13.00 		0 	$0.00 		0 	$0.00 	1 	$13.00
Fort Edmonton .. 	0 	$0.00 		0 	$0.00 		2 	$10.00 		0 	$0.00 	2 	$10.00
Fort Edmonton... 	0 	$0.00 		0 	$0.00 		1 	$7.50 		0 	$0.00 	1 	$7.50
Edmonton Vall.. 	0 	$0.00 		1 	$3.50 		1 	$3.50 		0 	$0.00 	2 	$7.00
 
Totals 			37 	$1,926.50 	50 	$1,221.70 	40 	$1,051.90 	0 	$0.00 	127 	$4,200.10


For Q1-2007

SELECT a.entry_company co_name, count(o.order_total) f1num, sum(o.order_total) f1amt
FROM zen_address_book as a
LEFT JOIN zen_orders as o ON a.customers_id = o.customers_id
WHERE o.date_purchased BETWEEN '2007-01-01' AND '2007-03-31'
GROUP BY co_name; 

+--------------------+-------+---------+
| co_name            | f1num | f1amt   |
+--------------------+-------+---------+
|                    |     2 |  157.00 |
| City of St. Albert |    18 | 2468.10 |
| Intuit Canada      |    29 | 2682.85 |
+--------------------+-------+---------+


SELECT p.products_name prod_name, count(p.products_quantity) f1num, p.products_quantity * sum(p.final_price) f1amt
FROM zen_orders_products as p                         LEFT JOIN zen_orders as o ON p.orders_id = o.orders_id
LEFT JOIN zen_address_book as a ON o.customers_id = a.customers_id
WHERE o.date_purchased BETWEEN '2007-01-01' AND '2007-03-31' AND entry_company = 'Intuit Canada'
GROUP BY prod_name;

+------------------------------------------------------+-------+-------+
| prod_name                                            | f1num | f1amt |
+------------------------------------------------------+-------+-------+
| Cineplex Entertainment Certificate (Admit One)       |    17 |   544 |
| Cineplex Entertainment Certificate (Adult Night Out) |     8 |   192 |
| Edmonton Oilers vs Minnesota Wild - March 15, 2007   |     1 |   168 |
| Empire Theatres Discount Coupon                      |     5 |    81 |
| Sunshine Village Lift Tickets!                       |     2 | 641.5 |
| West Edmonton Mall Attraction Passes                 |     4 |   300 |
+------------------------------------------------------+-------+-------+