       rows formatted-venues-rows))
 
 
-;;; ## ENDS_WITH
+;;; ------------------------------------------------------------ ENDS_WITH ------------------------------------------------------------
 (expect-with-non-timeseries-dbs
   [[ 5 "Brite Spot Family Restaurant" 20 34.0778 -118.261 2]
    [ 7 "Don Day Korean Restaurant"    44 34.0689 -118.305 2]

               [:status :error]))


;;; ## order_by aggregate fields (SQL-only for the time being)

;;; ### order_by aggregate ["count"]
(qp-expect-with-all-engines
  {:columns [(format-name "price")
             "count"]

                          (ql/aggregation (ql/count))
                          (ql/filter (ql/between $date "2015-04-01" "2015-05-01")))))

;;; FILTER -- "OR", "<=", "="
(expect-with-non-timeseries-dbs
  [[1 "Red Medicine"                  4 10.0646 -165.374 3]
   [2 "Stout Burgers & Beers"        11 34.0996 -118.329 2]
