 
 (defn by-year [time] (list (or (.lower years time) time)))
 
-;; (?2 [] all-whales)
-
-;; (?2 [(union)] all-whales)
-;; (?2 [(ccount)] all-whales)
-;; (?2 [(sum :weight)] all-whales)
-
-;; (?2 [(split :type)] all-whales)
-
-;; (?2 [(ccount)(ccount)] all-whales)
-;; (?2 [(union)(union)] all-whales)
-;; (?2 [(ccount)(union)] all-whales)
-;; (?2 [(sum :weight)(union)] all-whales)
-;; (?2 [(union)(ccount)] all-whales)
-;; (?2 [(union)(split :type)] all-whales)
-;; (?2 [(ccount)(split :type)] all-whales)
-;; (?2 [(split :time)(split :type)] all-whales)
-
-;; (?2 [(ccount)(split :time)(split :type)] all-whales)
-;; (?2 [(union)(split :time)(split :type)] all-whales)
-;; (?2 [(split :length)(split :time)(split :type)] all-whales)
-
-;; (?2 [(split :type nil [(ccount)])] all-whales)
-;; (?2 [(split :type nil [(split :time)])] all-whales)
-;; (?2 [(split :type nil [(split :time nil [(split :length)])])] all-whales)
-
-;; (?2 [(split :type nil [(ccount)(split :time)])] all-whales)
-;; (?2 [(split :type nil [(split :time nil)(split :length)])] all-whales)
-
-;; (?2 [(split :type nil [(pivot :time years (keyword (count-value-key nil)))(ccount)(split :time by-year)])] all-whales)
-
-;; (?2 [(union "count/type/year")(split :type nil [(pivot :time years (keyword (count-value-key nil)))(ccount)(split :time by-year)])] all-whales)
-
-;; (?2 [(union "count/type/ocean")(split :type nil [(pivot :ocean oceans (keyword (count-value-key nil)))(ccount)(split :ocean )])] all-whales)
-
-;; (?2 [(union "sum(weight)/type/ocean")(split :type nil [(pivot :ocean oceans (keyword (sum-value-key :weight)))(sum :weight)(split :ocean )])] all-whales)
-
-;; (?2 [(union "count/ocean/type")(split :ocean nil [(pivot :type types (keyword (count-value-key nil)))(ccount)(split :type )])] all-whales)
-
-;; (?2 [(union "sum(weight)/ocean/type")(split :ocean nil [(pivot :type types (keyword (sum-value-key :weight)))(sum :weight)(split :type )])] all-whales)
+(?2 [] all-whales)
+
+(?2 [(union)] all-whales)
+(?2 [(ccount)] all-whales)
+(?2 [(sum :weight)] all-whales)
+
+(?2 [(split :type)] all-whales)
+
+(?2 [(ccount)(ccount)] all-whales)
+(?2 [(union)(union)] all-whales)
+(?2 [(ccount)(union)] all-whales)
+(?2 [(sum :weight)(union)] all-whales)
+(?2 [(union)(ccount)] all-whales)
+(?2 [(union)(split :type)] all-whales)
+(?2 [(ccount)(split :type)] all-whales)
+(?2 [(split :time)(split :type)] all-whales)
+
+(?2 [(ccount)(split :time)(split :type)] all-whales)
+(?2 [(union)(split :time)(split :type)] all-whales)
+(?2 [(split :length)(split :time)(split :type)] all-whales)
+
+(?2 [(split :type nil [(ccount)])] all-whales)
+(?2 [(split :type nil [(split :time)])] all-whales)
+(?2 [(split :type nil [(split :time nil [(split :length)])])] all-whales)
+
+(?2 [(split :type nil [(ccount)(split :time)])] all-whales)
+(?2 [(split :type nil [(split :time nil)(split :length)])] all-whales)
+
+(?2 [(split :type nil [(pivot :time years (keyword (count-value-key nil)))(ccount)(split :time by-year)])] all-whales)
+
+(?2 [(union "count/type/year")(split :type nil [(pivot :time years (keyword (count-value-key nil)))(ccount)(split :time by-year)])] all-whales)
+
+(?2 [(union "count/type/ocean")(split :type nil [(pivot :ocean oceans (keyword (count-value-key nil)))(ccount)(split :ocean )])] all-whales)
+
+(?2 [(union "sum(weight)/type/ocean")(split :type nil [(pivot :ocean oceans (keyword (sum-value-key :weight)))(sum :weight)(split :ocean )])] all-whales)
+
+(?2 [(union "count/ocean/type")(split :ocean nil [(pivot :type types (keyword (count-value-key nil)))(ccount)(split :type )])] all-whales)
+
+(?2 [(union "sum(weight)/ocean/type")(split :ocean nil [(pivot :type types (keyword (sum-value-key :weight)))(sum :weight)(split :type )])] all-whales)
 
 (def subquery [(pivot :time years (keyword (count-value-key nil)))(ccount)(split :time by-year)])
 

       (Date. (rand-int num-years)
	      (rand-int 12)
	      (+ (rand-int 28) 1))
       (rnd types)
       (rnd oceans)
       (/ (rand-int max-length-x-100) 100)

	     "southern"
	    ])

(def reporters [
		"jules"
		"andy"
		"ian"
		"steve"
		"mitesh"
		"ameen"
		])

(def num-years 10)

(def max-weight 172) ;; metric tons
