fireflymantis

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.55City of St. Albert 	18 	$2,468.10 	19 	$2,108.00 	12 	$1,084.00 	1 	$82.50 	50 	$5,742.60Alberta Blue Cross 	0 	$0.00 		0 	$0.00 		24 	$3,326.65 	0 	$0.00 	24 	$3,326.65No Company Specified 	2 	$157.00 	3 	$158.50 	6 	$323.50 	0 	$0.00 	11 	$639.00groupsales.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.80For 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.00Cineplex Entert... 	8 	$192.00 	9 	$438.00 	4 	$97.00 		0 	$0.00 	21 	$727.00Sunshine Villag.. 	2 	$641.50 	0 	$0.00 		0 	$0.00 		0 	$0.00 	2 	$641.50West Edmonton .. 	4 	$300.00 	1 	$64.00 		1 	$32.00 		0 	$0.00 	6 	$396.00Empire Theatre..	5 	$81.00 		2 	$64.80 		4 	$129.60 	0 	$0.00 	11 	$275.40Edmonton Oiler..	1 	$168.00 	0 	$0.00 		0 	$0.00 		0 	$0.00 	1 	$168.00Calgary Zoo Ad..	0 	$0.00 		3 	$136.00 	1 	$24.00 		0 	$0.00 	4 	$160.00Fort Edmonton P.. 	0 	$0.00 		0 	$0.00 		4 	$80.00 		0 	$0.00 	4 	$80.00Edmonton Oil Ki..	0 	$0.00 		0 	$0.00 		2 	$64.00 		0 	$0.00 	2 	$64.00Calgary Zoo Pas..	0 	$0.00 		3 	$22.00 		1 	$16.00 		0 	$0.00 	4 	$38.00Cineplex Enter.. 	0 	$0.00 		2 	$21.60 		1 	$10.50 		0 	$0.00 	3 	$32.10Kidtropolis We.. 	0 	$0.00 		0 	$0.00 		1 	$30.00 		0 	$0.00 	1 	$30.00Edmonton Valle.. 	0 	$0.00 		1 	$12.80 		1 	$12.80 		0 	$0.00 	2 	$25.60Edmonton Mutta.. 	0 	$0.00 		1 	$13.00 		0 	$0.00 		0 	$0.00 	1 	$13.00Fort Edmonton .. 	0 	$0.00 		0 	$0.00 		2 	$10.00 		0 	$0.00 	2 	$10.00Fort Edmonton... 	0 	$0.00 		0 	$0.00 		1 	$7.50 		0 	$0.00 	1 	$7.50Edmonton 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.10For Q1-2007SELECT a.entry_company co_name, count(o.order_total) f1num, sum(o.order_total) f1amtFROM zen_address_book as aLEFT JOIN zen_orders as o ON a.customers_id = o.customers_idWHERE 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) f1amtFROM zen_orders_products as p                         LEFT JOIN zen_orders as o ON p.orders_id = o.orders_idLEFT JOIN zen_address_book as a ON o.customers_id = a.customers_idWHERE 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 |+------------------------------------------------------+-------+-------+