You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@pinot.apache.org by jl...@apache.org on 2020/10/23 08:10:01 UTC
[incubator-pinot] 01/01: Reduce pql queries from 10k to 500
This is an automated email from the ASF dual-hosted git repository.
jlli pushed a commit to branch refactor-integration-tests
in repository https://gitbox.apache.org/repos/asf/incubator-pinot.git
commit d6d2c64d28e46c600a47e72b9d31f1a3da64f9d1
Author: Jack Li(Analytics Engineering) <jl...@jlli-mn1.linkedin.biz>
AuthorDate: Fri Oct 23 01:09:23 2020 -0700
Reduce pql queries from 10k to 500
---
.../tests/BaseClusterIntegrationTestSet.java | 12 +-
...me_Performance_2014_100k_subset.test_queries_1K | 513 +++++++++++++++++++++
2 files changed, 518 insertions(+), 7 deletions(-)
diff --git a/pinot-integration-tests/src/test/java/org/apache/pinot/integration/tests/BaseClusterIntegrationTestSet.java b/pinot-integration-tests/src/test/java/org/apache/pinot/integration/tests/BaseClusterIntegrationTestSet.java
index a524047..2110aca 100644
--- a/pinot-integration-tests/src/test/java/org/apache/pinot/integration/tests/BaseClusterIntegrationTestSet.java
+++ b/pinot-integration-tests/src/test/java/org/apache/pinot/integration/tests/BaseClusterIntegrationTestSet.java
@@ -60,7 +60,7 @@ public abstract class BaseClusterIntegrationTestSet extends BaseClusterIntegrati
// Default settings
private static final String DEFAULT_PQL_QUERY_FILE_NAME =
- "On_Time_On_Time_Performance_2014_100k_subset.test_queries_10K";
+ "On_Time_On_Time_Performance_2014_100k_subset.test_queries_1K";
private static final String DEFAULT_SQL_QUERY_FILE_NAME =
"On_Time_On_Time_Performance_2014_100k_subset.test_queries_10K.sql";
private static final int DEFAULT_NUM_QUERIES_TO_GENERATE = 100;
@@ -320,19 +320,17 @@ public abstract class BaseClusterIntegrationTestSet extends BaseClusterIntegrati
assertNotNull(resourceUrl);
File queryFile = new File(resourceUrl.getFile());
- int maxNumQueriesToSkipInQueryFile = getMaxNumQueriesToSkipInQueryFile();
try (BufferedReader reader = new BufferedReader(new FileReader(queryFile))) {
while (true) {
- int numQueriesSkipped = RANDOM.nextInt(maxNumQueriesToSkipInQueryFile);
- for (int i = 0; i < numQueriesSkipped; i++) {
- reader.readLine();
- }
-
String queryString = reader.readLine();
// Reach end of file.
if (queryString == null) {
return;
}
+ // Skip commented line and empty line.
+ if (queryString.startsWith("#") || queryString.isEmpty()) {
+ continue;
+ }
JsonNode query = JsonUtils.stringToJsonNode(queryString);
String pqlQuery = query.get("pql").asText();
diff --git a/pinot-integration-tests/src/test/resources/On_Time_On_Time_Performance_2014_100k_subset.test_queries_1K b/pinot-integration-tests/src/test/resources/On_Time_On_Time_Performance_2014_100k_subset.test_queries_1K
new file mode 100644
index 0000000..a674276
--- /dev/null
+++ b/pinot-integration-tests/src/test/resources/On_Time_On_Time_Performance_2014_100k_subset.test_queries_1K
@@ -0,0 +1,513 @@
+# Aggregation
+{"hsqls":["SELECT sum(DepartureDelayGroups) FROM mytable LIMIT 10000","SELECT MIN(FlightNum) FROM mytable LIMIT 10000","SELECT MAX(AirlineID) FROM mytable LIMIT 10000","SELECT AVG(CAST(Year AS DOUBLE)) FROM mytable LIMIT 10000"],"pql":"SELECT sum(DepartureDelayGroups), min(FlightNum), MAX(AirlineID), AVG(Year) FROM mytable TOP 26"}
+{"hsqls":["SELECT AVG(CAST(ActualElapsedTime AS DOUBLE)) FROM mytable LIMIT 10000","SELECT COUNT(DivDistance) FROM mytable LIMIT 10000","SELECT MIN(DepDelay) FROM mytable LIMIT 10000"],"pql":"SELECT AVG(ActualElapsedTime), COUNT(DivDistance), MIN(DepDelay) FROM mytable TOP 18"}
+{"hsqls":["SELECT AVG(CAST(ArrDel15 AS DOUBLE)) FROM mytable LIMIT 10000"],"pql":"SELECT AVG(ArrDel15) FROM mytable TOP 11"}
+{"hsqls":["SELECT AVG(CAST(ArrTime AS DOUBLE)) FROM mytable LIMIT 10000","SELECT AVG(CAST(DivDistance AS DOUBLE)) FROM mytable LIMIT 10000","SELECT MIN(NASDelay) FROM mytable LIMIT 10000"],"pql":"SELECT AVG(ArrTime), AVG(DivDistance), MIN(NASDelay) FROM mytable TOP 22"}
+{"hsqls":["SELECT AVG(CAST(CRSDepTime AS DOUBLE)) FROM mytable LIMIT 10000","SELECT AVG(CAST(ArrDel15 AS DOUBLE)) FROM mytable LIMIT 10000","SELECT MAX(DepartureDelayGroups) FROM mytable LIMIT 10000"],"pql":"SELECT AVG(CRSDepTime), AVG(ArrDel15), MAX(DepartureDelayGroups) FROM mytable TOP 20"}
+{"hsqls":["SELECT AVG(CAST(CRSElapsedTime AS DOUBLE)) FROM mytable LIMIT 10000"],"pql":"SELECT AVG(CRSElapsedTime) FROM mytable TOP 27"}
+{"hsqls":["SELECT AVG(CAST(Cancelled AS DOUBLE)) FROM mytable LIMIT 10000"],"pql":"SELECT AVG(Cancelled) FROM mytable TOP 16"}
+{"hsqls":["SELECT AVG(CAST(CarrierDelay AS DOUBLE)) FROM mytable LIMIT 10000","SELECT MIN(DivReachedDest) FROM mytable LIMIT 10000","SELECT MIN(FirstDepTime) FROM mytable LIMIT 10000"],"pql":"SELECT AVG(CarrierDelay), MIN(DivReachedDest), MIN(FirstDepTime) FROM mytable"}
+{"hsqls":["SELECT AVG(CAST(DayOfWeek AS DOUBLE)) FROM mytable LIMIT 10000","SELECT AVG(CAST(DestAirportID AS DOUBLE)) FROM mytable LIMIT 10000","SELECT AVG(CAST(DepTime AS DOUBLE)) FROM mytable LIMIT 10000"],"pql":"SELECT AVG(DayOfWeek), AVG(DestAirportID), AVG(DepTime) FROM mytable TOP 16"}
+{"hsqls":["SELECT AVG(CAST(DepDel15 AS DOUBLE)) FROM mytable LIMIT 10000","SELECT MAX(LateAircraftDelay) FROM mytable LIMIT 10000"],"pql":"SELECT AVG(DepDel15), MAX(LateAircraftDelay) FROM mytable TOP 17"}
+{"hsqls":["SELECT AVG(CAST(DestAirportID AS DOUBLE)) FROM mytable LIMIT 10000","SELECT SUM(FlightNum) FROM mytable LIMIT 10000"],"pql":"SELECT AVG(DestAirportID), SUM(FlightNum) FROM mytable TOP 8"}
+{"hsqls":["SELECT AVG(CAST(DestAirportSeqID AS DOUBLE)) FROM mytable LIMIT 10000","SELECT AVG(CAST(DestCityMarketID AS DOUBLE)) FROM mytable LIMIT 10000"],"pql":"SELECT AVG(DestAirportSeqID), AVG(DestCityMarketID) FROM mytable TOP 8"}
+{"hsqls":["SELECT AVG(CAST(DestStateFips AS DOUBLE)) FROM mytable LIMIT 10000","SELECT MAX(DepTime) FROM mytable LIMIT 10000"],"pql":"SELECT AVG(DestStateFips), MAX(DepTime) FROM mytable TOP 5"}
+{"hsqls":["SELECT AVG(CAST(DestStateFips AS DOUBLE)) FROM mytable LIMIT 10000","SELECT MAX(LateAircraftDelay) FROM mytable LIMIT 10000","SELECT COUNT(FlightDate) FROM mytable LIMIT 10000"],"pql":"SELECT AVG(DestStateFips), MAX(LateAircraftDelay), COUNT(FlightDate) FROM mytable TOP 15"}
+{"hsqls":["SELECT AVG(CAST(DivActualElapsedTime AS DOUBLE)) FROM mytable LIMIT 10000"],"pql":"SELECT AVG(DivActualElapsedTime) FROM mytable TOP 0"}
+{"hsqls":["SELECT AVG(CAST(DivActualElapsedTime AS DOUBLE)) FROM mytable LIMIT 10000"],"pql":"SELECT AVG(DivActualElapsedTime) FROM mytable TOP 12"}
+{"hsqls":["SELECT AVG(CAST(DivReachedDest AS DOUBLE)) FROM mytable LIMIT 10000","SELECT COUNT(TaxiIn) FROM mytable LIMIT 10000"],"pql":"SELECT AVG(DivReachedDest), COUNT(TaxiIn) FROM mytable TOP 29"}
+{"hsqls":["SELECT AVG(CAST(DivReachedDest AS DOUBLE)) FROM mytable LIMIT 10000"],"pql":"SELECT AVG(DivReachedDest) FROM mytable TOP 4"}
+{"hsqls":["SELECT AVG(CAST(Diverted AS DOUBLE)) FROM mytable LIMIT 10000"],"pql":"SELECT AVG(Diverted) FROM mytable TOP 28"}
+{"hsqls":["SELECT AVG(CAST(FirstDepTime AS DOUBLE)) FROM mytable LIMIT 10000","SELECT MIN(FirstDepTime) FROM mytable LIMIT 10000"],"pql":"SELECT AVG(FirstDepTime), MIN(FirstDepTime) FROM mytable TOP 10"}
+{"hsqls":["SELECT AVG(CAST(LateAircraftDelay AS DOUBLE)) FROM mytable LIMIT 10000","SELECT SUM(DaysSinceEpoch) FROM mytable LIMIT 10000","SELECT MAX(Month) FROM mytable LIMIT 10000"],"pql":"SELECT AVG(LateAircraftDelay), SUM(DaysSinceEpoch), MAX(Month) FROM mytable TOP 24"}
+{"hsqls":["SELECT AVG(CAST(LateAircraftDelay AS DOUBLE)) FROM mytable LIMIT 10000"],"pql":"SELECT AVG(LateAircraftDelay) FROM mytable TOP 10"}
+{"hsqls":["SELECT AVG(CAST(LongestAddGTime AS DOUBLE)) FROM mytable LIMIT 10000","SELECT COUNT(DepDelayMinutes) FROM mytable LIMIT 10000"],"pql":"SELECT AVG(LongestAddGTime), COUNT(DepDelayMinutes) FROM mytable TOP 2"}
+{"hsqls":["SELECT AVG(CAST(Month AS DOUBLE)) FROM mytable LIMIT 10000","SELECT AVG(CAST(WheelsOff AS DOUBLE)) FROM mytable LIMIT 10000"],"pql":"SELECT AVG(Month), AVG(WheelsOff) FROM mytable TOP 29"}
+{"hsqls":["SELECT AVG(CAST(Month AS DOUBLE)) FROM mytable LIMIT 10000","SELECT MIN(DepartureDelayGroups) FROM mytable LIMIT 10000"],"pql":"SELECT AVG(Month), MIN(DepartureDelayGroups) FROM mytable TOP 16"}
+{"hsqls":["SELECT AVG(CAST(NASDelay AS DOUBLE)) FROM mytable LIMIT 10000"],"pql":"SELECT AVG(NASDelay) FROM mytable TOP 18"}
+{"hsqls":["SELECT AVG(CAST(OriginAirportSeqID AS DOUBLE)) FROM mytable LIMIT 10000","SELECT SUM(OriginAirportID) FROM mytable LIMIT 10000","SELECT MIN(TaxiOut) FROM mytable LIMIT 10000"],"pql":"SELECT AVG(OriginAirportSeqID), SUM(OriginAirportID), MIN(TaxiOut) FROM mytable TOP 27"}
+{"hsqls":["SELECT AVG(CAST(OriginCityMarketID AS DOUBLE)) FROM mytable LIMIT 10000"],"pql":"SELECT AVG(OriginCityMarketID) FROM mytable TOP 22"}
+{"hsqls":["SELECT AVG(CAST(OriginStateFips AS DOUBLE)) FROM mytable LIMIT 10000"],"pql":"SELECT AVG(OriginStateFips) FROM mytable TOP 28"}
+{"hsqls":["SELECT AVG(CAST(Quarter AS DOUBLE)) FROM mytable LIMIT 10000","SELECT MIN(DayOfWeek) FROM mytable LIMIT 10000","SELECT SUM(TaxiIn) FROM mytable LIMIT 10000"],"pql":"SELECT AVG(Quarter), MIN(DayOfWeek), SUM(TaxiIn) FROM mytable"}
+{"hsqls":["SELECT AVG(CAST(Quarter AS DOUBLE)) FROM mytable LIMIT 10000","SELECT MIN(FirstDepTime) FROM mytable LIMIT 10000"],"pql":"SELECT AVG(Quarter), MIN(FirstDepTime) FROM mytable TOP 18"}
+{"hsqls":["SELECT AVG(CAST(TotalAddGTime AS DOUBLE)) FROM mytable LIMIT 10000","SELECT COUNT(DivAirportLandings) FROM mytable LIMIT 10000"],"pql":"SELECT AVG(TotalAddGTime), COUNT(DivAirportLandings) FROM mytable TOP 20"}
+{"hsqls":["SELECT AVG(CAST(TotalAddGTime AS DOUBLE)) FROM mytable LIMIT 10000","SELECT MAX(CRSDepTime) FROM mytable LIMIT 10000","SELECT AVG(CAST(DepDelayMinutes AS DOUBLE)) FROM mytable LIMIT 10000"],"pql":"SELECT AVG(TotalAddGTime), MAX(CRSDepTime), AVG(DepDelayMinutes) FROM mytable TOP 19"}
+{"hsqls":["SELECT AVG(CAST(TotalAddGTime AS DOUBLE)) FROM mytable LIMIT 10000","SELECT SUM(WeatherDelay) FROM mytable LIMIT 10000"],"pql":"SELECT AVG(TotalAddGTime), SUM(WeatherDelay) FROM mytable TOP 20"}
+{"hsqls":["SELECT AVG(CAST(TotalAddGTime AS DOUBLE)) FROM mytable LIMIT 10000"],"pql":"SELECT AVG(TotalAddGTime) FROM mytable TOP 10"}
+{"hsqls":["SELECT AVG(CAST(WheelsOff AS DOUBLE)) FROM mytable LIMIT 10000"],"pql":"SELECT AVG(WheelsOff) FROM mytable TOP 0"}
+{"hsqls":["SELECT AVG(CAST(WheelsOn AS DOUBLE)) FROM mytable LIMIT 10000","SELECT AVG(CAST(WheelsOff AS DOUBLE)) FROM mytable LIMIT 10000"],"pql":"SELECT AVG(WheelsOn), AVG(WheelsOff) FROM mytable TOP 27"}
+{"hsqls":["SELECT AVG(CAST(Year AS DOUBLE)) FROM mytable LIMIT 10000","SELECT AVG(CAST(DivReachedDest AS DOUBLE)) FROM mytable LIMIT 10000","SELECT MIN(ArrDel15) FROM mytable LIMIT 10000"],"pql":"SELECT AVG(Year), AVG(DivReachedDest), MIN(ArrDel15) FROM mytable TOP 22"}
+{"hsqls":["SELECT COUNT(*) FROM mytable LIMIT 10000"],"pql":"SELECT COUNT(*) FROM mytable TOP 0"}
+{"hsqls":["SELECT COUNT(*) FROM mytable LIMIT 10000"],"pql":"SELECT COUNT(*) FROM mytable TOP 29"}
+{"hsqls":["SELECT COUNT(ArrDelayMinutes) FROM mytable LIMIT 10000","SELECT MAX(ArrDelayMinutes) FROM mytable LIMIT 10000","SELECT SUM(TaxiIn) FROM mytable LIMIT 10000"],"pql":"SELECT COUNT(ArrDelayMinutes), MAX(ArrDelayMinutes), SUM(TaxiIn) FROM mytable TOP 16"}
+{"hsqls":["SELECT COUNT(ArrTime) FROM mytable LIMIT 10000"],"pql":"SELECT COUNT(ArrTime) FROM mytable TOP 1"}
+{"hsqls":["SELECT COUNT(ArrTimeBlk) FROM mytable LIMIT 10000","SELECT AVG(CAST(Cancelled AS DOUBLE)) FROM mytable LIMIT 10000","SELECT COUNT(CarrierDelay) FROM mytable LIMIT 10000"],"pql":"SELECT COUNT(ArrTimeBlk), AVG(Cancelled), COUNT(CarrierDelay) FROM mytable TOP 6"}
+{"hsqls":["SELECT COUNT(ArrivalDelayGroups) FROM mytable LIMIT 10000","SELECT MIN(DepartureDelayGroups) FROM mytable LIMIT 10000","SELECT SUM(AirlineID) FROM mytable LIMIT 10000"],"pql":"SELECT COUNT(ArrivalDelayGroups), MIN(DepartureDelayGroups), SUM(AirlineID) FROM mytable TOP 15"}
+{"hsqls":["SELECT COUNT(CRSElapsedTime) FROM mytable LIMIT 10000"],"pql":"SELECT COUNT(CRSElapsedTime) FROM mytable TOP 11"}
+{"hsqls":["SELECT COUNT(Cancelled) FROM mytable LIMIT 10000","SELECT AVG(CAST(LateAircraftDelay AS DOUBLE)) FROM mytable LIMIT 10000"],"pql":"SELECT COUNT(Cancelled), AVG(LateAircraftDelay) FROM mytable TOP 29"}
+{"hsqls":["SELECT COUNT(Carrier) FROM mytable LIMIT 10000","SELECT AVG(CAST(DivDistance AS DOUBLE)) FROM mytable LIMIT 10000","SELECT SUM(DistanceGroup) FROM mytable LIMIT 10000"],"pql":"SELECT COUNT(Carrier), AVG(DivDistance), SUM(DistanceGroup) FROM mytable TOP 14"}
+{"hsqls":["SELECT COUNT(CarrierDelay) FROM mytable LIMIT 10000","SELECT SUM(DepartureDelayGroups) FROM mytable LIMIT 10000"],"pql":"SELECT COUNT(CarrierDelay), SUM(DepartureDelayGroups) FROM mytable TOP 9"}
+{"hsqls":["SELECT COUNT(DayofMonth) FROM mytable LIMIT 10000","SELECT COUNT(OriginCityName) FROM mytable LIMIT 10000","SELECT COUNT(TailNum) FROM mytable LIMIT 10000"],"pql":"SELECT COUNT(DayofMonth), COUNT(OriginCityName), COUNT(TailNum) FROM mytable TOP 5"}
+{"hsqls":["SELECT COUNT(DepDel15) FROM mytable LIMIT 10000","SELECT COUNT(DepDelay) FROM mytable LIMIT 10000","SELECT SUM(DepartureDelayGroups) FROM mytable LIMIT 10000"],"pql":"SELECT COUNT(DepDel15), COUNT(DepDelay), SUM(DepartureDelayGroups) FROM mytable TOP 13"}
+{"hsqls":["SELECT COUNT(DepDelay) FROM mytable LIMIT 10000","SELECT MAX(DivActualElapsedTime) FROM mytable LIMIT 10000"],"pql":"SELECT COUNT(DepDelay), MAX(DivActualElapsedTime) FROM mytable TOP 3"}
+{"hsqls":["SELECT COUNT(DepTimeBlk) FROM mytable LIMIT 10000","SELECT MAX(DivActualElapsedTime) FROM mytable LIMIT 10000"],"pql":"SELECT COUNT(DepTimeBlk), MAX(DivActualElapsedTime) FROM mytable TOP 19"}
+{"hsqls":["SELECT COUNT(DepartureDelayGroups) FROM mytable LIMIT 10000","SELECT COUNT(WheelsOff) FROM mytable LIMIT 10000","SELECT MAX(DayofMonth) FROM mytable LIMIT 10000"],"pql":"SELECT COUNT(DepartureDelayGroups), COUNT(WheelsOff), MAX(DayofMonth) FROM mytable"}
+{"hsqls":["SELECT COUNT(Dest) FROM mytable LIMIT 10000","SELECT MAX(DestWac) FROM mytable LIMIT 10000"],"pql":"SELECT COUNT(Dest), MAX(DestWac) FROM mytable TOP 9"}
+{"hsqls":["SELECT COUNT(DestCityMarketID) FROM mytable LIMIT 10000","SELECT AVG(CAST(DestWac AS DOUBLE)) FROM mytable LIMIT 10000"],"pql":"SELECT COUNT(DestCityMarketID), AVG(DestWac) FROM mytable TOP 18"}
+{"hsqls":["SELECT COUNT(DestCityMarketID) FROM mytable LIMIT 10000"],"pql":"SELECT COUNT(DestCityMarketID) FROM mytable TOP 13"}
+{"hsqls":["SELECT COUNT(DestCityName) FROM mytable LIMIT 10000","SELECT COUNT(DestAirportID) FROM mytable LIMIT 10000","SELECT AVG(CAST(TaxiIn AS DOUBLE)) FROM mytable LIMIT 10000"],"pql":"SELECT COUNT(DestCityName), COUNT(DestAirportID), AVG(TaxiIn) FROM mytable TOP 26"}
+{"hsqls":["SELECT COUNT(DestStateFips) FROM mytable LIMIT 10000","SELECT SUM(CRSElapsedTime) FROM mytable LIMIT 10000"],"pql":"SELECT COUNT(DestStateFips), SUM(CRSElapsedTime) FROM mytable TOP 13"}
+{"hsqls":["SELECT COUNT(DestStateFips) FROM mytable LIMIT 10000","SELECT SUM(OriginAirportID) FROM mytable LIMIT 10000"],"pql":"SELECT COUNT(DestStateFips), SUM(OriginAirportID) FROM mytable TOP 29"}
+{"hsqls":["SELECT COUNT(DestWac) FROM mytable LIMIT 10000","SELECT SUM(DestStateFips) FROM mytable LIMIT 10000","SELECT SUM(OriginStateFips) FROM mytable LIMIT 10000"],"pql":"SELECT COUNT(DestWac), SUM(DestStateFips), SUM(OriginStateFips) FROM mytable TOP 3"}
+{"hsqls":["SELECT COUNT(Origin) FROM mytable LIMIT 10000","SELECT MIN(ArrDel15) FROM mytable LIMIT 10000","SELECT MIN(ArrivalDelayGroups) FROM mytable LIMIT 10000"],"pql":"SELECT COUNT(Origin), MIN(ArrDel15), MIN(ArrivalDelayGroups) FROM mytable TOP 10"}
+{"hsqls":["SELECT COUNT(OriginAirportID) FROM mytable LIMIT 10000","SELECT AVG(CAST(FlightNum AS DOUBLE)) FROM mytable LIMIT 10000"],"pql":"SELECT COUNT(OriginAirportID), AVG(FlightNum) FROM mytable TOP 23"}
+{"hsqls":["SELECT COUNT(OriginCityMarketID) FROM mytable LIMIT 10000","SELECT MIN(SecurityDelay) FROM mytable LIMIT 10000","SELECT MAX(DepTime) FROM mytable LIMIT 10000"],"pql":"SELECT COUNT(OriginCityMarketID), MIN(SecurityDelay), MAX(DepTime) FROM mytable TOP 6"}
+{"hsqls":["SELECT COUNT(OriginStateFips) FROM mytable LIMIT 10000","SELECT COUNT(DayofMonth) FROM mytable LIMIT 10000"],"pql":"SELECT COUNT(OriginStateFips), COUNT(DayofMonth) FROM mytable TOP 19"}
+{"hsqls":["SELECT COUNT(OriginStateName) FROM mytable LIMIT 10000","SELECT COUNT(LateAircraftDelay) FROM mytable LIMIT 10000","SELECT SUM(ArrTime) FROM mytable LIMIT 10000"],"pql":"SELECT COUNT(OriginStateName), COUNT(LateAircraftDelay), SUM(ArrTime) FROM mytable TOP 21"}
+{"hsqls":["SELECT COUNT(OriginWac) FROM mytable LIMIT 10000","SELECT AVG(CAST(CRSElapsedTime AS DOUBLE)) FROM mytable LIMIT 10000","SELECT SUM(CRSArrTime) FROM mytable LIMIT 10000"],"pql":"SELECT COUNT(OriginWac), AVG(CRSElapsedTime), SUM(CRSArrTime) FROM mytable TOP 22"}
+{"hsqls":["SELECT COUNT(Quarter) FROM mytable LIMIT 10000","SELECT SUM(ArrDelayMinutes) FROM mytable LIMIT 10000","SELECT SUM(DestAirportSeqID) FROM mytable LIMIT 10000"],"pql":"SELECT COUNT(Quarter), SUM(ArrDelayMinutes), SUM(DestAirportSeqID) FROM mytable TOP 29"}
+{"hsqls":["SELECT COUNT(TaxiIn) FROM mytable LIMIT 10000","SELECT COUNT(CarrierDelay) FROM mytable LIMIT 10000"],"pql":"SELECT COUNT(TaxiIn), COUNT(CarrierDelay) FROM mytable TOP 13"}
+{"hsqls":["SELECT COUNT(TaxiOut) FROM mytable LIMIT 10000","SELECT COUNT(DivReachedDest) FROM mytable LIMIT 10000"],"pql":"SELECT COUNT(TaxiOut), COUNT(DivReachedDest) FROM mytable TOP 6"}
+{"hsqls":["SELECT MAX(ArrDelay) FROM mytable LIMIT 10000","SELECT AVG(CAST(Distance AS DOUBLE)) FROM mytable LIMIT 10000","SELECT MIN(DayofMonth) FROM mytable LIMIT 10000"],"pql":"SELECT MAX(ArrDelay), AVG(Distance), MIN(DayofMonth) FROM mytable TOP 23"}
+{"hsqls":["SELECT MAX(ArrDelayMinutes) FROM mytable LIMIT 10000"],"pql":"SELECT MAX(ArrDelayMinutes) FROM mytable TOP 21"}
+{"hsqls":["SELECT MAX(ArrivalDelayGroups) FROM mytable LIMIT 10000"],"pql":"SELECT MAX(ArrivalDelayGroups) FROM mytable TOP 15"}
+{"hsqls":["SELECT MAX(CRSArrTime) FROM mytable LIMIT 10000","SELECT SUM(ArrDelay) FROM mytable LIMIT 10000","SELECT MAX(DayOfWeek) FROM mytable LIMIT 10000"],"pql":"SELECT MAX(CRSArrTime), SUM(ArrDelay), MAX(DayOfWeek) FROM mytable TOP 4"}
+{"hsqls":["SELECT MAX(DaysSinceEpoch) FROM mytable LIMIT 10000","SELECT SUM(DestStateFips) FROM mytable LIMIT 10000"],"pql":"SELECT MAX(DaysSinceEpoch), SUM(DestStateFips) FROM mytable"}
+{"hsqls":["SELECT MAX(DepDelay) FROM mytable LIMIT 10000"],"pql":"SELECT MAX(DepDelay) FROM mytable TOP 10"}
+{"hsqls":["SELECT MAX(DepDelayMinutes) FROM mytable LIMIT 10000"],"pql":"SELECT MAX(DepDelayMinutes) FROM mytable TOP 27"}
+{"hsqls":["SELECT MAX(DepTime) FROM mytable LIMIT 10000","SELECT AVG(CAST(OriginWac AS DOUBLE)) FROM mytable LIMIT 10000","SELECT AVG(CAST(OriginCityMarketID AS DOUBLE)) FROM mytable LIMIT 10000"],"pql":"SELECT MAX(DepTime), AVG(OriginWac), AVG(OriginCityMarketID) FROM mytable TOP 15"}
+{"hsqls":["SELECT MAX(DestAirportID) FROM mytable LIMIT 10000","SELECT AVG(CAST(CRSElapsedTime AS DOUBLE)) FROM mytable LIMIT 10000","SELECT MAX(DivActualElapsedTime) FROM mytable LIMIT 10000"],"pql":"SELECT MAX(DestAirportID), AVG(CRSElapsedTime), MAX(DivActualElapsedTime) FROM mytable TOP 18"}
+{"hsqls":["SELECT MAX(DestAirportID) FROM mytable LIMIT 10000","SELECT MAX(DestStateFips) FROM mytable LIMIT 10000","SELECT MIN(DestAirportID) FROM mytable LIMIT 10000"],"pql":"SELECT MAX(DestAirportID), MAX(DestStateFips), MIN(DestAirportID) FROM mytable TOP 16"}
+{"hsqls":["SELECT MAX(DestAirportSeqID) FROM mytable LIMIT 10000","SELECT MAX(AirTime) FROM mytable LIMIT 10000"],"pql":"SELECT MAX(DestAirportSeqID), MAX(AirTime) FROM mytable TOP 22"}
+{"hsqls":["SELECT MAX(Distance) FROM mytable LIMIT 10000"],"pql":"SELECT MAX(Distance) FROM mytable TOP 29"}
+{"hsqls":["SELECT MAX(DistanceGroup) FROM mytable LIMIT 10000","SELECT SUM(DepDelayMinutes) FROM mytable LIMIT 10000"],"pql":"SELECT MAX(DistanceGroup), SUM(DepDelayMinutes) FROM mytable TOP 3"}
+{"hsqls":["SELECT MAX(DivDistance) FROM mytable LIMIT 10000","SELECT AVG(CAST(TaxiOut AS DOUBLE)) FROM mytable LIMIT 10000"],"pql":"SELECT MAX(DivDistance), AVG(TaxiOut) FROM mytable TOP 26"}
+{"hsqls":["SELECT MAX(DivReachedDest) FROM mytable LIMIT 10000"],"pql":"SELECT MAX(DivReachedDest) FROM mytable TOP 22"}
+{"hsqls":["SELECT MAX(Diverted) FROM mytable LIMIT 10000","SELECT COUNT(DepTime) FROM mytable LIMIT 10000"],"pql":"SELECT MAX(Diverted), COUNT(DepTime) FROM mytable TOP 25"}
+{"hsqls":["SELECT MAX(FirstDepTime) FROM mytable LIMIT 10000","SELECT COUNT(FlightDate) FROM mytable LIMIT 10000","SELECT SUM(DepartureDelayGroups) FROM mytable LIMIT 10000"],"pql":"SELECT MAX(FirstDepTime), COUNT(FlightDate), SUM(DepartureDelayGroups) FROM mytable TOP 26"}
+{"hsqls":["SELECT MAX(FirstDepTime) FROM mytable LIMIT 10000","SELECT MAX(SecurityDelay) FROM mytable LIMIT 10000"],"pql":"SELECT MAX(FirstDepTime), MAX(SecurityDelay) FROM mytable TOP 19"}
+{"hsqls":["SELECT MAX(Flights) FROM mytable LIMIT 10000","SELECT MAX(CRSArrTime) FROM mytable LIMIT 10000"],"pql":"SELECT MAX(Flights), MAX(CRSArrTime) FROM mytable TOP 3"}
+{"hsqls":["SELECT MAX(OriginAirportID) FROM mytable LIMIT 10000","SELECT COUNT(WheelsOff) FROM mytable LIMIT 10000","SELECT COUNT(TailNum) FROM mytable LIMIT 10000"],"pql":"SELECT MAX(OriginAirportID), COUNT(WheelsOff), COUNT(TailNum) FROM mytable TOP 12"}
+{"hsqls":["SELECT MAX(OriginAirportSeqID) FROM mytable LIMIT 10000","SELECT AVG(CAST(Cancelled AS DOUBLE)) FROM mytable LIMIT 10000","SELECT COUNT(Cancelled) FROM mytable LIMIT 10000"],"pql":"SELECT MAX(OriginAirportSeqID), AVG(Cancelled), COUNT(Cancelled) FROM mytable TOP 17"}
+{"hsqls":["SELECT MIN(CRSDepTime) FROM mytable LIMIT 10000","SELECT SUM(ActualElapsedTime) FROM mytable LIMIT 10000"],"pql":"SELECT MIN(CRSDepTime), SUM(ActualElapsedTime) FROM mytable TOP 7"}
+{"hsqls":["SELECT MIN(CRSElapsedTime) FROM mytable LIMIT 10000","SELECT AVG(CAST(DivActualElapsedTime AS DOUBLE)) FROM mytable LIMIT 10000"],"pql":"SELECT MIN(CRSElapsedTime), AVG(DivActualElapsedTime) FROM mytable TOP 0"}
+{"hsqls":["SELECT MIN(CarrierDelay) FROM mytable LIMIT 10000","SELECT SUM(Diverted) FROM mytable LIMIT 10000","SELECT SUM(DestWac) FROM mytable LIMIT 10000"],"pql":"SELECT MIN(CarrierDelay), SUM(Diverted), SUM(DestWac) FROM mytable TOP 16"}
+{"hsqls":["SELECT MIN(DayOfWeek) FROM mytable LIMIT 10000","SELECT COUNT(AirlineID) FROM mytable LIMIT 10000"],"pql":"SELECT MIN(DayOfWeek), COUNT(AirlineID) FROM mytable TOP 2"}
+{"hsqls":["SELECT MIN(DepDelayMinutes) FROM mytable LIMIT 10000","SELECT AVG(CAST(WeatherDelay AS DOUBLE)) FROM mytable LIMIT 10000","SELECT SUM(Cancelled) FROM mytable LIMIT 10000"],"pql":"SELECT MIN(DepDelayMinutes), AVG(WeatherDelay), SUM(Cancelled) FROM mytable TOP 19"}
+{"hsqls":["SELECT MIN(DivActualElapsedTime) FROM mytable LIMIT 10000","SELECT AVG(CAST(OriginCityMarketID AS DOUBLE)) FROM mytable LIMIT 10000"],"pql":"SELECT MIN(DivActualElapsedTime), AVG(OriginCityMarketID) FROM mytable TOP 15"}
+{"hsqls":["SELECT MIN(DivDistance) FROM mytable LIMIT 10000","SELECT MAX(Cancelled) FROM mytable LIMIT 10000"],"pql":"SELECT MIN(DivDistance), MAX(Cancelled) FROM mytable TOP 25"}
+{"hsqls":["SELECT MIN(Diverted) FROM mytable LIMIT 10000","SELECT MAX(Month) FROM mytable LIMIT 10000"],"pql":"SELECT MIN(Diverted), MAX(Month) FROM mytable TOP 20"}
+{"hsqls":["SELECT MIN(FlightNum) FROM mytable LIMIT 10000","SELECT COUNT(DivReachedDest) FROM mytable LIMIT 10000","SELECT SUM(FlightNum) FROM mytable LIMIT 10000"],"pql":"SELECT MIN(FlightNum), COUNT(DivReachedDest), SUM(FlightNum) FROM mytable TOP 2"}
+{"hsqls":["SELECT MIN(OriginAirportID) FROM mytable LIMIT 10000","SELECT MIN(DestWac) FROM mytable LIMIT 10000"],"pql":"SELECT MIN(OriginAirportID), MIN(DestWac) FROM mytable TOP 21"}
+{"hsqls":["SELECT MIN(OriginAirportSeqID) FROM mytable LIMIT 10000","SELECT AVG(CAST(DestAirportID AS DOUBLE)) FROM mytable LIMIT 10000","SELECT AVG(CAST(DepTime AS DOUBLE)) FROM mytable LIMIT 10000"],"pql":"SELECT MIN(OriginAirportSeqID), AVG(DestAirportID), AVG(DepTime) FROM mytable TOP 23"}
+{"hsqls":["SELECT MIN(Quarter) FROM mytable LIMIT 10000","SELECT COUNT(DepTime) FROM mytable LIMIT 10000"],"pql":"SELECT MIN(Quarter), COUNT(DepTime) FROM mytable TOP 4"}
+{"hsqls":["SELECT MIN(SecurityDelay) FROM mytable LIMIT 10000","SELECT MIN(DivArrDelay) FROM mytable LIMIT 10000","SELECT MIN(DestAirportSeqID) FROM mytable LIMIT 10000"],"pql":"SELECT MIN(SecurityDelay), MIN(DivArrDelay), MIN(DestAirportSeqID) FROM mytable TOP 13"}
+{"hsqls":["SELECT MIN(TotalAddGTime) FROM mytable LIMIT 10000","SELECT MAX(CRSArrTime) FROM mytable LIMIT 10000"],"pql":"SELECT MIN(TotalAddGTime), MAX(CRSArrTime) FROM mytable TOP 26"}
+{"hsqls":["SELECT MIN(WheelsOn) FROM mytable LIMIT 10000","SELECT MIN(ActualElapsedTime) FROM mytable LIMIT 10000","SELECT AVG(CAST(OriginAirportID AS DOUBLE)) FROM mytable LIMIT 10000"],"pql":"SELECT MIN(WheelsOn), MIN(ActualElapsedTime), AVG(OriginAirportID) FROM mytable TOP 1"}
+{"hsqls":["SELECT SUM(AirlineID) FROM mytable LIMIT 10000","SELECT MIN(OriginCityMarketID) FROM mytable LIMIT 10000"],"pql":"SELECT SUM(AirlineID), MIN(OriginCityMarketID) FROM mytable TOP 1"}
+{"hsqls":["SELECT SUM(ArrDelayMinutes) FROM mytable LIMIT 10000","SELECT MIN(OriginAirportID) FROM mytable LIMIT 10000","SELECT MIN(ArrDelay) FROM mytable LIMIT 10000"],"pql":"SELECT SUM(ArrDelayMinutes), MIN(OriginAirportID), MIN(ArrDelay) FROM mytable TOP 15"}
+{"hsqls":["SELECT SUM(ArrivalDelayGroups) FROM mytable LIMIT 10000","SELECT AVG(CAST(Flights AS DOUBLE)) FROM mytable LIMIT 10000"],"pql":"SELECT SUM(ArrivalDelayGroups), AVG(Flights) FROM mytable TOP 13"}
+{"hsqls":["SELECT SUM(CRSDepTime) FROM mytable LIMIT 10000","SELECT COUNT(DestStateFips) FROM mytable LIMIT 10000"],"pql":"SELECT SUM(CRSDepTime), COUNT(DestStateFips) FROM mytable TOP 19"}
+{"hsqls":["SELECT SUM(CRSDepTime) FROM mytable LIMIT 10000","SELECT MAX(OriginWac) FROM mytable LIMIT 10000","SELECT MAX(ArrTime) FROM mytable LIMIT 10000"],"pql":"SELECT SUM(CRSDepTime), MAX(OriginWac), MAX(ArrTime) FROM mytable TOP 18"}
+{"hsqls":["SELECT SUM(Cancelled) FROM mytable LIMIT 10000","SELECT SUM(DaysSinceEpoch) FROM mytable LIMIT 10000","SELECT COUNT(DestState) FROM mytable LIMIT 10000"],"pql":"SELECT SUM(Cancelled), SUM(DaysSinceEpoch), COUNT(DestState) FROM mytable TOP 20"}
+{"hsqls":["SELECT SUM(CarrierDelay) FROM mytable LIMIT 10000","SELECT SUM(DivActualElapsedTime) FROM mytable LIMIT 10000","SELECT AVG(CAST(DepDelayMinutes AS DOUBLE)) FROM mytable LIMIT 10000"],"pql":"SELECT SUM(CarrierDelay), SUM(DivActualElapsedTime), AVG(DepDelayMinutes) FROM mytable TOP 25"}
+{"hsqls":["SELECT SUM(DepDel15) FROM mytable LIMIT 10000","SELECT SUM(WeatherDelay) FROM mytable LIMIT 10000","SELECT AVG(CAST(Cancelled AS DOUBLE)) FROM mytable LIMIT 10000"],"pql":"SELECT SUM(DepDel15), SUM(WeatherDelay), AVG(Cancelled) FROM mytable TOP 16"}
+{"hsqls":["SELECT SUM(DepDelayMinutes) FROM mytable LIMIT 10000","SELECT COUNT(OriginCityName) FROM mytable LIMIT 10000","SELECT COUNT(DivAirportLandings) FROM mytable LIMIT 10000"],"pql":"SELECT SUM(DepDelayMinutes), COUNT(OriginCityName), COUNT(DivAirportLandings) FROM mytable TOP 29"}
+{"hsqls":["SELECT SUM(DepDelayMinutes) FROM mytable LIMIT 10000","SELECT MIN(ActualElapsedTime) FROM mytable LIMIT 10000","SELECT SUM(DivDistance) FROM mytable LIMIT 10000"],"pql":"SELECT SUM(DepDelayMinutes), MIN(ActualElapsedTime), SUM(DivDistance) FROM mytable TOP 24"}
+{"hsqls":["SELECT SUM(DivAirportLandings) FROM mytable LIMIT 10000","SELECT AVG(CAST(DepDelayMinutes AS DOUBLE)) FROM mytable LIMIT 10000"],"pql":"SELECT SUM(DivAirportLandings), AVG(DepDelayMinutes) FROM mytable"}
+{"hsqls":["SELECT SUM(DivAirportLandings) FROM mytable LIMIT 10000","SELECT MIN(TotalAddGTime) FROM mytable LIMIT 10000","SELECT MIN(WheelsOff) FROM mytable LIMIT 10000"],"pql":"SELECT SUM(DivAirportLandings), MIN(TotalAddGTime), MIN(WheelsOff) FROM mytable"}
+{"hsqls":["SELECT SUM(FirstDepTime) FROM mytable LIMIT 10000","SELECT SUM(DepTime) FROM mytable LIMIT 10000","SELECT MIN(DepDelay) FROM mytable LIMIT 10000"],"pql":"SELECT SUM(FirstDepTime), SUM(DepTime), MIN(DepDelay) FROM mytable TOP 13"}
+{"hsqls":["SELECT SUM(FlightNum) FROM mytable LIMIT 10000","SELECT SUM(OriginStateFips) FROM mytable LIMIT 10000"],"pql":"SELECT SUM(FlightNum), SUM(OriginStateFips) FROM mytable TOP 28"}
+{"hsqls":["SELECT SUM(Flights) FROM mytable LIMIT 10000","SELECT COUNT(CRSElapsedTime) FROM mytable LIMIT 10000"],"pql":"SELECT SUM(Flights), COUNT(CRSElapsedTime) FROM mytable TOP 24"}
+{"hsqls":["SELECT SUM(LateAircraftDelay) FROM mytable LIMIT 10000","SELECT AVG(CAST(AirlineID AS DOUBLE)) FROM mytable LIMIT 10000"],"pql":"SELECT SUM(LateAircraftDelay), AVG(AirlineID) FROM mytable TOP 5"}
+{"hsqls":["SELECT SUM(LongestAddGTime) FROM mytable LIMIT 10000","SELECT MIN(TaxiIn) FROM mytable LIMIT 10000","SELECT AVG(CAST(LateAircraftDelay AS DOUBLE)) FROM mytable LIMIT 10000"],"pql":"SELECT SUM(LongestAddGTime), MIN(TaxiIn), AVG(LateAircraftDelay) FROM mytable TOP 2"}
+{"hsqls":["SELECT SUM(NASDelay) FROM mytable LIMIT 10000","SELECT MAX(WheelsOff) FROM mytable LIMIT 10000","SELECT SUM(ArrDelay) FROM mytable LIMIT 10000"],"pql":"SELECT SUM(NASDelay), MAX(WheelsOff), SUM(ArrDelay) FROM mytable TOP 13"}
+{"hsqls":["SELECT SUM(OriginAirportID) FROM mytable LIMIT 10000","SELECT COUNT(TailNum) FROM mytable LIMIT 10000","SELECT MIN(DestStateFips) FROM mytable LIMIT 10000"],"pql":"SELECT SUM(OriginAirportID), COUNT(TailNum), MIN(DestStateFips) FROM mytable TOP 8"}
+{"hsqls":["SELECT SUM(Quarter) FROM mytable LIMIT 10000","SELECT COUNT(DepTime) FROM mytable LIMIT 10000"],"pql":"SELECT SUM(Quarter), COUNT(DepTime) FROM mytable TOP 25"}
+{"hsqls":["SELECT SUM(WheelsOff) FROM mytable LIMIT 10000","SELECT SUM(CRSArrTime) FROM mytable LIMIT 10000","SELECT SUM(DestStateFips) FROM mytable LIMIT 10000"],"pql":"SELECT SUM(WheelsOff), SUM(CRSArrTime), SUM(DestStateFips) FROM mytable TOP 11"}
+{"hsqls":["SELECT SUM(Year) FROM mytable LIMIT 10000","SELECT AVG(CAST(OriginStateFips AS DOUBLE)) FROM mytable LIMIT 10000"],"pql":"SELECT SUM(Year), AVG(OriginStateFips) FROM mytable TOP 24"}
+
+# Grouping on Aggregation
+{"hsqls":["SELECT WheelsOn, COUNT(*) FROM mytable GROUP BY WheelsOn LIMIT 10000"],"pql":"SELECT COUNT(*) FROM mytable GROUP BY WheelsOn TOP 25"}
+{"hsqls":["SELECT DestAirportID, MIN(DepartureDelayGroups) FROM mytable GROUP BY DestAirportID LIMIT 10000","SELECT DestAirportID, COUNT(DivDistance) FROM mytable GROUP BY DestAirportID LIMIT 10000"],"pql":"SELECT MIN(DepartureDelayGroups), COUNT(DivDistance) FROM mytable GROUP BY DestAirportID TOP 6"}
+{"hsqls":["SELECT AirTime, AVG(CAST(LongestAddGTime AS DOUBLE)) FROM mytable GROUP BY AirTime LIMIT 10000","SELECT AirTime, AVG(CAST(OriginCityMarketID AS DOUBLE)) FROM mytable GROUP BY AirTime LIMIT 10000"],"pql":"SELECT AVG(LongestAddGTime), AVG(OriginCityMarketID) FROM mytable GROUP BY AirTime TOP 8"}
+{"hsqls":["SELECT AirTime, CancellationCode, AVG(CAST(Month AS DOUBLE)) FROM mytable GROUP BY AirTime, CancellationCode LIMIT 10000","SELECT AirTime, CancellationCode, MIN(OriginWac) FROM mytable GROUP BY AirTime, CancellationCode LIMIT 10000","SELECT AirTime, CancellationCode, SUM(DepTime) FROM mytable GROUP BY AirTime, CancellationCode LIMIT 10000"],"pql":"SELECT AVG(Month), MIN(OriginWac), SUM(DepTime) FROM mytable GROUP BY AirTime, CancellationCode TOP 3"}
+{"hsqls":["SELECT ArrDel15, AVG(CAST(Diverted AS DOUBLE)) FROM mytable GROUP BY ArrDel15 LIMIT 10000"],"pql":"SELECT AVG(Diverted) FROM mytable GROUP BY ArrDel15 TOP 18"}
+{"hsqls":["SELECT ArrDelay, AVG(CAST(DepDel15 AS DOUBLE)) FROM mytable GROUP BY ArrDelay LIMIT 10000","SELECT ArrDelay, SUM(LongestAddGTime) FROM mytable GROUP BY ArrDelay LIMIT 10000"],"pql":"SELECT AVG(DepDel15), SUM(LongestAddGTime) FROM mytable GROUP BY ArrDelay TOP 5"}
+{"hsqls":["SELECT ArrDelayMinutes, AVG(CAST(ArrDel15 AS DOUBLE)) FROM mytable GROUP BY ArrDelayMinutes LIMIT 10000"],"pql":"SELECT AVG(ArrDel15) FROM mytable GROUP BY ArrDelayMinutes TOP 2"}
+{"hsqls":["SELECT ArrTimeBlk, OriginStateName, AVG(CAST(WeatherDelay AS DOUBLE)) FROM mytable GROUP BY ArrTimeBlk, OriginStateName LIMIT 10000","SELECT ArrTimeBlk, OriginStateName, SUM(CarrierDelay) FROM mytable GROUP BY ArrTimeBlk, OriginStateName LIMIT 10000","SELECT ArrTimeBlk, OriginStateName, SUM(CRSElapsedTime) FROM mytable GROUP BY ArrTimeBlk, OriginStateName LIMIT 10000"],"pql":"SELECT AVG(WeatherDelay), SUM(CarrierDelay), SUM(CRSElapsedTime) FROM mytable GROUP BY ArrTimeBlk, Ori [...]
+{"hsqls":["SELECT ArrivalDelayGroups, AVG(CAST(DestCityMarketID AS DOUBLE)) FROM mytable GROUP BY ArrivalDelayGroups LIMIT 10000","SELECT ArrivalDelayGroups, COUNT(Diverted) FROM mytable GROUP BY ArrivalDelayGroups LIMIT 10000","SELECT ArrivalDelayGroups, AVG(CAST(LateAircraftDelay AS DOUBLE)) FROM mytable GROUP BY ArrivalDelayGroups LIMIT 10000"],"pql":"SELECT AVG(DestCityMarketID), COUNT(Diverted), AVG(LateAircraftDelay) FROM mytable GROUP BY ArrivalDelayGroups TOP 19"}
+{"hsqls":["SELECT Cancelled, DepDel15, AVG(CAST(DepDelay AS DOUBLE)) FROM mytable GROUP BY Cancelled, DepDel15 LIMIT 10000","SELECT Cancelled, DepDel15, AVG(CAST(DivArrDelay AS DOUBLE)) FROM mytable GROUP BY Cancelled, DepDel15 LIMIT 10000","SELECT Cancelled, DepDel15, AVG(CAST(DepartureDelayGroups AS DOUBLE)) FROM mytable GROUP BY Cancelled, DepDel15 LIMIT 10000"],"pql":"SELECT AVG(DepDelay), AVG(DivArrDelay), AVG(DepartureDelayGroups) FROM mytable GROUP BY Cancelled, DepDel15 TOP 26"}
+{"hsqls":["SELECT Carrier, AVG(CAST(DaysSinceEpoch AS DOUBLE)) FROM mytable GROUP BY Carrier LIMIT 10000","SELECT Carrier, SUM(OriginWac) FROM mytable GROUP BY Carrier LIMIT 10000","SELECT Carrier, SUM(DestCityMarketID) FROM mytable GROUP BY Carrier LIMIT 10000"],"pql":"SELECT AVG(DaysSinceEpoch), SUM(OriginWac), SUM(DestCityMarketID) FROM mytable GROUP BY Carrier"}
+{"hsqls":["SELECT CarrierDelay, AVG(CAST(DayofMonth AS DOUBLE)) FROM mytable GROUP BY CarrierDelay LIMIT 10000","SELECT CarrierDelay, MIN(DepDel15) FROM mytable GROUP BY CarrierDelay LIMIT 10000","SELECT CarrierDelay, SUM(Quarter) FROM mytable GROUP BY CarrierDelay LIMIT 10000"],"pql":"SELECT AVG(DayofMonth), MIN(DepDel15), SUM(Quarter) FROM mytable GROUP BY CarrierDelay TOP 26"}
+{"hsqls":["SELECT DayOfWeek, AVG(CAST(TaxiOut AS DOUBLE)) FROM mytable GROUP BY DayOfWeek LIMIT 10000","SELECT DayOfWeek, AVG(CAST(DepartureDelayGroups AS DOUBLE)) FROM mytable GROUP BY DayOfWeek LIMIT 10000","SELECT DayOfWeek, MAX(DivAirportLandings) FROM mytable GROUP BY DayOfWeek LIMIT 10000"],"pql":"SELECT AVG(TaxiOut), AVG(DepartureDelayGroups), MAX(DivAirportLandings) FROM mytable GROUP BY DayOfWeek TOP 9"}
+{"hsqls":["SELECT DaysSinceEpoch, AVG(CAST(Distance AS DOUBLE)) FROM mytable GROUP BY DaysSinceEpoch LIMIT 10000","SELECT DaysSinceEpoch, MIN(AirlineID) FROM mytable GROUP BY DaysSinceEpoch LIMIT 10000"],"pql":"SELECT AVG(Distance), MIN(AirlineID) FROM mytable GROUP BY DaysSinceEpoch TOP 14"}
+{"hsqls":["SELECT DepDelay, CarrierDelay, SecurityDelay, AVG(CAST(DepDelay AS DOUBLE)) FROM mytable GROUP BY DepDelay, CarrierDelay, SecurityDelay LIMIT 10000","SELECT DepDelay, CarrierDelay, SecurityDelay, AVG(CAST(OriginAirportID AS DOUBLE)) FROM mytable GROUP BY DepDelay, CarrierDelay, SecurityDelay LIMIT 10000"],"pql":"SELECT AVG(DepDelay), AVG(OriginAirportID) FROM mytable GROUP BY DepDelay, CarrierDelay, SecurityDelay TOP 1"}
+{"hsqls":["SELECT DepDelay, NASDelay, AVG(CAST(NASDelay AS DOUBLE)) FROM mytable GROUP BY DepDelay, NASDelay LIMIT 10000","SELECT DepDelay, NASDelay, MIN(TotalAddGTime) FROM mytable GROUP BY DepDelay, NASDelay LIMIT 10000","SELECT DepDelay, NASDelay, MIN(FirstDepTime) FROM mytable GROUP BY DepDelay, NASDelay LIMIT 10000"],"pql":"SELECT AVG(NASDelay), MIN(TotalAddGTime), MIN(FirstDepTime) FROM mytable GROUP BY DepDelay, NASDelay TOP 2"}
+{"hsqls":["SELECT DepDelayMinutes, AVG(CAST(Cancelled AS DOUBLE)) FROM mytable GROUP BY DepDelayMinutes LIMIT 10000","SELECT DepDelayMinutes, MIN(ActualElapsedTime) FROM mytable GROUP BY DepDelayMinutes LIMIT 10000"],"pql":"SELECT AVG(Cancelled), MIN(ActualElapsedTime) FROM mytable GROUP BY DepDelayMinutes TOP 17"}
+{"hsqls":["SELECT FlightDate, Cancelled, AVG(CAST(DayOfWeek AS DOUBLE)) FROM mytable GROUP BY FlightDate, Cancelled LIMIT 10000","SELECT FlightDate, Cancelled, MIN(DivArrDelay) FROM mytable GROUP BY FlightDate, Cancelled LIMIT 10000"],"pql":"SELECT AVG(DayOfWeek), MIN(DivArrDelay) FROM mytable GROUP BY FlightDate, Cancelled TOP 14"}
+{"hsqls":["SELECT FlightNum, AVG(CAST(DistanceGroup AS DOUBLE)) FROM mytable GROUP BY FlightNum LIMIT 10000"],"pql":"SELECT AVG(DistanceGroup) FROM mytable GROUP BY FlightNum TOP 14"}
+{"hsqls":["SELECT LateAircraftDelay, DestStateFips, DivArrDelay, AVG(CAST(DestAirportID AS DOUBLE)) FROM mytable GROUP BY LateAircraftDelay, DestStateFips, DivArrDelay LIMIT 10000","SELECT LateAircraftDelay, DestStateFips, DivArrDelay, COUNT(DivArrDelay) FROM mytable GROUP BY LateAircraftDelay, DestStateFips, DivArrDelay LIMIT 10000","SELECT LateAircraftDelay, DestStateFips, DivArrDelay, COUNT(ArrDel15) FROM mytable GROUP BY LateAircraftDelay, DestStateFips, DivArrDelay LIMIT 10000"],"pq [...]
+{"hsqls":["SELECT LateAircraftDelay, FirstDepTime, DivDistance, AVG(CAST(FlightNum AS DOUBLE)) FROM mytable GROUP BY LateAircraftDelay, FirstDepTime, DivDistance LIMIT 10000","SELECT LateAircraftDelay, FirstDepTime, DivDistance, MIN(OriginWac) FROM mytable GROUP BY LateAircraftDelay, FirstDepTime, DivDistance LIMIT 10000","SELECT LateAircraftDelay, FirstDepTime, DivDistance, MIN(CRSElapsedTime) FROM mytable GROUP BY LateAircraftDelay, FirstDepTime, DivDistance LIMIT 10000"],"pql":"SELECT [...]
+{"hsqls":["SELECT LateAircraftDelay, OriginWac, AVG(CAST(WeatherDelay AS DOUBLE)) FROM mytable GROUP BY LateAircraftDelay, OriginWac LIMIT 10000","SELECT LateAircraftDelay, OriginWac, AVG(CAST(CRSDepTime AS DOUBLE)) FROM mytable GROUP BY LateAircraftDelay, OriginWac LIMIT 10000","SELECT LateAircraftDelay, OriginWac, MAX(CRSDepTime) FROM mytable GROUP BY LateAircraftDelay, OriginWac LIMIT 10000"],"pql":"SELECT AVG(WeatherDelay), AVG(CRSDepTime), MAX(CRSDepTime) FROM mytable GROUP BY LateA [...]
+{"hsqls":["SELECT LongestAddGTime, AVG(CAST(ArrivalDelayGroups AS DOUBLE)) FROM mytable GROUP BY LongestAddGTime LIMIT 10000","SELECT LongestAddGTime, AVG(CAST(AirlineID AS DOUBLE)) FROM mytable GROUP BY LongestAddGTime LIMIT 10000","SELECT LongestAddGTime, SUM(DivDistance) FROM mytable GROUP BY LongestAddGTime LIMIT 10000"],"pql":"SELECT AVG(ArrivalDelayGroups), AVG(AirlineID), SUM(DivDistance) FROM mytable GROUP BY LongestAddGTime TOP 0"}
+{"hsqls":["SELECT LongestAddGTime, Origin, DayofMonth, AVG(CAST(TaxiOut AS DOUBLE)) FROM mytable GROUP BY LongestAddGTime, Origin, DayofMonth LIMIT 10000","SELECT LongestAddGTime, Origin, DayofMonth, SUM(TaxiIn) FROM mytable GROUP BY LongestAddGTime, Origin, DayofMonth LIMIT 10000"],"pql":"SELECT AVG(TaxiOut), SUM(TaxiIn) FROM mytable GROUP BY LongestAddGTime, Origin, DayofMonth TOP 7"}
+{"hsqls":["SELECT Month, AVG(CAST(Month AS DOUBLE)) FROM mytable GROUP BY Month LIMIT 10000","SELECT Month, AVG(CAST(AirTime AS DOUBLE)) FROM mytable GROUP BY Month LIMIT 10000"],"pql":"SELECT AVG(Month), AVG(AirTime) FROM mytable GROUP BY Month TOP 10"}
+{"hsqls":["SELECT Origin, AVG(CAST(OriginAirportSeqID AS DOUBLE)) FROM mytable GROUP BY Origin LIMIT 10000","SELECT Origin, MIN(FirstDepTime) FROM mytable GROUP BY Origin LIMIT 10000","SELECT Origin, MIN(Distance) FROM mytable GROUP BY Origin LIMIT 10000"],"pql":"SELECT AVG(OriginAirportSeqID), MIN(FirstDepTime), MIN(Distance) FROM mytable GROUP BY Origin TOP 10"}
+{"hsqls":["SELECT OriginAirportSeqID, DepTimeBlk, AVG(CAST(Diverted AS DOUBLE)) FROM mytable GROUP BY OriginAirportSeqID, DepTimeBlk LIMIT 10000","SELECT OriginAirportSeqID, DepTimeBlk, MIN(DestStateFips) FROM mytable GROUP BY OriginAirportSeqID, DepTimeBlk LIMIT 10000","SELECT OriginAirportSeqID, DepTimeBlk, SUM(ArrTime) FROM mytable GROUP BY OriginAirportSeqID, DepTimeBlk LIMIT 10000"],"pql":"SELECT AVG(Diverted), MIN(DestStateFips), SUM(ArrTime) FROM mytable GROUP BY OriginAirportSeqI [...]
+{"hsqls":["SELECT OriginCityMarketID, DestStateFips, TotalAddGTime, AVG(CAST(SecurityDelay AS DOUBLE)) FROM mytable GROUP BY OriginCityMarketID, DestStateFips, TotalAddGTime LIMIT 10000","SELECT OriginCityMarketID, DestStateFips, TotalAddGTime, SUM(DestCityMarketID) FROM mytable GROUP BY OriginCityMarketID, DestStateFips, TotalAddGTime LIMIT 10000"],"pql":"SELECT AVG(SecurityDelay), SUM(DestCityMarketID) FROM mytable GROUP BY OriginCityMarketID, DestStateFips, TotalAddGTime TOP 23"}
+{"hsqls":["SELECT OriginWac, OriginAirportID, AVG(CAST(ArrTime AS DOUBLE)) FROM mytable GROUP BY OriginWac, OriginAirportID LIMIT 10000","SELECT OriginWac, OriginAirportID, MAX(DestAirportID) FROM mytable GROUP BY OriginWac, OriginAirportID LIMIT 10000"],"pql":"SELECT AVG(ArrTime), MAX(DestAirportID) FROM mytable GROUP BY OriginWac, OriginAirportID TOP 13"}
+{"hsqls":["SELECT Quarter, AVG(CAST(CRSDepTime AS DOUBLE)) FROM mytable GROUP BY Quarter LIMIT 10000","SELECT Quarter, SUM(OriginAirportID) FROM mytable GROUP BY Quarter LIMIT 10000"],"pql":"SELECT AVG(CRSDepTime), SUM(OriginAirportID) FROM mytable GROUP BY Quarter TOP 6"}
+{"hsqls":["SELECT SecurityDelay, AVG(CAST(OriginWac AS DOUBLE)) FROM mytable GROUP BY SecurityDelay LIMIT 10000","SELECT SecurityDelay, COUNT(OriginStateName) FROM mytable GROUP BY SecurityDelay LIMIT 10000","SELECT SecurityDelay, AVG(CAST(OriginCityMarketID AS DOUBLE)) FROM mytable GROUP BY SecurityDelay LIMIT 10000"],"pql":"SELECT AVG(OriginWac), COUNT(OriginStateName), AVG(OriginCityMarketID) FROM mytable GROUP BY SecurityDelay"}
+{"hsqls":["SELECT TailNum, AVG(CAST(Year AS DOUBLE)) FROM mytable GROUP BY TailNum LIMIT 10000","SELECT TailNum, MIN(DestCityMarketID) FROM mytable GROUP BY TailNum LIMIT 10000"],"pql":"SELECT AVG(Year), MIN(DestCityMarketID) FROM mytable GROUP BY TailNum TOP 24"}
+{"hsqls":["SELECT TotalAddGTime, AVG(CAST(DestStateFips AS DOUBLE)) FROM mytable GROUP BY TotalAddGTime LIMIT 10000","SELECT TotalAddGTime, MAX(CRSDepTime) FROM mytable GROUP BY TotalAddGTime LIMIT 10000","SELECT TotalAddGTime, COUNT(TailNum) FROM mytable GROUP BY TotalAddGTime LIMIT 10000"],"pql":"SELECT AVG(DestStateFips), MAX(CRSDepTime), COUNT(TailNum) FROM mytable GROUP BY TotalAddGTime TOP 3"}
+{"hsqls":["SELECT UniqueCarrier, AVG(CAST(DayOfWeek AS DOUBLE)) FROM mytable GROUP BY UniqueCarrier LIMIT 10000","SELECT UniqueCarrier, MAX(DivReachedDest) FROM mytable GROUP BY UniqueCarrier LIMIT 10000","SELECT UniqueCarrier, MAX(ActualElapsedTime) FROM mytable GROUP BY UniqueCarrier LIMIT 10000"],"pql":"SELECT AVG(DayOfWeek), MAX(DivReachedDest), MAX(ActualElapsedTime) FROM mytable GROUP BY UniqueCarrier TOP 29"}
+{"hsqls":["SELECT UniqueCarrier, OriginAirportID, AVG(CAST(LongestAddGTime AS DOUBLE)) FROM mytable GROUP BY UniqueCarrier, OriginAirportID LIMIT 10000"],"pql":"SELECT AVG(LongestAddGTime) FROM mytable GROUP BY UniqueCarrier, OriginAirportID TOP 1"}
+{"hsqls":["SELECT Year, Diverted, AVG(CAST(TaxiIn AS DOUBLE)) FROM mytable GROUP BY Year, Diverted LIMIT 10000","SELECT Year, Diverted, SUM(DivArrDelay) FROM mytable GROUP BY Year, Diverted LIMIT 10000"],"pql":"SELECT AVG(TaxiIn), SUM(DivArrDelay) FROM mytable GROUP BY Year, Diverted"}
+{"hsqls":["SELECT ActualElapsedTime, COUNT(DayofMonth) FROM mytable GROUP BY ActualElapsedTime LIMIT 10000","SELECT ActualElapsedTime, AVG(CAST(Cancelled AS DOUBLE)) FROM mytable GROUP BY ActualElapsedTime LIMIT 10000","SELECT ActualElapsedTime, MIN(OriginCityMarketID) FROM mytable GROUP BY ActualElapsedTime LIMIT 10000"],"pql":"SELECT COUNT(DayofMonth), AVG(Cancelled), MIN(OriginCityMarketID) FROM mytable GROUP BY ActualElapsedTime TOP 22"}
+{"hsqls":["SELECT AirTime, COUNT(DestStateName) FROM mytable GROUP BY AirTime LIMIT 10000","SELECT AirTime, MAX(DepDel15) FROM mytable GROUP BY AirTime LIMIT 10000","SELECT AirTime, MIN(TaxiIn) FROM mytable GROUP BY AirTime LIMIT 10000"],"pql":"SELECT COUNT(DestStateName), MAX(DepDel15), MIN(TaxiIn) FROM mytable GROUP BY AirTime TOP 3"}
+{"hsqls":["SELECT ArrivalDelayGroups, COUNT(DivActualElapsedTime) FROM mytable GROUP BY ArrivalDelayGroups LIMIT 10000","SELECT ArrivalDelayGroups, MIN(ArrDel15) FROM mytable GROUP BY ArrivalDelayGroups LIMIT 10000","SELECT ArrivalDelayGroups, MIN(CarrierDelay) FROM mytable GROUP BY ArrivalDelayGroups LIMIT 10000"],"pql":"SELECT COUNT(DivActualElapsedTime), MIN(ArrDel15), MIN(CarrierDelay) FROM mytable GROUP BY ArrivalDelayGroups TOP 16"}
+{"hsqls":["SELECT ArrivalDelayGroups, COUNT(Flights) FROM mytable GROUP BY ArrivalDelayGroups LIMIT 10000","SELECT ArrivalDelayGroups, COUNT(DepTime) FROM mytable GROUP BY ArrivalDelayGroups LIMIT 10000"],"pql":"SELECT COUNT(Flights), COUNT(DepTime) FROM mytable GROUP BY ArrivalDelayGroups TOP 12"}
+{"hsqls":["SELECT CRSArrTime, COUNT(*) FROM mytable GROUP BY CRSArrTime LIMIT 10000"],"pql":"SELECT COUNT(*) FROM mytable GROUP BY CRSArrTime TOP 28"}
+{"hsqls":["SELECT CRSArrTime, COUNT(AirTime) FROM mytable GROUP BY CRSArrTime LIMIT 10000","SELECT CRSArrTime, AVG(CAST(LateAircraftDelay AS DOUBLE)) FROM mytable GROUP BY CRSArrTime LIMIT 10000"],"pql":"SELECT COUNT(AirTime), AVG(LateAircraftDelay) FROM mytable GROUP BY CRSArrTime TOP 17"}
+{"hsqls":["SELECT CRSArrTime, COUNT(OriginAirportSeqID) FROM mytable GROUP BY CRSArrTime LIMIT 10000","SELECT CRSArrTime, MIN(AirTime) FROM mytable GROUP BY CRSArrTime LIMIT 10000"],"pql":"SELECT COUNT(OriginAirportSeqID), MIN(AirTime) FROM mytable GROUP BY CRSArrTime TOP 27"}
+{"hsqls":["SELECT Cancelled, CancellationCode, COUNT(Quarter) FROM mytable GROUP BY Cancelled, CancellationCode LIMIT 10000"],"pql":"SELECT COUNT(Quarter) FROM mytable GROUP BY Cancelled, CancellationCode TOP 29"}
+{"hsqls":["SELECT Cancelled, DestAirportID, UniqueCarrier, COUNT(*) FROM mytable GROUP BY Cancelled, DestAirportID, UniqueCarrier LIMIT 10000"],"pql":"SELECT COUNT(*) FROM mytable GROUP BY Cancelled, DestAirportID, UniqueCarrier TOP 0"}
+{"hsqls":["SELECT Cancelled, DivAirportLandings, COUNT(*) FROM mytable GROUP BY Cancelled, DivAirportLandings LIMIT 10000"],"pql":"SELECT COUNT(*) FROM mytable GROUP BY Cancelled, DivAirportLandings TOP 10"}
+{"hsqls":["SELECT Carrier, ArrDel15, ArrivalDelayGroups, COUNT(NASDelay) FROM mytable GROUP BY Carrier, ArrDel15, ArrivalDelayGroups LIMIT 10000","SELECT Carrier, ArrDel15, ArrivalDelayGroups, MAX(DivActualElapsedTime) FROM mytable GROUP BY Carrier, ArrDel15, ArrivalDelayGroups LIMIT 10000","SELECT Carrier, ArrDel15, ArrivalDelayGroups, MAX(CRSDepTime) FROM mytable GROUP BY Carrier, ArrDel15, ArrivalDelayGroups LIMIT 10000"],"pql":"SELECT COUNT(NASDelay), MAX(DivActualElapsedTime), MAX(C [...]
+{"hsqls":["SELECT DayOfWeek, COUNT(Origin) FROM mytable GROUP BY DayOfWeek LIMIT 10000"],"pql":"SELECT COUNT(Origin) FROM mytable GROUP BY DayOfWeek TOP 29"}
+{"hsqls":["SELECT DayofMonth, COUNT(ArrivalDelayGroups) FROM mytable GROUP BY DayofMonth LIMIT 10000","SELECT DayofMonth, AVG(CAST(DepartureDelayGroups AS DOUBLE)) FROM mytable GROUP BY DayofMonth LIMIT 10000"],"pql":"SELECT COUNT(ArrivalDelayGroups), AVG(DepartureDelayGroups) FROM mytable GROUP BY DayofMonth TOP 10"}
+{"hsqls":["SELECT DaysSinceEpoch, COUNT(DivDistance) FROM mytable GROUP BY DaysSinceEpoch LIMIT 10000","SELECT DaysSinceEpoch, AVG(CAST(Cancelled AS DOUBLE)) FROM mytable GROUP BY DaysSinceEpoch LIMIT 10000","SELECT DaysSinceEpoch, COUNT(LongestAddGTime) FROM mytable GROUP BY DaysSinceEpoch LIMIT 10000"],"pql":"SELECT COUNT(DivDistance), AVG(Cancelled), COUNT(LongestAddGTime) FROM mytable GROUP BY DaysSinceEpoch TOP 24"}
+{"hsqls":["SELECT DepDelayMinutes, COUNT(Origin) FROM mytable GROUP BY DepDelayMinutes LIMIT 10000","SELECT DepDelayMinutes, MAX(NASDelay) FROM mytable GROUP BY DepDelayMinutes LIMIT 10000"],"pql":"SELECT COUNT(Origin), MAX(NASDelay) FROM mytable GROUP BY DepDelayMinutes TOP 25"}
+{"hsqls":["SELECT DepTimeBlk, DivAirportLandings, COUNT(Dest) FROM mytable GROUP BY DepTimeBlk, DivAirportLandings LIMIT 10000","SELECT DepTimeBlk, DivAirportLandings, MIN(OriginAirportSeqID) FROM mytable GROUP BY DepTimeBlk, DivAirportLandings LIMIT 10000","SELECT DepTimeBlk, DivAirportLandings, AVG(CAST(NASDelay AS DOUBLE)) FROM mytable GROUP BY DepTimeBlk, DivAirportLandings LIMIT 10000"],"pql":"SELECT COUNT(Dest), MIN(OriginAirportSeqID), AVG(NASDelay) FROM mytable GROUP BY DepTimeBl [...]
+{"hsqls":["SELECT DepartureDelayGroups, LateAircraftDelay, COUNT(Flights) FROM mytable GROUP BY DepartureDelayGroups, LateAircraftDelay LIMIT 10000","SELECT DepartureDelayGroups, LateAircraftDelay, MIN(CRSElapsedTime) FROM mytable GROUP BY DepartureDelayGroups, LateAircraftDelay LIMIT 10000"],"pql":"SELECT COUNT(Flights), MIN(CRSElapsedTime) FROM mytable GROUP BY DepartureDelayGroups, LateAircraftDelay TOP 15"}
+{"hsqls":["SELECT DepartureDelayGroups, OriginCityName, DivAirportLandings, COUNT(*) FROM mytable GROUP BY DepartureDelayGroups, OriginCityName, DivAirportLandings LIMIT 10000"],"pql":"SELECT COUNT(*) FROM mytable GROUP BY DepartureDelayGroups, OriginCityName, DivAirportLandings TOP 27"}
+{"hsqls":["SELECT Dest, AirlineID, COUNT(OriginCityMarketID) FROM mytable GROUP BY Dest, AirlineID LIMIT 10000"],"pql":"SELECT COUNT(OriginCityMarketID) FROM mytable GROUP BY Dest, AirlineID TOP 6"}
+{"hsqls":["SELECT Dest, ArrivalDelayGroups, COUNT(OriginCityMarketID) FROM mytable GROUP BY Dest, ArrivalDelayGroups LIMIT 10000","SELECT Dest, ArrivalDelayGroups, SUM(ArrDelay) FROM mytable GROUP BY Dest, ArrivalDelayGroups LIMIT 10000","SELECT Dest, ArrivalDelayGroups, AVG(CAST(CRSArrTime AS DOUBLE)) FROM mytable GROUP BY Dest, ArrivalDelayGroups LIMIT 10000"],"pql":"SELECT COUNT(OriginCityMarketID), SUM(ArrDelay), AVG(CRSArrTime) FROM mytable GROUP BY Dest, ArrivalDelayGroups TOP 8"}
+{"hsqls":["SELECT Dest, COUNT(OriginCityMarketID) FROM mytable GROUP BY Dest LIMIT 10000","SELECT Dest, MIN(OriginAirportSeqID) FROM mytable GROUP BY Dest LIMIT 10000","SELECT Dest, MIN(DivReachedDest) FROM mytable GROUP BY Dest LIMIT 10000"],"pql":"SELECT COUNT(OriginCityMarketID), MIN(OriginAirportSeqID), MIN(DivReachedDest) FROM mytable GROUP BY Dest TOP 15"}
+{"hsqls":["SELECT Dest, OriginStateName, COUNT(OriginState) FROM mytable GROUP BY Dest, OriginStateName LIMIT 10000","SELECT Dest, OriginStateName, MAX(Diverted) FROM mytable GROUP BY Dest, OriginStateName LIMIT 10000","SELECT Dest, OriginStateName, MAX(DayofMonth) FROM mytable GROUP BY Dest, OriginStateName LIMIT 10000"],"pql":"SELECT COUNT(OriginState), MAX(Diverted), MAX(DayofMonth) FROM mytable GROUP BY Dest, OriginStateName TOP 29"}
+{"hsqls":["SELECT DestAirportID, COUNT(DivArrDelay) FROM mytable GROUP BY DestAirportID LIMIT 10000","SELECT DestAirportID, MAX(Cancelled) FROM mytable GROUP BY DestAirportID LIMIT 10000","SELECT DestAirportID, MAX(OriginStateFips) FROM mytable GROUP BY DestAirportID LIMIT 10000"],"pql":"SELECT COUNT(DivArrDelay), MAX(Cancelled), MAX(OriginStateFips) FROM mytable GROUP BY DestAirportID TOP 11"}
+{"hsqls":["SELECT DestAirportSeqID, CancellationCode, COUNT(Quarter) FROM mytable GROUP BY DestAirportSeqID, CancellationCode LIMIT 10000","SELECT DestAirportSeqID, CancellationCode, AVG(CAST(DepTime AS DOUBLE)) FROM mytable GROUP BY DestAirportSeqID, CancellationCode LIMIT 10000","SELECT DestAirportSeqID, CancellationCode, SUM(DestStateFips) FROM mytable GROUP BY DestAirportSeqID, CancellationCode LIMIT 10000"],"pql":"SELECT COUNT(Quarter), AVG(DepTime), SUM(DestStateFips) FROM mytable [...]
+{"hsqls":["SELECT DestAirportSeqID, DepTimeBlk, COUNT(*) FROM mytable GROUP BY DestAirportSeqID, DepTimeBlk LIMIT 10000"],"pql":"SELECT COUNT(*) FROM mytable GROUP BY DestAirportSeqID, DepTimeBlk TOP 25"}
+{"hsqls":["SELECT DestAirportSeqID, DestStateName, DivAirportLandings, COUNT(*) FROM mytable GROUP BY DestAirportSeqID, DestStateName, DivAirportLandings LIMIT 10000"],"pql":"SELECT COUNT(*) FROM mytable GROUP BY DestAirportSeqID, DestStateName, DivAirportLandings TOP 17"}
+{"hsqls":["SELECT DestStateFips, TotalAddGTime, Month, COUNT(TaxiOut) FROM mytable GROUP BY DestStateFips, TotalAddGTime, Month LIMIT 10000","SELECT DestStateFips, TotalAddGTime, Month, COUNT(DestStateName) FROM mytable GROUP BY DestStateFips, TotalAddGTime, Month LIMIT 10000","SELECT DestStateFips, TotalAddGTime, Month, MIN(FirstDepTime) FROM mytable GROUP BY DestStateFips, TotalAddGTime, Month LIMIT 10000"],"pql":"SELECT COUNT(TaxiOut), COUNT(DestStateName), MIN(FirstDepTime) FROM myta [...]
+{"hsqls":["SELECT DestStateName, DestCityMarketID, COUNT(Carrier) FROM mytable GROUP BY DestStateName, DestCityMarketID LIMIT 10000","SELECT DestStateName, DestCityMarketID, COUNT(TaxiOut) FROM mytable GROUP BY DestStateName, DestCityMarketID LIMIT 10000","SELECT DestStateName, DestCityMarketID, SUM(Year) FROM mytable GROUP BY DestStateName, DestCityMarketID LIMIT 10000"],"pql":"SELECT COUNT(Carrier), COUNT(TaxiOut), SUM(Year) FROM mytable GROUP BY DestStateName, DestCityMarketID TOP 2"}
+{"hsqls":["SELECT DestWac, NASDelay, COUNT(Carrier) FROM mytable GROUP BY DestWac, NASDelay LIMIT 10000","SELECT DestWac, NASDelay, AVG(CAST(DayofMonth AS DOUBLE)) FROM mytable GROUP BY DestWac, NASDelay LIMIT 10000"],"pql":"SELECT COUNT(Carrier), AVG(DayofMonth) FROM mytable GROUP BY DestWac, NASDelay TOP 12"}
+{"hsqls":["SELECT DestWac, Quarter, OriginCityName, COUNT(DepDelay) FROM mytable GROUP BY DestWac, Quarter, OriginCityName LIMIT 10000","SELECT DestWac, Quarter, OriginCityName, COUNT(Diverted) FROM mytable GROUP BY DestWac, Quarter, OriginCityName LIMIT 10000","SELECT DestWac, Quarter, OriginCityName, COUNT(CarrierDelay) FROM mytable GROUP BY DestWac, Quarter, OriginCityName LIMIT 10000"],"pql":"SELECT COUNT(DepDelay), COUNT(Diverted), COUNT(CarrierDelay) FROM mytable GROUP BY DestWac, [...]
+{"hsqls":["SELECT DistanceGroup, ActualElapsedTime, COUNT(*) FROM mytable GROUP BY DistanceGroup, ActualElapsedTime LIMIT 10000"],"pql":"SELECT COUNT(*) FROM mytable GROUP BY DistanceGroup, ActualElapsedTime TOP 1"}
+{"hsqls":["SELECT DistanceGroup, CancellationCode, COUNT(ArrTimeBlk) FROM mytable GROUP BY DistanceGroup, CancellationCode LIMIT 10000","SELECT DistanceGroup, CancellationCode, AVG(CAST(DayofMonth AS DOUBLE)) FROM mytable GROUP BY DistanceGroup, CancellationCode LIMIT 10000","SELECT DistanceGroup, CancellationCode, MIN(ActualElapsedTime) FROM mytable GROUP BY DistanceGroup, CancellationCode LIMIT 10000"],"pql":"SELECT COUNT(ArrTimeBlk), AVG(DayofMonth), MIN(ActualElapsedTime) FROM mytabl [...]
+{"hsqls":["SELECT DivArrDelay, COUNT(Month) FROM mytable GROUP BY DivArrDelay LIMIT 10000","SELECT DivArrDelay, AVG(CAST(WeatherDelay AS DOUBLE)) FROM mytable GROUP BY DivArrDelay LIMIT 10000"],"pql":"SELECT COUNT(Month), AVG(WeatherDelay) FROM mytable GROUP BY DivArrDelay TOP 0"}
+{"hsqls":["SELECT DivDistance, DestAirportSeqID, Origin, COUNT(DestAirportSeqID) FROM mytable GROUP BY DivDistance, DestAirportSeqID, Origin LIMIT 10000","SELECT DivDistance, DestAirportSeqID, Origin, COUNT(Diverted) FROM mytable GROUP BY DivDistance, DestAirportSeqID, Origin LIMIT 10000","SELECT DivDistance, DestAirportSeqID, Origin, MIN(CRSArrTime) FROM mytable GROUP BY DivDistance, DestAirportSeqID, Origin LIMIT 10000"],"pql":"SELECT COUNT(DestAirportSeqID), COUNT(Diverted), MIN(CRSAr [...]
+{"hsqls":["SELECT DivReachedDest, ArrDelayMinutes, COUNT(DayOfWeek) FROM mytable GROUP BY DivReachedDest, ArrDelayMinutes LIMIT 10000","SELECT DivReachedDest, ArrDelayMinutes, COUNT(DivDistance) FROM mytable GROUP BY DivReachedDest, ArrDelayMinutes LIMIT 10000","SELECT DivReachedDest, ArrDelayMinutes, AVG(CAST(CRSArrTime AS DOUBLE)) FROM mytable GROUP BY DivReachedDest, ArrDelayMinutes LIMIT 10000"],"pql":"SELECT COUNT(DayOfWeek), COUNT(DivDistance), AVG(CRSArrTime) FROM mytable GROUP BY [...]
+{"hsqls":["SELECT DivReachedDest, COUNT(DayofMonth) FROM mytable GROUP BY DivReachedDest LIMIT 10000","SELECT DivReachedDest, MAX(AirTime) FROM mytable GROUP BY DivReachedDest LIMIT 10000"],"pql":"SELECT COUNT(DayofMonth), MAX(AirTime) FROM mytable GROUP BY DivReachedDest TOP 7"}
+{"hsqls":["SELECT Diverted, COUNT(Origin) FROM mytable GROUP BY Diverted LIMIT 10000","SELECT Diverted, COUNT(ArrDel15) FROM mytable GROUP BY Diverted LIMIT 10000","SELECT Diverted, COUNT(FlightDate) FROM mytable GROUP BY Diverted LIMIT 10000"],"pql":"SELECT COUNT(Origin), COUNT(ArrDel15), COUNT(FlightDate) FROM mytable GROUP BY Diverted TOP 5"}
+{"hsqls":["SELECT Diverted, WeatherDelay, Dest, COUNT(OriginCityMarketID) FROM mytable GROUP BY Diverted, WeatherDelay, Dest LIMIT 10000","SELECT Diverted, WeatherDelay, Dest, MAX(Distance) FROM mytable GROUP BY Diverted, WeatherDelay, Dest LIMIT 10000"],"pql":"SELECT COUNT(OriginCityMarketID), MAX(Distance) FROM mytable GROUP BY Diverted, WeatherDelay, Dest TOP 5"}
+{"hsqls":["SELECT FirstDepTime, COUNT(TaxiOut) FROM mytable GROUP BY FirstDepTime LIMIT 10000","SELECT FirstDepTime, MIN(CRSArrTime) FROM mytable GROUP BY FirstDepTime LIMIT 10000"],"pql":"SELECT COUNT(TaxiOut), MIN(CRSArrTime) FROM mytable GROUP BY FirstDepTime TOP 6"}
+{"hsqls":["SELECT FirstDepTime, Cancelled, ArrivalDelayGroups, COUNT(OriginAirportID) FROM mytable GROUP BY FirstDepTime, Cancelled, ArrivalDelayGroups LIMIT 10000","SELECT FirstDepTime, Cancelled, ArrivalDelayGroups, COUNT(TaxiOut) FROM mytable GROUP BY FirstDepTime, Cancelled, ArrivalDelayGroups LIMIT 10000","SELECT FirstDepTime, Cancelled, ArrivalDelayGroups, AVG(CAST(AirTime AS DOUBLE)) FROM mytable GROUP BY FirstDepTime, Cancelled, ArrivalDelayGroups LIMIT 10000"],"pql":"SELECT COUN [...]
+{"hsqls":["SELECT FlightDate, COUNT(FirstDepTime) FROM mytable GROUP BY FlightDate LIMIT 10000","SELECT FlightDate, MIN(DaysSinceEpoch) FROM mytable GROUP BY FlightDate LIMIT 10000","SELECT FlightDate, COUNT(OriginState) FROM mytable GROUP BY FlightDate LIMIT 10000"],"pql":"SELECT COUNT(FirstDepTime), MIN(DaysSinceEpoch), COUNT(OriginState) FROM mytable GROUP BY FlightDate TOP 23"}
+{"hsqls":["SELECT Flights, OriginStateName, COUNT(OriginAirportSeqID) FROM mytable GROUP BY Flights, OriginStateName LIMIT 10000","SELECT Flights, OriginStateName, MAX(DistanceGroup) FROM mytable GROUP BY Flights, OriginStateName LIMIT 10000","SELECT Flights, OriginStateName, SUM(CRSElapsedTime) FROM mytable GROUP BY Flights, OriginStateName LIMIT 10000"],"pql":"SELECT COUNT(OriginAirportSeqID), MAX(DistanceGroup), SUM(CRSElapsedTime) FROM mytable GROUP BY Flights, OriginStateName TOP 29"}
+{"hsqls":["SELECT LongestAddGTime, COUNT(TaxiIn) FROM mytable GROUP BY LongestAddGTime LIMIT 10000","SELECT LongestAddGTime, AVG(CAST(FlightNum AS DOUBLE)) FROM mytable GROUP BY LongestAddGTime LIMIT 10000","SELECT LongestAddGTime, MAX(TaxiOut) FROM mytable GROUP BY LongestAddGTime LIMIT 10000"],"pql":"SELECT COUNT(TaxiIn), AVG(FlightNum), MAX(TaxiOut) FROM mytable GROUP BY LongestAddGTime TOP 19"}
+{"hsqls":["SELECT OriginAirportSeqID, ArrTimeBlk, COUNT(*) FROM mytable GROUP BY OriginAirportSeqID, ArrTimeBlk LIMIT 10000"],"pql":"SELECT COUNT(*) FROM mytable GROUP BY OriginAirportSeqID, ArrTimeBlk TOP 26"}
+{"hsqls":["SELECT OriginAirportSeqID, COUNT(OriginCityName) FROM mytable GROUP BY OriginAirportSeqID LIMIT 10000","SELECT OriginAirportSeqID, SUM(OriginStateFips) FROM mytable GROUP BY OriginAirportSeqID LIMIT 10000"],"pql":"SELECT COUNT(OriginCityName), SUM(OriginStateFips) FROM mytable GROUP BY OriginAirportSeqID TOP 12"}
+{"hsqls":["SELECT OriginStateFips, Origin, COUNT(Month) FROM mytable GROUP BY OriginStateFips, Origin LIMIT 10000","SELECT OriginStateFips, Origin, AVG(CAST(FlightNum AS DOUBLE)) FROM mytable GROUP BY OriginStateFips, Origin LIMIT 10000"],"pql":"SELECT COUNT(Month), AVG(FlightNum) FROM mytable GROUP BY OriginStateFips, Origin TOP 11"}
+{"hsqls":["SELECT Quarter, DestAirportID, COUNT(DistanceGroup) FROM mytable GROUP BY Quarter, DestAirportID LIMIT 10000","SELECT Quarter, DestAirportID, MIN(ArrivalDelayGroups) FROM mytable GROUP BY Quarter, DestAirportID LIMIT 10000"],"pql":"SELECT COUNT(DistanceGroup), MIN(ArrivalDelayGroups) FROM mytable GROUP BY Quarter, DestAirportID TOP 4"}
+{"hsqls":["SELECT Quarter, DivAirportLandings, UniqueCarrier, COUNT(DivActualElapsedTime) FROM mytable GROUP BY Quarter, DivAirportLandings, UniqueCarrier LIMIT 10000","SELECT Quarter, DivAirportLandings, UniqueCarrier, MAX(NASDelay) FROM mytable GROUP BY Quarter, DivAirportLandings, UniqueCarrier LIMIT 10000","SELECT Quarter, DivAirportLandings, UniqueCarrier, AVG(CAST(Diverted AS DOUBLE)) FROM mytable GROUP BY Quarter, DivAirportLandings, UniqueCarrier LIMIT 10000"],"pql":"SELECT COUNT [...]
+{"hsqls":["SELECT SecurityDelay, DepTimeBlk, ArrivalDelayGroups, COUNT(*) FROM mytable GROUP BY SecurityDelay, DepTimeBlk, ArrivalDelayGroups LIMIT 10000"],"pql":"SELECT COUNT(*) FROM mytable GROUP BY SecurityDelay, DepTimeBlk, ArrivalDelayGroups TOP 28"}
+{"hsqls":["SELECT SecurityDelay, DivArrDelay, COUNT(OriginAirportSeqID) FROM mytable GROUP BY SecurityDelay, DivArrDelay LIMIT 10000","SELECT SecurityDelay, DivArrDelay, SUM(CRSArrTime) FROM mytable GROUP BY SecurityDelay, DivArrDelay LIMIT 10000","SELECT SecurityDelay, DivArrDelay, AVG(CAST(ArrDelay AS DOUBLE)) FROM mytable GROUP BY SecurityDelay, DivArrDelay LIMIT 10000"],"pql":"SELECT COUNT(OriginAirportSeqID), SUM(CRSArrTime), AVG(ArrDelay) FROM mytable GROUP BY SecurityDelay, DivArr [...]
+{"hsqls":["SELECT TailNum, COUNT(*) FROM mytable GROUP BY TailNum LIMIT 10000"],"pql":"SELECT COUNT(*) FROM mytable GROUP BY TailNum TOP 6"}
+{"hsqls":["SELECT TailNum, COUNT(OriginWac) FROM mytable GROUP BY TailNum LIMIT 10000","SELECT TailNum, SUM(DaysSinceEpoch) FROM mytable GROUP BY TailNum LIMIT 10000","SELECT TailNum, MAX(WeatherDelay) FROM mytable GROUP BY TailNum LIMIT 10000"],"pql":"SELECT COUNT(OriginWac), SUM(DaysSinceEpoch), MAX(WeatherDelay) FROM mytable GROUP BY TailNum TOP 26"}
+{"hsqls":["SELECT TaxiIn, COUNT(DestStateName) FROM mytable GROUP BY TaxiIn LIMIT 10000","SELECT TaxiIn, SUM(OriginAirportSeqID) FROM mytable GROUP BY TaxiIn LIMIT 10000","SELECT TaxiIn, MAX(AirTime) FROM mytable GROUP BY TaxiIn LIMIT 10000"],"pql":"SELECT COUNT(DestStateName), SUM(OriginAirportSeqID), MAX(AirTime) FROM mytable GROUP BY TaxiIn TOP 10"}
+{"hsqls":["SELECT TotalAddGTime, NASDelay, CancellationCode, COUNT(*) FROM mytable GROUP BY TotalAddGTime, NASDelay, CancellationCode LIMIT 10000"],"pql":"SELECT COUNT(*) FROM mytable GROUP BY TotalAddGTime, NASDelay, CancellationCode TOP 16"}
+{"hsqls":["SELECT UniqueCarrier, COUNT(*) FROM mytable GROUP BY UniqueCarrier LIMIT 10000"],"pql":"SELECT COUNT(*) FROM mytable GROUP BY UniqueCarrier TOP 25"}
+{"hsqls":["SELECT WeatherDelay, ArrivalDelayGroups, DivActualElapsedTime, COUNT(*) FROM mytable GROUP BY WeatherDelay, ArrivalDelayGroups, DivActualElapsedTime LIMIT 10000"],"pql":"SELECT COUNT(*) FROM mytable GROUP BY WeatherDelay, ArrivalDelayGroups, DivActualElapsedTime TOP 0"}
+{"hsqls":["SELECT WheelsOff, COUNT(OriginAirportSeqID) FROM mytable GROUP BY WheelsOff LIMIT 10000","SELECT WheelsOff, AVG(CAST(LongestAddGTime AS DOUBLE)) FROM mytable GROUP BY WheelsOff LIMIT 10000","SELECT WheelsOff, MIN(CRSElapsedTime) FROM mytable GROUP BY WheelsOff LIMIT 10000"],"pql":"SELECT COUNT(OriginAirportSeqID), AVG(LongestAddGTime), MIN(CRSElapsedTime) FROM mytable GROUP BY WheelsOff TOP 12"}
+{"hsqls":["SELECT Year, DestState, Flights, COUNT(DistanceGroup) FROM mytable GROUP BY Year, DestState, Flights LIMIT 10000","SELECT Year, DestState, Flights, SUM(DayOfWeek) FROM mytable GROUP BY Year, DestState, Flights LIMIT 10000","SELECT Year, DestState, Flights, MIN(TaxiOut) FROM mytable GROUP BY Year, DestState, Flights LIMIT 10000"],"pql":"SELECT COUNT(DistanceGroup), SUM(DayOfWeek), MIN(TaxiOut) FROM mytable GROUP BY Year, DestState, Flights TOP 14"}
+{"hsqls":["SELECT Year, OriginCityMarketID, COUNT(DestCityMarketID) FROM mytable GROUP BY Year, OriginCityMarketID LIMIT 10000","SELECT Year, OriginCityMarketID, AVG(CAST(DistanceGroup AS DOUBLE)) FROM mytable GROUP BY Year, OriginCityMarketID LIMIT 10000"],"pql":"SELECT COUNT(DestCityMarketID), AVG(DistanceGroup) FROM mytable GROUP BY Year, OriginCityMarketID TOP 5"}
+
+{"hsqls":["SELECT ActualElapsedTime, DepDel15, MAX(OriginAirportID) FROM mytable GROUP BY ActualElapsedTime, DepDel15 LIMIT 10000","SELECT ActualElapsedTime, DepDel15, MAX(FlightNum) FROM mytable GROUP BY ActualElapsedTime, DepDel15 LIMIT 10000"],"pql":"SELECT MAX(OriginAirportID), MAX(FlightNum) FROM mytable GROUP BY ActualElapsedTime, DepDel15 TOP 27"}
+{"hsqls":["SELECT AirTime, MAX(DivDistance) FROM mytable GROUP BY AirTime LIMIT 10000","SELECT AirTime, SUM(DayOfWeek) FROM mytable GROUP BY AirTime LIMIT 10000"],"pql":"SELECT MAX(DivDistance), SUM(DayOfWeek) FROM mytable GROUP BY AirTime TOP 22"}
+{"hsqls":["SELECT AirlineID, MAX(OriginAirportSeqID) FROM mytable GROUP BY AirlineID LIMIT 10000","SELECT AirlineID, MAX(DepartureDelayGroups) FROM mytable GROUP BY AirlineID LIMIT 10000"],"pql":"SELECT MAX(OriginAirportSeqID), MAX(DepartureDelayGroups) FROM mytable GROUP BY AirlineID TOP 7"}
+{"hsqls":["SELECT ArrDelay, DivArrDelay, MAX(Cancelled) FROM mytable GROUP BY ArrDelay, DivArrDelay LIMIT 10000"],"pql":"SELECT MAX(Cancelled) FROM mytable GROUP BY ArrDelay, DivArrDelay TOP 26"}
+{"hsqls":["SELECT ArrDelayMinutes, MAX(DistanceGroup) FROM mytable GROUP BY ArrDelayMinutes LIMIT 10000","SELECT ArrDelayMinutes, MIN(CarrierDelay) FROM mytable GROUP BY ArrDelayMinutes LIMIT 10000"],"pql":"SELECT MAX(DistanceGroup), MIN(CarrierDelay) FROM mytable GROUP BY ArrDelayMinutes TOP 15"}
+{"hsqls":["SELECT ArrTime, MAX(DepTime) FROM mytable GROUP BY ArrTime LIMIT 10000","SELECT ArrTime, SUM(ArrivalDelayGroups) FROM mytable GROUP BY ArrTime LIMIT 10000","SELECT ArrTime, SUM(DepDelayMinutes) FROM mytable GROUP BY ArrTime LIMIT 10000"],"pql":"SELECT MAX(DepTime), SUM(ArrivalDelayGroups), SUM(DepDelayMinutes) FROM mytable GROUP BY ArrTime TOP 24"}
+{"hsqls":["SELECT Carrier, UniqueCarrier, MAX(DivDistance) FROM mytable GROUP BY Carrier, UniqueCarrier LIMIT 10000","SELECT Carrier, UniqueCarrier, AVG(CAST(CarrierDelay AS DOUBLE)) FROM mytable GROUP BY Carrier, UniqueCarrier LIMIT 10000","SELECT Carrier, UniqueCarrier, AVG(CAST(SecurityDelay AS DOUBLE)) FROM mytable GROUP BY Carrier, UniqueCarrier LIMIT 10000"],"pql":"SELECT MAX(DivDistance), AVG(CarrierDelay), AVG(SecurityDelay) FROM mytable GROUP BY Carrier, UniqueCarrier TOP 0"}
+{"hsqls":["SELECT CarrierDelay, MAX(DestCityMarketID) FROM mytable GROUP BY CarrierDelay LIMIT 10000","SELECT CarrierDelay, SUM(DivDistance) FROM mytable GROUP BY CarrierDelay LIMIT 10000","SELECT CarrierDelay, COUNT(DivAirportLandings) FROM mytable GROUP BY CarrierDelay LIMIT 10000"],"pql":"SELECT MAX(DestCityMarketID), SUM(DivDistance), COUNT(DivAirportLandings) FROM mytable GROUP BY CarrierDelay TOP 27"}
+{"hsqls":["SELECT DayofMonth, DivAirportLandings, MAX(WheelsOff) FROM mytable GROUP BY DayofMonth, DivAirportLandings LIMIT 10000","SELECT DayofMonth, DivAirportLandings, MAX(OriginAirportID) FROM mytable GROUP BY DayofMonth, DivAirportLandings LIMIT 10000"],"pql":"SELECT MAX(WheelsOff), MAX(OriginAirportID) FROM mytable GROUP BY DayofMonth, DivAirportLandings TOP 9"}
+{"hsqls":["SELECT DayofMonth, MAX(DestStateFips) FROM mytable GROUP BY DayofMonth LIMIT 10000","SELECT DayofMonth, MIN(DivDistance) FROM mytable GROUP BY DayofMonth LIMIT 10000","SELECT DayofMonth, MAX(LateAircraftDelay) FROM mytable GROUP BY DayofMonth LIMIT 10000"],"pql":"SELECT MAX(DestStateFips), MIN(DivDistance), MAX(LateAircraftDelay) FROM mytable GROUP BY DayofMonth TOP 21"}
+{"hsqls":["SELECT DaysSinceEpoch, MAX(ArrDelayMinutes) FROM mytable GROUP BY DaysSinceEpoch LIMIT 10000"],"pql":"SELECT MAX(ArrDelayMinutes) FROM mytable GROUP BY DaysSinceEpoch TOP 26"}
+{"hsqls":["SELECT DepDel15, MAX(DepDelayMinutes) FROM mytable GROUP BY DepDel15 LIMIT 10000","SELECT DepDel15, SUM(DivArrDelay) FROM mytable GROUP BY DepDel15 LIMIT 10000","SELECT DepDel15, SUM(Quarter) FROM mytable GROUP BY DepDel15 LIMIT 10000"],"pql":"SELECT MAX(DepDelayMinutes), SUM(DivArrDelay), SUM(Quarter) FROM mytable GROUP BY DepDel15 TOP 23"}
+{"hsqls":["SELECT DepDelay, DestStateFips, Cancelled, MAX(TaxiIn) FROM mytable GROUP BY DepDelay, DestStateFips, Cancelled LIMIT 10000"],"pql":"SELECT MAX(TaxiIn) FROM mytable GROUP BY DepDelay, DestStateFips, Cancelled TOP 20"}
+{"hsqls":["SELECT DepTime, MAX(AirlineID) FROM mytable GROUP BY DepTime LIMIT 10000","SELECT DepTime, SUM(WheelsOff) FROM mytable GROUP BY DepTime LIMIT 10000","SELECT DepTime, AVG(CAST(WheelsOn AS DOUBLE)) FROM mytable GROUP BY DepTime LIMIT 10000"],"pql":"SELECT MAX(AirlineID), SUM(WheelsOff), AVG(WheelsOn) FROM mytable GROUP BY DepTime TOP 16"}
+{"hsqls":["SELECT DepTimeBlk, MAX(DepDel15) FROM mytable GROUP BY DepTimeBlk LIMIT 10000","SELECT DepTimeBlk, MIN(Cancelled) FROM mytable GROUP BY DepTimeBlk LIMIT 10000"],"pql":"SELECT MAX(DepDel15), MIN(Cancelled) FROM mytable GROUP BY DepTimeBlk TOP 16"}
+{"hsqls":["SELECT DestCityName, MAX(ArrDel15) FROM mytable GROUP BY DestCityName LIMIT 10000","SELECT DestCityName, COUNT(FlightDate) FROM mytable GROUP BY DestCityName LIMIT 10000"],"pql":"SELECT MAX(ArrDel15), COUNT(FlightDate) FROM mytable GROUP BY DestCityName TOP 27"}
+{"hsqls":["SELECT DivDistance, TaxiIn, MAX(LongestAddGTime) FROM mytable GROUP BY DivDistance, TaxiIn LIMIT 10000","SELECT DivDistance, TaxiIn, AVG(CAST(DaysSinceEpoch AS DOUBLE)) FROM mytable GROUP BY DivDistance, TaxiIn LIMIT 10000","SELECT DivDistance, TaxiIn, MAX(ArrTime) FROM mytable GROUP BY DivDistance, TaxiIn LIMIT 10000"],"pql":"SELECT MAX(LongestAddGTime), AVG(DaysSinceEpoch), MAX(ArrTime) FROM mytable GROUP BY DivDistance, TaxiIn TOP 0"}
+{"hsqls":["SELECT DivReachedDest, ArrivalDelayGroups, MAX(TaxiIn) FROM mytable GROUP BY DivReachedDest, ArrivalDelayGroups LIMIT 10000","SELECT DivReachedDest, ArrivalDelayGroups, AVG(CAST(OriginStateFips AS DOUBLE)) FROM mytable GROUP BY DivReachedDest, ArrivalDelayGroups LIMIT 10000"],"pql":"SELECT MAX(TaxiIn), AVG(OriginStateFips) FROM mytable GROUP BY DivReachedDest, ArrivalDelayGroups TOP 15"}
+{"hsqls":["SELECT DivReachedDest, Distance, MAX(LongestAddGTime) FROM mytable GROUP BY DivReachedDest, Distance LIMIT 10000","SELECT DivReachedDest, Distance, SUM(DestAirportID) FROM mytable GROUP BY DivReachedDest, Distance LIMIT 10000","SELECT DivReachedDest, Distance, SUM(Distance) FROM mytable GROUP BY DivReachedDest, Distance LIMIT 10000"],"pql":"SELECT MAX(LongestAddGTime), SUM(DestAirportID), SUM(Distance) FROM mytable GROUP BY DivReachedDest, Distance TOP 11"}
+{"hsqls":["SELECT Diverted, DestState, DepDel15, MAX(DistanceGroup) FROM mytable GROUP BY Diverted, DestState, DepDel15 LIMIT 10000","SELECT Diverted, DestState, DepDel15, AVG(CAST(FirstDepTime AS DOUBLE)) FROM mytable GROUP BY Diverted, DestState, DepDel15 LIMIT 10000"],"pql":"SELECT MAX(DistanceGroup), AVG(FirstDepTime) FROM mytable GROUP BY Diverted, DestState, DepDel15 TOP 11"}
+{"hsqls":["SELECT Diverted, DestStateFips, MAX(TaxiOut) FROM mytable GROUP BY Diverted, DestStateFips LIMIT 10000","SELECT Diverted, DestStateFips, AVG(CAST(DepTime AS DOUBLE)) FROM mytable GROUP BY Diverted, DestStateFips LIMIT 10000"],"pql":"SELECT MAX(TaxiOut), AVG(DepTime) FROM mytable GROUP BY Diverted, DestStateFips TOP 3"}
+{"hsqls":["SELECT Diverted, Origin, MAX(TaxiOut) FROM mytable GROUP BY Diverted, Origin LIMIT 10000","SELECT Diverted, Origin, COUNT(DepDelayMinutes) FROM mytable GROUP BY Diverted, Origin LIMIT 10000"],"pql":"SELECT MAX(TaxiOut), COUNT(DepDelayMinutes) FROM mytable GROUP BY Diverted, Origin TOP 0"}
+{"hsqls":["SELECT FirstDepTime, ArrDel15, MAX(AirlineID) FROM mytable GROUP BY FirstDepTime, ArrDel15 LIMIT 10000"],"pql":"SELECT MAX(AirlineID) FROM mytable GROUP BY FirstDepTime, ArrDel15 TOP 18"}
+{"hsqls":["SELECT FlightNum, MAX(ArrDel15) FROM mytable GROUP BY FlightNum LIMIT 10000","SELECT FlightNum, SUM(TaxiOut) FROM mytable GROUP BY FlightNum LIMIT 10000","SELECT FlightNum, MAX(TaxiIn) FROM mytable GROUP BY FlightNum LIMIT 10000"],"pql":"SELECT MAX(ArrDel15), SUM(TaxiOut), MAX(TaxiIn) FROM mytable GROUP BY FlightNum"}
+{"hsqls":["SELECT Flights, CRSDepTime, MAX(Flights) FROM mytable GROUP BY Flights, CRSDepTime LIMIT 10000","SELECT Flights, CRSDepTime, SUM(LateAircraftDelay) FROM mytable GROUP BY Flights, CRSDepTime LIMIT 10000","SELECT Flights, CRSDepTime, MAX(SecurityDelay) FROM mytable GROUP BY Flights, CRSDepTime LIMIT 10000"],"pql":"SELECT MAX(Flights), SUM(LateAircraftDelay), MAX(SecurityDelay) FROM mytable GROUP BY Flights, CRSDepTime TOP 8"}
+{"hsqls":["SELECT Flights, TaxiIn, DestCityMarketID, MAX(DaysSinceEpoch) FROM mytable GROUP BY Flights, TaxiIn, DestCityMarketID LIMIT 10000","SELECT Flights, TaxiIn, DestCityMarketID, AVG(CAST(ArrDelayMinutes AS DOUBLE)) FROM mytable GROUP BY Flights, TaxiIn, DestCityMarketID LIMIT 10000","SELECT Flights, TaxiIn, DestCityMarketID, SUM(DepTime) FROM mytable GROUP BY Flights, TaxiIn, DestCityMarketID LIMIT 10000"],"pql":"SELECT MAX(DaysSinceEpoch), AVG(ArrDelayMinutes), SUM(DepTime) FROM [...]
+{"hsqls":["SELECT LateAircraftDelay, MAX(ArrDel15) FROM mytable GROUP BY LateAircraftDelay LIMIT 10000","SELECT LateAircraftDelay, COUNT(ActualElapsedTime) FROM mytable GROUP BY LateAircraftDelay LIMIT 10000","SELECT LateAircraftDelay, MIN(LongestAddGTime) FROM mytable GROUP BY LateAircraftDelay LIMIT 10000"],"pql":"SELECT MAX(ArrDel15), COUNT(ActualElapsedTime), MIN(LongestAddGTime) FROM mytable GROUP BY LateAircraftDelay TOP 17"}
+{"hsqls":["SELECT LongestAddGTime, OriginStateName, MAX(OriginAirportSeqID) FROM mytable GROUP BY LongestAddGTime, OriginStateName LIMIT 10000","SELECT LongestAddGTime, OriginStateName, COUNT(NASDelay) FROM mytable GROUP BY LongestAddGTime, OriginStateName LIMIT 10000","SELECT LongestAddGTime, OriginStateName, AVG(CAST(OriginStateFips AS DOUBLE)) FROM mytable GROUP BY LongestAddGTime, OriginStateName LIMIT 10000"],"pql":"SELECT MAX(OriginAirportSeqID), COUNT(NASDelay), AVG(OriginStateFip [...]
+{"hsqls":["SELECT OriginAirportID, MAX(TaxiIn) FROM mytable GROUP BY OriginAirportID LIMIT 10000","SELECT OriginAirportID, COUNT(DaysSinceEpoch) FROM mytable GROUP BY OriginAirportID LIMIT 10000"],"pql":"SELECT MAX(TaxiIn), COUNT(DaysSinceEpoch) FROM mytable GROUP BY OriginAirportID TOP 8"}
+{"hsqls":["SELECT OriginAirportSeqID, MAX(Flights) FROM mytable GROUP BY OriginAirportSeqID LIMIT 10000","SELECT OriginAirportSeqID, MIN(FlightNum) FROM mytable GROUP BY OriginAirportSeqID LIMIT 10000"],"pql":"SELECT MAX(Flights), MIN(FlightNum) FROM mytable GROUP BY OriginAirportSeqID TOP 8"}
+{"hsqls":["SELECT OriginCityMarketID, ArrTimeBlk, AirlineID, MAX(DestCityMarketID) FROM mytable GROUP BY OriginCityMarketID, ArrTimeBlk, AirlineID LIMIT 10000","SELECT OriginCityMarketID, ArrTimeBlk, AirlineID, MAX(AirTime) FROM mytable GROUP BY OriginCityMarketID, ArrTimeBlk, AirlineID LIMIT 10000"],"pql":"SELECT MAX(DestCityMarketID), MAX(AirTime) FROM mytable GROUP BY OriginCityMarketID, ArrTimeBlk, AirlineID TOP 15"}
+{"hsqls":["SELECT OriginStateFips, DivAirportLandings, MAX(ArrivalDelayGroups) FROM mytable GROUP BY OriginStateFips, DivAirportLandings LIMIT 10000","SELECT OriginStateFips, DivAirportLandings, MAX(CRSElapsedTime) FROM mytable GROUP BY OriginStateFips, DivAirportLandings LIMIT 10000"],"pql":"SELECT MAX(ArrivalDelayGroups), MAX(CRSElapsedTime) FROM mytable GROUP BY OriginStateFips, DivAirportLandings TOP 10"}
+{"hsqls":["SELECT OriginWac, DayOfWeek, MAX(DestAirportID) FROM mytable GROUP BY OriginWac, DayOfWeek LIMIT 10000","SELECT OriginWac, DayOfWeek, MAX(CarrierDelay) FROM mytable GROUP BY OriginWac, DayOfWeek LIMIT 10000"],"pql":"SELECT MAX(DestAirportID), MAX(CarrierDelay) FROM mytable GROUP BY OriginWac, DayOfWeek TOP 16"}
+{"hsqls":["SELECT Quarter, FirstDepTime, OriginStateName, MAX(DepDel15) FROM mytable GROUP BY Quarter, FirstDepTime, OriginStateName LIMIT 10000","SELECT Quarter, FirstDepTime, OriginStateName, SUM(CRSElapsedTime) FROM mytable GROUP BY Quarter, FirstDepTime, OriginStateName LIMIT 10000"],"pql":"SELECT MAX(DepDel15), SUM(CRSElapsedTime) FROM mytable GROUP BY Quarter, FirstDepTime, OriginStateName TOP 2"}
+{"hsqls":["SELECT TaxiOut, MAX(DestStateFips) FROM mytable GROUP BY TaxiOut LIMIT 10000","SELECT TaxiOut, AVG(CAST(DestCityMarketID AS DOUBLE)) FROM mytable GROUP BY TaxiOut LIMIT 10000"],"pql":"SELECT MAX(DestStateFips), AVG(DestCityMarketID) FROM mytable GROUP BY TaxiOut TOP 4"}
+{"hsqls":["SELECT TotalAddGTime, ArrTime, MAX(ArrDelayMinutes) FROM mytable GROUP BY TotalAddGTime, ArrTime LIMIT 10000","SELECT TotalAddGTime, ArrTime, MAX(WeatherDelay) FROM mytable GROUP BY TotalAddGTime, ArrTime LIMIT 10000"],"pql":"SELECT MAX(ArrDelayMinutes), MAX(WeatherDelay) FROM mytable GROUP BY TotalAddGTime, ArrTime TOP 27"}
+{"hsqls":["SELECT TotalAddGTime, MAX(ArrivalDelayGroups) FROM mytable GROUP BY TotalAddGTime LIMIT 10000","SELECT TotalAddGTime, SUM(DestAirportID) FROM mytable GROUP BY TotalAddGTime LIMIT 10000"],"pql":"SELECT MAX(ArrivalDelayGroups), SUM(DestAirportID) FROM mytable GROUP BY TotalAddGTime TOP 29"}
+{"hsqls":["SELECT UniqueCarrier, MAX(DepTime) FROM mytable GROUP BY UniqueCarrier LIMIT 10000","SELECT UniqueCarrier, MAX(DepDel15) FROM mytable GROUP BY UniqueCarrier LIMIT 10000"],"pql":"SELECT MAX(DepTime), MAX(DepDel15) FROM mytable GROUP BY UniqueCarrier TOP 0"}
+{"hsqls":["SELECT UniqueCarrier, MAX(Year) FROM mytable GROUP BY UniqueCarrier LIMIT 10000","SELECT UniqueCarrier, COUNT(OriginState) FROM mytable GROUP BY UniqueCarrier LIMIT 10000","SELECT UniqueCarrier, AVG(CAST(OriginAirportID AS DOUBLE)) FROM mytable GROUP BY UniqueCarrier LIMIT 10000"],"pql":"SELECT MAX(Year), COUNT(OriginState), AVG(OriginAirportID) FROM mytable GROUP BY UniqueCarrier TOP 16"}
+{"hsqls":["SELECT WeatherDelay, Origin, OriginWac, MAX(WheelsOff) FROM mytable GROUP BY WeatherDelay, Origin, OriginWac LIMIT 10000","SELECT WeatherDelay, Origin, OriginWac, MAX(ArrDelayMinutes) FROM mytable GROUP BY WeatherDelay, Origin, OriginWac LIMIT 10000"],"pql":"SELECT MAX(WheelsOff), MAX(ArrDelayMinutes) FROM mytable GROUP BY WeatherDelay, Origin, OriginWac TOP 7"}
+
+{"hsqls":["SELECT AirTime, MIN(AirTime) FROM mytable GROUP BY AirTime LIMIT 10000","SELECT AirTime, MIN(CRSDepTime) FROM mytable GROUP BY AirTime LIMIT 10000","SELECT AirTime, AVG(CAST(ArrDelay AS DOUBLE)) FROM mytable GROUP BY AirTime LIMIT 10000"],"pql":"SELECT MIN(AirTime), MIN(CRSDepTime), AVG(ArrDelay) FROM mytable GROUP BY AirTime TOP 18"}
+{"hsqls":["SELECT AirlineID, MIN(ArrDelayMinutes) FROM mytable GROUP BY AirlineID LIMIT 10000","SELECT AirlineID, AVG(CAST(ActualElapsedTime AS DOUBLE)) FROM mytable GROUP BY AirlineID LIMIT 10000"],"pql":"SELECT MIN(ArrDelayMinutes), AVG(ActualElapsedTime) FROM mytable GROUP BY AirlineID TOP 10"}
+{"hsqls":["SELECT ArrDel15, MIN(DestAirportSeqID) FROM mytable GROUP BY ArrDel15 LIMIT 10000","SELECT ArrDel15, COUNT(Distance) FROM mytable GROUP BY ArrDel15 LIMIT 10000"],"pql":"SELECT MIN(DestAirportSeqID), COUNT(Distance) FROM mytable GROUP BY ArrDel15 TOP 7"}
+{"hsqls":["SELECT ArrTime, MIN(DepDelayMinutes) FROM mytable GROUP BY ArrTime LIMIT 10000","SELECT ArrTime, COUNT(OriginAirportSeqID) FROM mytable GROUP BY ArrTime LIMIT 10000","SELECT ArrTime, MAX(DivReachedDest) FROM mytable GROUP BY ArrTime LIMIT 10000"],"pql":"SELECT MIN(DepDelayMinutes), COUNT(OriginAirportSeqID), MAX(DivReachedDest) FROM mytable GROUP BY ArrTime TOP 7"}
+{"hsqls":["SELECT CancellationCode, ArrivalDelayGroups, MIN(Cancelled) FROM mytable GROUP BY CancellationCode, ArrivalDelayGroups LIMIT 10000","SELECT CancellationCode, ArrivalDelayGroups, SUM(OriginAirportSeqID) FROM mytable GROUP BY CancellationCode, ArrivalDelayGroups LIMIT 10000"],"pql":"SELECT MIN(Cancelled), SUM(OriginAirportSeqID) FROM mytable GROUP BY CancellationCode, ArrivalDelayGroups TOP 25"}
+{"hsqls":["SELECT Cancelled, DestStateName, MIN(DepDel15) FROM mytable GROUP BY Cancelled, DestStateName LIMIT 10000","SELECT Cancelled, DestStateName, MIN(ArrTime) FROM mytable GROUP BY Cancelled, DestStateName LIMIT 10000","SELECT Cancelled, DestStateName, SUM(TaxiIn) FROM mytable GROUP BY Cancelled, DestStateName LIMIT 10000"],"pql":"SELECT MIN(DepDel15), MIN(ArrTime), SUM(TaxiIn) FROM mytable GROUP BY Cancelled, DestStateName TOP 29"}
+{"hsqls":["SELECT Dest, MIN(DivActualElapsedTime) FROM mytable GROUP BY Dest LIMIT 10000","SELECT Dest, MAX(Year) FROM mytable GROUP BY Dest LIMIT 10000","SELECT Dest, COUNT(OriginWac) FROM mytable GROUP BY Dest LIMIT 10000"],"pql":"SELECT MIN(DivActualElapsedTime), MAX(Year), COUNT(OriginWac) FROM mytable GROUP BY Dest TOP 29"}
+{"hsqls":["SELECT DestAirportID, MIN(DepartureDelayGroups) FROM mytable GROUP BY DestAirportID LIMIT 10000","SELECT DestAirportID, COUNT(DivDistance) FROM mytable GROUP BY DestAirportID LIMIT 10000"],"pql":"SELECT MIN(DepartureDelayGroups), COUNT(DivDistance) FROM mytable GROUP BY DestAirportID TOP 6"}
+{"hsqls":["SELECT DestState, MIN(DaysSinceEpoch) FROM mytable GROUP BY DestState LIMIT 10000","SELECT DestState, COUNT(NASDelay) FROM mytable GROUP BY DestState LIMIT 10000","SELECT DestState, COUNT(DepDelayMinutes) FROM mytable GROUP BY DestState LIMIT 10000"],"pql":"SELECT MIN(DaysSinceEpoch), COUNT(NASDelay), COUNT(DepDelayMinutes) FROM mytable GROUP BY DestState TOP 10"}
+{"hsqls":["SELECT DestStateFips, DestCityName, DestAirportID, MIN(AirlineID) FROM mytable GROUP BY DestStateFips, DestCityName, DestAirportID LIMIT 10000"],"pql":"SELECT MIN(AirlineID) FROM mytable GROUP BY DestStateFips, DestCityName, DestAirportID TOP 25"}
+{"hsqls":["SELECT DestWac, OriginStateFips, MIN(ArrDelayMinutes) FROM mytable GROUP BY DestWac, OriginStateFips LIMIT 10000","SELECT DestWac, OriginStateFips, SUM(FirstDepTime) FROM mytable GROUP BY DestWac, OriginStateFips LIMIT 10000","SELECT DestWac, OriginStateFips, MIN(DepDelay) FROM mytable GROUP BY DestWac, OriginStateFips LIMIT 10000"],"pql":"SELECT MIN(ArrDelayMinutes), SUM(FirstDepTime), MIN(DepDelay) FROM mytable GROUP BY DestWac, OriginStateFips TOP 17"}
+{"hsqls":["SELECT Distance, OriginWac, MIN(CRSElapsedTime) FROM mytable GROUP BY Distance, OriginWac LIMIT 10000","SELECT Distance, OriginWac, MIN(FirstDepTime) FROM mytable GROUP BY Distance, OriginWac LIMIT 10000"],"pql":"SELECT MIN(CRSElapsedTime), MIN(FirstDepTime) FROM mytable GROUP BY Distance, OriginWac TOP 24"}
+{"hsqls":["SELECT DistanceGroup, Cancelled, CRSElapsedTime, MIN(DivDistance) FROM mytable GROUP BY DistanceGroup, Cancelled, CRSElapsedTime LIMIT 10000","SELECT DistanceGroup, Cancelled, CRSElapsedTime, MIN(ArrDel15) FROM mytable GROUP BY DistanceGroup, Cancelled, CRSElapsedTime LIMIT 10000"],"pql":"SELECT MIN(DivDistance), MIN(ArrDel15) FROM mytable GROUP BY DistanceGroup, Cancelled, CRSElapsedTime TOP 23"}
+{"hsqls":["SELECT Flights, DestCityMarketID, DivArrDelay, MIN(ArrDelayMinutes) FROM mytable GROUP BY Flights, DestCityMarketID, DivArrDelay LIMIT 10000","SELECT Flights, DestCityMarketID, DivArrDelay, SUM(Month) FROM mytable GROUP BY Flights, DestCityMarketID, DivArrDelay LIMIT 10000","SELECT Flights, DestCityMarketID, DivArrDelay, SUM(Quarter) FROM mytable GROUP BY Flights, DestCityMarketID, DivArrDelay LIMIT 10000"],"pql":"SELECT MIN(ArrDelayMinutes), SUM(Month), SUM(Quarter) FROM myta [...]
+{"hsqls":["SELECT LateAircraftDelay, MIN(Year) FROM mytable GROUP BY LateAircraftDelay LIMIT 10000","SELECT LateAircraftDelay, SUM(DistanceGroup) FROM mytable GROUP BY LateAircraftDelay LIMIT 10000"],"pql":"SELECT MIN(Year), SUM(DistanceGroup) FROM mytable GROUP BY LateAircraftDelay TOP 1"}
+{"hsqls":["SELECT LongestAddGTime, MIN(ActualElapsedTime) FROM mytable GROUP BY LongestAddGTime LIMIT 10000","SELECT LongestAddGTime, AVG(CAST(OriginStateFips AS DOUBLE)) FROM mytable GROUP BY LongestAddGTime LIMIT 10000"],"pql":"SELECT MIN(ActualElapsedTime), AVG(OriginStateFips) FROM mytable GROUP BY LongestAddGTime TOP 16"}
+{"hsqls":["SELECT NASDelay, DayOfWeek, MIN(ActualElapsedTime) FROM mytable GROUP BY NASDelay, DayOfWeek LIMIT 10000"],"pql":"SELECT MIN(ActualElapsedTime) FROM mytable GROUP BY NASDelay, DayOfWeek TOP 1"}
+{"hsqls":["SELECT OriginAirportID, MIN(DivActualElapsedTime) FROM mytable GROUP BY OriginAirportID LIMIT 10000","SELECT OriginAirportID, MIN(LateAircraftDelay) FROM mytable GROUP BY OriginAirportID LIMIT 10000","SELECT OriginAirportID, MAX(ArrDelayMinutes) FROM mytable GROUP BY OriginAirportID LIMIT 10000"],"pql":"SELECT MIN(DivActualElapsedTime), MIN(LateAircraftDelay), MAX(ArrDelayMinutes) FROM mytable GROUP BY OriginAirportID TOP 27"}
+{"hsqls":["SELECT OriginState, MIN(DestAirportID) FROM mytable GROUP BY OriginState LIMIT 10000","SELECT OriginState, MIN(DepartureDelayGroups) FROM mytable GROUP BY OriginState LIMIT 10000"],"pql":"SELECT MIN(DestAirportID), MIN(DepartureDelayGroups) FROM mytable GROUP BY OriginState TOP 14"}
+{"hsqls":["SELECT OriginState, MIN(DestCityMarketID) FROM mytable GROUP BY OriginState LIMIT 10000","SELECT OriginState, MAX(DestCityMarketID) FROM mytable GROUP BY OriginState LIMIT 10000","SELECT OriginState, COUNT(ArrDel15) FROM mytable GROUP BY OriginState LIMIT 10000"],"pql":"SELECT MIN(DestCityMarketID), MAX(DestCityMarketID), COUNT(ArrDel15) FROM mytable GROUP BY OriginState TOP 6"}
+{"hsqls":["SELECT SecurityDelay, MIN(FlightNum) FROM mytable GROUP BY SecurityDelay LIMIT 10000","SELECT SecurityDelay, SUM(DaysSinceEpoch) FROM mytable GROUP BY SecurityDelay LIMIT 10000"],"pql":"SELECT MIN(FlightNum), SUM(DaysSinceEpoch) FROM mytable GROUP BY SecurityDelay TOP 17"}
+{"hsqls":["SELECT TaxiIn, DepDel15, MIN(Year) FROM mytable GROUP BY TaxiIn, DepDel15 LIMIT 10000","SELECT TaxiIn, DepDel15, AVG(CAST(Distance AS DOUBLE)) FROM mytable GROUP BY TaxiIn, DepDel15 LIMIT 10000","SELECT TaxiIn, DepDel15, MIN(CRSArrTime) FROM mytable GROUP BY TaxiIn, DepDel15 LIMIT 10000"],"pql":"SELECT MIN(Year), AVG(Distance), MIN(CRSArrTime) FROM mytable GROUP BY TaxiIn, DepDel15 TOP 24"}
+{"hsqls":["SELECT TaxiIn, MIN(FlightNum) FROM mytable GROUP BY TaxiIn LIMIT 10000","SELECT TaxiIn, AVG(CAST(NASDelay AS DOUBLE)) FROM mytable GROUP BY TaxiIn LIMIT 10000","SELECT TaxiIn, AVG(CAST(LateAircraftDelay AS DOUBLE)) FROM mytable GROUP BY TaxiIn LIMIT 10000"],"pql":"SELECT MIN(FlightNum), AVG(NASDelay), AVG(LateAircraftDelay) FROM mytable GROUP BY TaxiIn TOP 29"}
+{"hsqls":["SELECT TaxiOut, TotalAddGTime, MIN(Diverted) FROM mytable GROUP BY TaxiOut, TotalAddGTime LIMIT 10000","SELECT TaxiOut, TotalAddGTime, AVG(CAST(OriginStateFips AS DOUBLE)) FROM mytable GROUP BY TaxiOut, TotalAddGTime LIMIT 10000"],"pql":"SELECT MIN(Diverted), AVG(OriginStateFips) FROM mytable GROUP BY TaxiOut, TotalAddGTime TOP 26"}
+{"hsqls":["SELECT TotalAddGTime, ArrDelay, MIN(CRSElapsedTime) FROM mytable GROUP BY TotalAddGTime, ArrDelay LIMIT 10000"],"pql":"SELECT MIN(CRSElapsedTime) FROM mytable GROUP BY TotalAddGTime, ArrDelay TOP 4"}
+{"hsqls":["SELECT UniqueCarrier, MIN(Year) FROM mytable GROUP BY UniqueCarrier LIMIT 10000","SELECT UniqueCarrier, COUNT(OriginStateName) FROM mytable GROUP BY UniqueCarrier LIMIT 10000","SELECT UniqueCarrier, SUM(DivActualElapsedTime) FROM mytable GROUP BY UniqueCarrier LIMIT 10000"],"pql":"SELECT MIN(Year), COUNT(OriginStateName), SUM(DivActualElapsedTime) FROM mytable GROUP BY UniqueCarrier TOP 3"}
+{"hsqls":["SELECT WeatherDelay, TotalAddGTime, UniqueCarrier, MIN(ArrDelayMinutes) FROM mytable GROUP BY WeatherDelay, TotalAddGTime, UniqueCarrier LIMIT 10000","SELECT WeatherDelay, TotalAddGTime, UniqueCarrier, AVG(CAST(DepDel15 AS DOUBLE)) FROM mytable GROUP BY WeatherDelay, TotalAddGTime, UniqueCarrier LIMIT 10000","SELECT WeatherDelay, TotalAddGTime, UniqueCarrier, SUM(DestWac) FROM mytable GROUP BY WeatherDelay, TotalAddGTime, UniqueCarrier LIMIT 10000"],"pql":"SELECT MIN(ArrDelayM [...]
+{"hsqls":["SELECT WheelsOff, Flights, DivAirportLandings, MIN(DepDelayMinutes) FROM mytable GROUP BY WheelsOff, Flights, DivAirportLandings LIMIT 10000","SELECT WheelsOff, Flights, DivAirportLandings, MIN(DepDel15) FROM mytable GROUP BY WheelsOff, Flights, DivAirportLandings LIMIT 10000"],"pql":"SELECT MIN(DepDelayMinutes), MIN(DepDel15) FROM mytable GROUP BY WheelsOff, Flights, DivAirportLandings TOP 21"}
+{"hsqls":["SELECT WheelsOn, MIN(Cancelled) FROM mytable GROUP BY WheelsOn LIMIT 10000","SELECT WheelsOn, COUNT(AirTime) FROM mytable GROUP BY WheelsOn LIMIT 10000","SELECT WheelsOn, MAX(ActualElapsedTime) FROM mytable GROUP BY WheelsOn LIMIT 10000"],"pql":"SELECT MIN(Cancelled), COUNT(AirTime), MAX(ActualElapsedTime) FROM mytable GROUP BY WheelsOn TOP 12"}
+{"hsqls":["SELECT WheelsOn, MIN(OriginAirportSeqID) FROM mytable GROUP BY WheelsOn LIMIT 10000","SELECT WheelsOn, SUM(DepDelay) FROM mytable GROUP BY WheelsOn LIMIT 10000","SELECT WheelsOn, SUM(DepartureDelayGroups) FROM mytable GROUP BY WheelsOn LIMIT 10000"],"pql":"SELECT MIN(OriginAirportSeqID), SUM(DepDelay), SUM(DepartureDelayGroups) FROM mytable GROUP BY WheelsOn TOP 6"}
+{"hsqls":["SELECT Year, Cancelled, MIN(ActualElapsedTime) FROM mytable GROUP BY Year, Cancelled LIMIT 10000","SELECT Year, Cancelled, MAX(DayofMonth) FROM mytable GROUP BY Year, Cancelled LIMIT 10000","SELECT Year, Cancelled, MIN(ArrTime) FROM mytable GROUP BY Year, Cancelled LIMIT 10000"],"pql":"SELECT MIN(ActualElapsedTime), MAX(DayofMonth), MIN(ArrTime) FROM mytable GROUP BY Year, Cancelled"}
+{"hsqls":["SELECT Year, DestStateName, MIN(CRSDepTime) FROM mytable GROUP BY Year, DestStateName LIMIT 10000","SELECT Year, DestStateName, AVG(CAST(TaxiIn AS DOUBLE)) FROM mytable GROUP BY Year, DestStateName LIMIT 10000"],"pql":"SELECT MIN(CRSDepTime), AVG(TaxiIn) FROM mytable GROUP BY Year, DestStateName TOP 10"}
+
+{"hsqls":["SELECT ActualElapsedTime, DestStateName, DivAirportLandings, SUM(DivReachedDest) FROM mytable GROUP BY ActualElapsedTime, DestStateName, DivAirportLandings LIMIT 10000","SELECT ActualElapsedTime, DestStateName, DivAirportLandings, COUNT(WheelsOff) FROM mytable GROUP BY ActualElapsedTime, DestStateName, DivAirportLandings LIMIT 10000"],"pql":"SELECT SUM(DivReachedDest), COUNT(WheelsOff) FROM mytable GROUP BY ActualElapsedTime, DestStateName, DivAirportLandings TOP 24"}
+{"hsqls":["SELECT ActualElapsedTime, SUM(TotalAddGTime) FROM mytable GROUP BY ActualElapsedTime LIMIT 10000","SELECT ActualElapsedTime, MAX(DivReachedDest) FROM mytable GROUP BY ActualElapsedTime LIMIT 10000","SELECT ActualElapsedTime, AVG(CAST(ArrDelay AS DOUBLE)) FROM mytable GROUP BY ActualElapsedTime LIMIT 10000"],"pql":"SELECT SUM(TotalAddGTime), MAX(DivReachedDest), AVG(ArrDelay) FROM mytable GROUP BY ActualElapsedTime TOP 1"}
+{"hsqls":["SELECT AirTime, SUM(WeatherDelay) FROM mytable GROUP BY AirTime LIMIT 10000","SELECT AirTime, AVG(CAST(Quarter AS DOUBLE)) FROM mytable GROUP BY AirTime LIMIT 10000"],"pql":"SELECT SUM(WeatherDelay), AVG(Quarter) FROM mytable GROUP BY AirTime TOP 11"}
+{"hsqls":["SELECT AirlineID, SUM(DistanceGroup) FROM mytable GROUP BY AirlineID LIMIT 10000","SELECT AirlineID, MIN(DestAirportSeqID) FROM mytable GROUP BY AirlineID LIMIT 10000"],"pql":"SELECT SUM(DistanceGroup), MIN(DestAirportSeqID) FROM mytable GROUP BY AirlineID TOP 21"}
+{"hsqls":["SELECT ArrDelayMinutes, DivAirportLandings, SUM(DistanceGroup) FROM mytable GROUP BY ArrDelayMinutes, DivAirportLandings LIMIT 10000","SELECT ArrDelayMinutes, DivAirportLandings, COUNT(AirTime) FROM mytable GROUP BY ArrDelayMinutes, DivAirportLandings LIMIT 10000"],"pql":"SELECT SUM(DistanceGroup), COUNT(AirTime) FROM mytable GROUP BY ArrDelayMinutes, DivAirportLandings TOP 29"}
+{"hsqls":["SELECT ArrivalDelayGroups, SUM(FirstDepTime) FROM mytable GROUP BY ArrivalDelayGroups LIMIT 10000","SELECT ArrivalDelayGroups, MIN(DivAirportLandings) FROM mytable GROUP BY ArrivalDelayGroups LIMIT 10000"],"pql":"SELECT SUM(FirstDepTime), MIN(DivAirportLandings) FROM mytable GROUP BY ArrivalDelayGroups TOP 10"}
+{"hsqls":["SELECT Cancelled, SUM(DepDel15) FROM mytable GROUP BY Cancelled LIMIT 10000","SELECT Cancelled, MIN(DivDistance) FROM mytable GROUP BY Cancelled LIMIT 10000"],"pql":"SELECT SUM(DepDel15), MIN(DivDistance) FROM mytable GROUP BY Cancelled TOP 5"}
+{"hsqls":["SELECT Carrier, Flights, DestCityMarketID, SUM(DepDelay) FROM mytable GROUP BY Carrier, Flights, DestCityMarketID LIMIT 10000"],"pql":"SELECT SUM(DepDelay) FROM mytable GROUP BY Carrier, Flights, DestCityMarketID TOP 13"}
+{"hsqls":["SELECT DayofMonth, CancellationCode, Month, SUM(TaxiOut) FROM mytable GROUP BY DayofMonth, CancellationCode, Month LIMIT 10000","SELECT DayofMonth, CancellationCode, Month, SUM(FlightNum) FROM mytable GROUP BY DayofMonth, CancellationCode, Month LIMIT 10000"],"pql":"SELECT SUM(TaxiOut), SUM(FlightNum) FROM mytable GROUP BY DayofMonth, CancellationCode, Month TOP 19"}
+{"hsqls":["SELECT DaysSinceEpoch, SUM(DepTime) FROM mytable GROUP BY DaysSinceEpoch LIMIT 10000"],"pql":"SELECT SUM(DepTime) FROM mytable GROUP BY DaysSinceEpoch TOP 18"}
+{"hsqls":["SELECT DepDelayMinutes, SUM(DivAirportLandings) FROM mytable GROUP BY DepDelayMinutes LIMIT 10000","SELECT DepDelayMinutes, MIN(OriginAirportID) FROM mytable GROUP BY DepDelayMinutes LIMIT 10000","SELECT DepDelayMinutes, COUNT(AirlineID) FROM mytable GROUP BY DepDelayMinutes LIMIT 10000"],"pql":"SELECT SUM(DivAirportLandings), MIN(OriginAirportID), COUNT(AirlineID) FROM mytable GROUP BY DepDelayMinutes TOP 4"}
+{"hsqls":["SELECT DepTimeBlk, SUM(TaxiOut) FROM mytable GROUP BY DepTimeBlk LIMIT 10000","SELECT DepTimeBlk, SUM(DivDistance) FROM mytable GROUP BY DepTimeBlk LIMIT 10000"],"pql":"SELECT SUM(TaxiOut), SUM(DivDistance) FROM mytable GROUP BY DepTimeBlk TOP 25"}
+{"hsqls":["SELECT DepartureDelayGroups, DestStateName, SUM(WheelsOff) FROM mytable GROUP BY DepartureDelayGroups, DestStateName LIMIT 10000"],"pql":"SELECT SUM(WheelsOff) FROM mytable GROUP BY DepartureDelayGroups, DestStateName TOP 21"}
+{"hsqls":["SELECT Dest, SUM(ArrDel15) FROM mytable GROUP BY Dest LIMIT 10000","SELECT Dest, AVG(CAST(TaxiOut AS DOUBLE)) FROM mytable GROUP BY Dest LIMIT 10000","SELECT Dest, COUNT(AirTime) FROM mytable GROUP BY Dest LIMIT 10000"],"pql":"SELECT SUM(ArrDel15), AVG(TaxiOut), COUNT(AirTime) FROM mytable GROUP BY Dest TOP 21"}
+{"hsqls":["SELECT DestStateFips, ArrDelay, SUM(DaysSinceEpoch) FROM mytable GROUP BY DestStateFips, ArrDelay LIMIT 10000"],"pql":"SELECT SUM(DaysSinceEpoch) FROM mytable GROUP BY DestStateFips, ArrDelay TOP 24"}
+{"hsqls":["SELECT DestWac, DayofMonth, SUM(DestAirportSeqID) FROM mytable GROUP BY DestWac, DayofMonth LIMIT 10000","SELECT DestWac, DayofMonth, MIN(DivDistance) FROM mytable GROUP BY DestWac, DayofMonth LIMIT 10000"],"pql":"SELECT SUM(DestAirportSeqID), MIN(DivDistance) FROM mytable GROUP BY DestWac, DayofMonth TOP 8"}
+{"hsqls":["SELECT DistanceGroup, TotalAddGTime, CRSDepTime, SUM(NASDelay) FROM mytable GROUP BY DistanceGroup, TotalAddGTime, CRSDepTime LIMIT 10000","SELECT DistanceGroup, TotalAddGTime, CRSDepTime, COUNT(DestAirportID) FROM mytable GROUP BY DistanceGroup, TotalAddGTime, CRSDepTime LIMIT 10000","SELECT DistanceGroup, TotalAddGTime, CRSDepTime, SUM(ArrDelay) FROM mytable GROUP BY DistanceGroup, TotalAddGTime, CRSDepTime LIMIT 10000"],"pql":"SELECT SUM(NASDelay), COUNT(DestAirportID), SUM [...]
+{"hsqls":["SELECT DivActualElapsedTime, SUM(WheelsOff) FROM mytable GROUP BY DivActualElapsedTime LIMIT 10000"],"pql":"SELECT SUM(WheelsOff) FROM mytable GROUP BY DivActualElapsedTime TOP 22"}
+{"hsqls":["SELECT DivArrDelay, SUM(DayofMonth) FROM mytable GROUP BY DivArrDelay LIMIT 10000"],"pql":"SELECT SUM(DayofMonth) FROM mytable GROUP BY DivArrDelay TOP 12"}
+{"hsqls":["SELECT DivDistance, AirlineID, DayOfWeek, SUM(DayOfWeek) FROM mytable GROUP BY DivDistance, AirlineID, DayOfWeek LIMIT 10000","SELECT DivDistance, AirlineID, DayOfWeek, MAX(OriginStateFips) FROM mytable GROUP BY DivDistance, AirlineID, DayOfWeek LIMIT 10000","SELECT DivDistance, AirlineID, DayOfWeek, MAX(ActualElapsedTime) FROM mytable GROUP BY DivDistance, AirlineID, DayOfWeek LIMIT 10000"],"pql":"SELECT SUM(DayOfWeek), MAX(OriginStateFips), MAX(ActualElapsedTime) FROM mytabl [...]
+{"hsqls":["SELECT DivReachedDest, SUM(DivAirportLandings) FROM mytable GROUP BY DivReachedDest LIMIT 10000","SELECT DivReachedDest, MAX(DayofMonth) FROM mytable GROUP BY DivReachedDest LIMIT 10000","SELECT DivReachedDest, MAX(OriginStateFips) FROM mytable GROUP BY DivReachedDest LIMIT 10000"],"pql":"SELECT SUM(DivAirportLandings), MAX(DayofMonth), MAX(OriginStateFips) FROM mytable GROUP BY DivReachedDest TOP 10"}
+{"hsqls":["SELECT Diverted, Distance, SUM(ArrDelay) FROM mytable GROUP BY Diverted, Distance LIMIT 10000"],"pql":"SELECT SUM(ArrDelay) FROM mytable GROUP BY Diverted, Distance TOP 21"}
+{"hsqls":["SELECT FirstDepTime, DivAirportLandings, DivArrDelay, SUM(DepartureDelayGroups) FROM mytable GROUP BY FirstDepTime, DivAirportLandings, DivArrDelay LIMIT 10000"],"pql":"SELECT SUM(DepartureDelayGroups) FROM mytable GROUP BY FirstDepTime, DivAirportLandings, DivArrDelay TOP 16"}
+{"hsqls":["SELECT FlightNum, CancellationCode, SUM(DayOfWeek) FROM mytable GROUP BY FlightNum, CancellationCode LIMIT 10000"],"pql":"SELECT SUM(DayOfWeek) FROM mytable GROUP BY FlightNum, CancellationCode TOP 22"}
+{"hsqls":["SELECT Flights, SUM(Month) FROM mytable GROUP BY Flights LIMIT 10000","SELECT Flights, MIN(DistanceGroup) FROM mytable GROUP BY Flights LIMIT 10000","SELECT Flights, MIN(Cancelled) FROM mytable GROUP BY Flights LIMIT 10000"],"pql":"SELECT SUM(Month), MIN(DistanceGroup), MIN(Cancelled) FROM mytable GROUP BY Flights TOP 17"}
+{"hsqls":["SELECT LateAircraftDelay, SecurityDelay, DestAirportID, SUM(CarrierDelay) FROM mytable GROUP BY LateAircraftDelay, SecurityDelay, DestAirportID LIMIT 10000","SELECT LateAircraftDelay, SecurityDelay, DestAirportID, AVG(CAST(NASDelay AS DOUBLE)) FROM mytable GROUP BY LateAircraftDelay, SecurityDelay, DestAirportID LIMIT 10000","SELECT LateAircraftDelay, SecurityDelay, DestAirportID, SUM(DepDelayMinutes) FROM mytable GROUP BY LateAircraftDelay, SecurityDelay, DestAirportID LIMIT [...]
+{"hsqls":["SELECT LongestAddGTime, DestCityMarketID, OriginAirportID, SUM(LongestAddGTime) FROM mytable GROUP BY LongestAddGTime, DestCityMarketID, OriginAirportID LIMIT 10000","SELECT LongestAddGTime, DestCityMarketID, OriginAirportID, COUNT(AirTime) FROM mytable GROUP BY LongestAddGTime, DestCityMarketID, OriginAirportID LIMIT 10000","SELECT LongestAddGTime, DestCityMarketID, OriginAirportID, MAX(Distance) FROM mytable GROUP BY LongestAddGTime, DestCityMarketID, OriginAirportID LIMIT 1 [...]
+{"hsqls":["SELECT Month, SUM(DepDelayMinutes) FROM mytable GROUP BY Month LIMIT 10000","SELECT Month, SUM(ActualElapsedTime) FROM mytable GROUP BY Month LIMIT 10000"],"pql":"SELECT SUM(DepDelayMinutes), SUM(ActualElapsedTime) FROM mytable GROUP BY Month TOP 11"}
+{"hsqls":["SELECT NASDelay, SUM(CRSElapsedTime) FROM mytable GROUP BY NASDelay LIMIT 10000","SELECT NASDelay, AVG(CAST(DepDelayMinutes AS DOUBLE)) FROM mytable GROUP BY NASDelay LIMIT 10000"],"pql":"SELECT SUM(CRSElapsedTime), AVG(DepDelayMinutes) FROM mytable GROUP BY NASDelay"}
+{"hsqls":["SELECT OriginAirportSeqID, FirstDepTime, CarrierDelay, SUM(OriginAirportSeqID) FROM mytable GROUP BY OriginAirportSeqID, FirstDepTime, CarrierDelay LIMIT 10000","SELECT OriginAirportSeqID, FirstDepTime, CarrierDelay, AVG(CAST(Flights AS DOUBLE)) FROM mytable GROUP BY OriginAirportSeqID, FirstDepTime, CarrierDelay LIMIT 10000","SELECT OriginAirportSeqID, FirstDepTime, CarrierDelay, COUNT(WeatherDelay) FROM mytable GROUP BY OriginAirportSeqID, FirstDepTime, CarrierDelay LIMIT 10 [...]
+{"hsqls":["SELECT OriginCityMarketID, SUM(AirTime) FROM mytable GROUP BY OriginCityMarketID LIMIT 10000","SELECT OriginCityMarketID, MAX(DestCityMarketID) FROM mytable GROUP BY OriginCityMarketID LIMIT 10000","SELECT OriginCityMarketID, MIN(AirlineID) FROM mytable GROUP BY OriginCityMarketID LIMIT 10000"],"pql":"SELECT SUM(AirTime), MAX(DestCityMarketID), MIN(AirlineID) FROM mytable GROUP BY OriginCityMarketID TOP 16"}
+{"hsqls":["SELECT OriginCityName, CancellationCode, SUM(LateAircraftDelay) FROM mytable GROUP BY OriginCityName, CancellationCode LIMIT 10000","SELECT OriginCityName, CancellationCode, SUM(TaxiOut) FROM mytable GROUP BY OriginCityName, CancellationCode LIMIT 10000","SELECT OriginCityName, CancellationCode, SUM(CRSElapsedTime) FROM mytable GROUP BY OriginCityName, CancellationCode LIMIT 10000"],"pql":"SELECT SUM(LateAircraftDelay), SUM(TaxiOut), SUM(CRSElapsedTime) FROM mytable GROUP BY O [...]
+{"hsqls":["SELECT OriginState, DestWac, SUM(TotalAddGTime) FROM mytable GROUP BY OriginState, DestWac LIMIT 10000","SELECT OriginState, DestWac, COUNT(NASDelay) FROM mytable GROUP BY OriginState, DestWac LIMIT 10000","SELECT OriginState, DestWac, SUM(WheelsOff) FROM mytable GROUP BY OriginState, DestWac LIMIT 10000"],"pql":"SELECT SUM(TotalAddGTime), COUNT(NASDelay), SUM(WheelsOff) FROM mytable GROUP BY OriginState, DestWac TOP 12"}
+{"hsqls":["SELECT OriginStateFips, LateAircraftDelay, NASDelay, SUM(DivArrDelay) FROM mytable GROUP BY OriginStateFips, LateAircraftDelay, NASDelay LIMIT 10000","SELECT OriginStateFips, LateAircraftDelay, NASDelay, MIN(CRSElapsedTime) FROM mytable GROUP BY OriginStateFips, LateAircraftDelay, NASDelay LIMIT 10000"],"pql":"SELECT SUM(DivArrDelay), MIN(CRSElapsedTime) FROM mytable GROUP BY OriginStateFips, LateAircraftDelay, NASDelay TOP 29"}
+{"hsqls":["SELECT OriginWac, SUM(DivAirportLandings) FROM mytable GROUP BY OriginWac LIMIT 10000","SELECT OriginWac, MAX(TaxiIn) FROM mytable GROUP BY OriginWac LIMIT 10000","SELECT OriginWac, MAX(OriginAirportID) FROM mytable GROUP BY OriginWac LIMIT 10000"],"pql":"SELECT SUM(DivAirportLandings), MAX(TaxiIn), MAX(OriginAirportID) FROM mytable GROUP BY OriginWac TOP 21"}
+{"hsqls":["SELECT Quarter, CRSDepTime, SUM(DivAirportLandings) FROM mytable GROUP BY Quarter, CRSDepTime LIMIT 10000","SELECT Quarter, CRSDepTime, COUNT(TaxiOut) FROM mytable GROUP BY Quarter, CRSDepTime LIMIT 10000","SELECT Quarter, CRSDepTime, AVG(CAST(Cancelled AS DOUBLE)) FROM mytable GROUP BY Quarter, CRSDepTime LIMIT 10000"],"pql":"SELECT SUM(DivAirportLandings), COUNT(TaxiOut), AVG(Cancelled) FROM mytable GROUP BY Quarter, CRSDepTime TOP 20"}
+{"hsqls":["SELECT Quarter, DayOfWeek, SUM(TaxiIn) FROM mytable GROUP BY Quarter, DayOfWeek LIMIT 10000","SELECT Quarter, DayOfWeek, MAX(ActualElapsedTime) FROM mytable GROUP BY Quarter, DayOfWeek LIMIT 10000","SELECT Quarter, DayOfWeek, SUM(DivDistance) FROM mytable GROUP BY Quarter, DayOfWeek LIMIT 10000"],"pql":"SELECT SUM(TaxiIn), MAX(ActualElapsedTime), SUM(DivDistance) FROM mytable GROUP BY Quarter, DayOfWeek TOP 6"}
+{"hsqls":["SELECT TailNum, SUM(AirTime) FROM mytable GROUP BY TailNum LIMIT 10000","SELECT TailNum, MAX(Diverted) FROM mytable GROUP BY TailNum LIMIT 10000","SELECT TailNum, MIN(DayofMonth) FROM mytable GROUP BY TailNum LIMIT 10000"],"pql":"SELECT SUM(AirTime), MAX(Diverted), MIN(DayofMonth) FROM mytable GROUP BY TailNum TOP 12"}
+{"hsqls":["SELECT TailNum, SUM(ArrDelayMinutes) FROM mytable GROUP BY TailNum LIMIT 10000","SELECT TailNum, MIN(DepartureDelayGroups) FROM mytable GROUP BY TailNum LIMIT 10000","SELECT TailNum, COUNT(LongestAddGTime) FROM mytable GROUP BY TailNum LIMIT 10000"],"pql":"SELECT SUM(ArrDelayMinutes), MIN(DepartureDelayGroups), COUNT(LongestAddGTime) FROM mytable GROUP BY TailNum TOP 1"}
+{"hsqls":["SELECT TaxiOut, UniqueCarrier, SUM(WheelsOn) FROM mytable GROUP BY TaxiOut, UniqueCarrier LIMIT 10000","SELECT TaxiOut, UniqueCarrier, AVG(CAST(DestWac AS DOUBLE)) FROM mytable GROUP BY TaxiOut, UniqueCarrier LIMIT 10000"],"pql":"SELECT SUM(WheelsOn), AVG(DestWac) FROM mytable GROUP BY TaxiOut, UniqueCarrier TOP 20"}
+{"hsqls":["SELECT TotalAddGTime, SUM(ArrivalDelayGroups) FROM mytable GROUP BY TotalAddGTime LIMIT 10000","SELECT TotalAddGTime, MAX(Month) FROM mytable GROUP BY TotalAddGTime LIMIT 10000"],"pql":"SELECT SUM(ArrivalDelayGroups), MAX(Month) FROM mytable GROUP BY TotalAddGTime TOP 24"}
+{"hsqls":["SELECT WeatherDelay, CancellationCode, DivArrDelay, SUM(ArrDel15) FROM mytable GROUP BY WeatherDelay, CancellationCode, DivArrDelay LIMIT 10000","SELECT WeatherDelay, CancellationCode, DivArrDelay, MIN(DepDelay) FROM mytable GROUP BY WeatherDelay, CancellationCode, DivArrDelay LIMIT 10000"],"pql":"SELECT SUM(ArrDel15), MIN(DepDelay) FROM mytable GROUP BY WeatherDelay, CancellationCode, DivArrDelay TOP 23"}
+{"hsqls":["SELECT WheelsOff, SUM(ActualElapsedTime) FROM mytable GROUP BY WheelsOff LIMIT 10000","SELECT WheelsOff, AVG(CAST(DepDelayMinutes AS DOUBLE)) FROM mytable GROUP BY WheelsOff LIMIT 10000"],"pql":"SELECT SUM(ActualElapsedTime), AVG(DepDelayMinutes) FROM mytable GROUP BY WheelsOff TOP 29"}
+{"hsqls":["SELECT WheelsOn, DayOfWeek, SUM(FirstDepTime) FROM mytable GROUP BY WheelsOn, DayOfWeek LIMIT 10000","SELECT WheelsOn, DayOfWeek, COUNT(DayOfWeek) FROM mytable GROUP BY WheelsOn, DayOfWeek LIMIT 10000","SELECT WheelsOn, DayOfWeek, MAX(DayOfWeek) FROM mytable GROUP BY WheelsOn, DayOfWeek LIMIT 10000"],"pql":"SELECT SUM(FirstDepTime), COUNT(DayOfWeek), MAX(DayOfWeek) FROM mytable GROUP BY WheelsOn, DayOfWeek TOP 1"}
+{"hsqls":["SELECT Year, SecurityDelay, DivAirportLandings, SUM(DestCityMarketID) FROM mytable GROUP BY Year, SecurityDelay, DivAirportLandings LIMIT 10000"],"pql":"SELECT SUM(DestCityMarketID) FROM mytable GROUP BY Year, SecurityDelay, DivAirportLandings TOP 22"}
+
+
+# Filtering on Aggregation
+{"hsqls":["SELECT WeatherDelay, COUNT(*) FROM mytable WHERE TailNum NOT IN ('N937WN', 'N905WN', 'N477WN') OR DestStateFips BETWEEN 12 AND 31 AND ArrTime BETWEEN 1258 AND 806 GROUP BY WeatherDelay LIMIT 10000"],"pql":"SELECT COUNT(*) FROM mytable WHERE TailNum NOT IN ('N937WN', 'N905WN', 'N477WN') OR DestStateFips BETWEEN 12 AND 31 AND ArrTime BETWEEN 1258 AND 806 GROUP BY WeatherDelay TOP 16"}
+{"hsqls":["SELECT SUM(TotalAddGTime) FROM mytable WHERE AirTime > 202 AND DestStateName BETWEEN 'Louisiana' AND 'Alaska' LIMIT 10000"],"pql":"SELECT SUM(TotalAddGTime) FROM mytable WHERE AirTime > 202 AND DestStateName BETWEEN 'Louisiana' AND 'Alaska' TOP 7"}
+{"hsqls":["SELECT AVG(CAST(AirTime AS DOUBLE)) FROM mytable WHERE (DivTailNums__MV0 BETWEEN 'N8315C' AND 'N130DL' OR DivTailNums__MV1 BETWEEN 'N8315C' AND 'N130DL' OR DivTailNums__MV2 BETWEEN 'N8315C' AND 'N130DL' OR DivTailNums__MV3 BETWEEN 'N8315C' AND 'N130DL' OR DivTailNums__MV4 BETWEEN 'N8315C' AND 'N130DL') OR (DivAirports__MV0 IN ('PIH', 'DLH', 'MTJ', 'SEA', 'LIT') OR DivAirports__MV1 IN ('PIH', 'DLH', 'MTJ', 'SEA', 'LIT') OR DivAirports__MV2 IN ('PIH', 'DLH', 'MTJ', 'SEA', 'LIT') [...]
+{"hsqls":["SELECT AVG(CAST(ArrivalDelayGroups AS DOUBLE)) FROM mytable WHERE DayofMonth >= 5 OR AirTime <= 368 OR Flights BETWEEN 1 AND 1 LIMIT 10000","SELECT SUM(DistanceGroup) FROM mytable WHERE DayofMonth >= 5 OR AirTime <= 368 OR Flights BETWEEN 1 AND 1 LIMIT 10000","SELECT MAX(DayofMonth) FROM mytable WHERE DayofMonth >= 5 OR AirTime <= 368 OR Flights BETWEEN 1 AND 1 LIMIT 10000"],"pql":"SELECT AVG(ArrivalDelayGroups), SUM(DistanceGroup), MAX(DayofMonth) FROM mytable WHERE DayofMont [...]
+{"hsqls":["SELECT AVG(CAST(CRSDepTime AS DOUBLE)) FROM mytable WHERE CancellationCode IN ('C') AND DestWac = 86 LIMIT 10000","SELECT MIN(DepartureDelayGroups) FROM mytable WHERE CancellationCode IN ('C') AND DestWac = 86 LIMIT 10000","SELECT SUM(ArrTime) FROM mytable WHERE CancellationCode IN ('C') AND DestWac = 86 LIMIT 10000"],"pql":"SELECT AVG(CRSDepTime), MIN(DepartureDelayGroups), SUM(ArrTime) FROM mytable WHERE CancellationCode IN ('C') AND DestWac = 86 TOP 16"}
+{"hsqls":["SELECT AVG(CAST(CRSElapsedTime AS DOUBLE)) FROM mytable WHERE OriginStateFips BETWEEN 29 AND 34 LIMIT 10000","SELECT SUM(DayOfWeek) FROM mytable WHERE OriginStateFips BETWEEN 29 AND 34 LIMIT 10000","SELECT MIN(DivAirportLandings) FROM mytable WHERE OriginStateFips BETWEEN 29 AND 34 LIMIT 10000"],"pql":"SELECT AVG(CRSElapsedTime), SUM(DayOfWeek), MIN(DivAirportLandings) FROM mytable WHERE OriginStateFips BETWEEN 29 AND 34 TOP 0"}
+{"hsqls":["SELECT AVG(CAST(DepDel15 AS DOUBLE)) FROM mytable WHERE DepDelayMinutes IN (126.0, 334.0) OR ArrTime NOT IN (1510, 2254) OR CancellationCode NOT IN ('A', 'B', 'C', 'noodles') LIMIT 10000","SELECT SUM(OriginStateFips) FROM mytable WHERE DepDelayMinutes IN (126.0, 334.0) OR ArrTime NOT IN (1510, 2254) OR CancellationCode NOT IN ('A', 'B', 'C', 'noodles') LIMIT 10000"],"pql":"SELECT AVG(DepDel15), SUM(OriginStateFips) FROM mytable WHERE DepDelayMinutes IN (126.0, 334.0) OR ArrTim [...]
+{"hsqls":["SELECT AVG(CAST(DestStateFips AS DOUBLE)) FROM mytable WHERE DivDistance NOT IN (453, 814, 1036, 998) LIMIT 10000","SELECT COUNT(DestWac) FROM mytable WHERE DivDistance NOT IN (453, 814, 1036, 998) LIMIT 10000","SELECT SUM(OriginAirportSeqID) FROM mytable WHERE DivDistance NOT IN (453, 814, 1036, 998) LIMIT 10000"],"pql":"SELECT AVG(DestStateFips), COUNT(DestWac), SUM(OriginAirportSeqID) FROM mytable WHERE DivDistance NOT IN (453, 814, 1036, 998) TOP 22"}
+{"hsqls":["SELECT AVG(CAST(FlightNum AS DOUBLE)) FROM mytable WHERE CRSDepTime IN (1644, 1333, 1911) LIMIT 10000","SELECT AVG(CAST(Distance AS DOUBLE)) FROM mytable WHERE CRSDepTime IN (1644, 1333, 1911) LIMIT 10000","SELECT SUM(DivActualElapsedTime) FROM mytable WHERE CRSDepTime IN (1644, 1333, 1911) LIMIT 10000"],"pql":"SELECT AVG(FlightNum), AVG(Distance), SUM(DivActualElapsedTime) FROM mytable WHERE CRSDepTime IN (1644, 1333, 1911) TOP 0"}
+{"hsqls":["SELECT AVG(CAST(LongestAddGTime AS DOUBLE)) FROM mytable WHERE DivReachedDest <= 0 LIMIT 10000","SELECT SUM(DestStateFips) FROM mytable WHERE DivReachedDest <= 0 LIMIT 10000"],"pql":"SELECT AVG(LongestAddGTime), SUM(DestStateFips) FROM mytable WHERE DivReachedDest <= 0 TOP 22"}
+{"hsqls":["SELECT AVG(CAST(NASDelay AS DOUBLE)) FROM mytable WHERE CRSArrTime = 1850 OR DestStateName <= 'Maryland' LIMIT 10000","SELECT SUM(FirstDepTime) FROM mytable WHERE CRSArrTime = 1850 OR DestStateName <= 'Maryland' LIMIT 10000"],"pql":"SELECT AVG(NASDelay), SUM(FirstDepTime) FROM mytable WHERE CRSArrTime = 1850 OR DestStateName <= 'Maryland' TOP 6"}
+{"hsqls":["SELECT AVG(CAST(OriginAirportSeqID AS DOUBLE)) FROM mytable WHERE (DivAirportSeqIDs__MV0 BETWEEN 1039705 AND 1315802 OR DivAirportSeqIDs__MV1 BETWEEN 1039705 AND 1315802 OR DivAirportSeqIDs__MV2 BETWEEN 1039705 AND 1315802 OR DivAirportSeqIDs__MV3 BETWEEN 1039705 AND 1315802 OR DivAirportSeqIDs__MV4 BETWEEN 1039705 AND 1315802) LIMIT 10000","SELECT MIN(CarrierDelay) FROM mytable WHERE (DivAirportSeqIDs__MV0 BETWEEN 1039705 AND 1315802 OR DivAirportSeqIDs__MV1 BETWEEN 1039705 A [...]
+{"hsqls":["SELECT AVG(CAST(Year AS DOUBLE)) FROM mytable WHERE (DivWheelsOffs__MV0 IN (1702, 2226, 749, 2328, 844) OR DivWheelsOffs__MV1 IN (1702, 2226, 749, 2328, 844) OR DivWheelsOffs__MV2 IN (1702, 2226, 749, 2328, 844) OR DivWheelsOffs__MV3 IN (1702, 2226, 749, 2328, 844) OR DivWheelsOffs__MV4 IN (1702, 2226, 749, 2328, 844)) OR ArrDelay NOT IN (25.0, 58.0, -19.0, 281.0, 418.0) LIMIT 10000","SELECT SUM(ArrivalDelayGroups) FROM mytable WHERE (DivWheelsOffs__MV0 IN (1702, 2226, 749, 23 [...]
+{"hsqls":["SELECT COUNT(ArrivalDelayGroups) FROM mytable WHERE LongestAddGTime = 42 AND ArrTime BETWEEN 2013 AND 1604 OR DivArrDelay BETWEEN 156 AND 348 LIMIT 10000","SELECT SUM(Distance) FROM mytable WHERE LongestAddGTime = 42 AND ArrTime BETWEEN 2013 AND 1604 OR DivArrDelay BETWEEN 156 AND 348 LIMIT 10000"],"pql":"SELECT COUNT(ArrivalDelayGroups), SUM(Distance) FROM mytable WHERE LongestAddGTime = 42 AND ArrTime BETWEEN 2013 AND 1604 OR DivArrDelay BETWEEN 156 AND 348 TOP 4"}
+{"hsqls":["SELECT COUNT(CRSDepTime) FROM mytable WHERE OriginAirportID NOT IN (14794, 12094, 13290, 10754) LIMIT 10000","SELECT SUM(Year) FROM mytable WHERE OriginAirportID NOT IN (14794, 12094, 13290, 10754) LIMIT 10000"],"pql":"SELECT COUNT(CRSDepTime), SUM(Year) FROM mytable WHERE OriginAirportID NOT IN (14794, 12094, 13290, 10754) TOP 20"}
+{"hsqls":["SELECT COUNT(Carrier) FROM mytable WHERE Month > 1 AND OriginStateFips BETWEEN 45 AND 48 LIMIT 10000","SELECT SUM(Cancelled) FROM mytable WHERE Month > 1 AND OriginStateFips BETWEEN 45 AND 48 LIMIT 10000","SELECT MIN(DestStateFips) FROM mytable WHERE Month > 1 AND OriginStateFips BETWEEN 45 AND 48 LIMIT 10000"],"pql":"SELECT COUNT(Carrier), SUM(Cancelled), MIN(DestStateFips) FROM mytable WHERE Month > 1 AND OriginStateFips BETWEEN 45 AND 48 TOP 12"}
+{"hsqls":["SELECT COUNT(DepDelay) FROM mytable WHERE DestCityMarketID NOT IN (30620) LIMIT 10000","SELECT SUM(DepDelayMinutes) FROM mytable WHERE DestCityMarketID NOT IN (30620) LIMIT 10000","SELECT MAX(OriginAirportID) FROM mytable WHERE DestCityMarketID NOT IN (30620) LIMIT 10000"],"pql":"SELECT COUNT(DepDelay), SUM(DepDelayMinutes), MAX(OriginAirportID) FROM mytable WHERE DestCityMarketID NOT IN (30620) TOP 9"}
+{"hsqls":["SELECT COUNT(DepartureDelayGroups) FROM mytable WHERE DayofMonth BETWEEN 12 AND 26 OR DistanceGroup IN (7, 11) LIMIT 10000","SELECT SUM(ArrTime) FROM mytable WHERE DayofMonth BETWEEN 12 AND 26 OR DistanceGroup IN (7, 11) LIMIT 10000","SELECT AVG(CAST(DepDelayMinutes AS DOUBLE)) FROM mytable WHERE DayofMonth BETWEEN 12 AND 26 OR DistanceGroup IN (7, 11) LIMIT 10000"],"pql":"SELECT COUNT(DepartureDelayGroups), SUM(ArrTime), AVG(DepDelayMinutes) FROM mytable WHERE DayofMonth BETW [...]
+{"hsqls":["SELECT COUNT(DestAirportID) FROM mytable WHERE FlightDate NOT IN ('2014-01-14', '2014-01-21', '2014-01-22', '2014-01-20', '2014-01-08') OR WheelsOn NOT IN (2155, 1912) LIMIT 10000","SELECT SUM(CRSArrTime) FROM mytable WHERE FlightDate NOT IN ('2014-01-14', '2014-01-21', '2014-01-22', '2014-01-20', '2014-01-08') OR WheelsOn NOT IN (2155, 1912) LIMIT 10000"],"pql":"SELECT COUNT(DestAirportID), SUM(CRSArrTime) FROM mytable WHERE FlightDate NOT IN ('2014-01-14', '2014-01-21', '201 [...]
+{"hsqls":["SELECT COUNT(DivDistance) FROM mytable WHERE LongestAddGTime IN (20, 74, 28) OR DepTime BETWEEN 1347 AND 944 OR Origin NOT IN ('GRR', 'TUS', 'ALO', 'MDW') LIMIT 10000","SELECT SUM(Diverted) FROM mytable WHERE LongestAddGTime IN (20, 74, 28) OR DepTime BETWEEN 1347 AND 944 OR Origin NOT IN ('GRR', 'TUS', 'ALO', 'MDW') LIMIT 10000"],"pql":"SELECT COUNT(DivDistance), SUM(Diverted) FROM mytable WHERE LongestAddGTime IN (20, 74, 28) OR DepTime BETWEEN 1347 AND 944 OR Origin NOT IN [...]
+{"hsqls":["SELECT COUNT(DivReachedDest) FROM mytable WHERE Flights BETWEEN 1 AND 1 OR TaxiOut BETWEEN 102 AND 18 AND DestStateFips BETWEEN 10 AND 13 LIMIT 10000","SELECT SUM(DivActualElapsedTime) FROM mytable WHERE Flights BETWEEN 1 AND 1 OR TaxiOut BETWEEN 102 AND 18 AND DestStateFips BETWEEN 10 AND 13 LIMIT 10000"],"pql":"SELECT COUNT(DivReachedDest), SUM(DivActualElapsedTime) FROM mytable WHERE Flights BETWEEN 1 AND 1 OR TaxiOut BETWEEN 102 AND 18 AND DestStateFips BETWEEN 10 AND 13 TOP 20"}
+{"hsqls":["SELECT COUNT(Flights) FROM mytable WHERE DestCityMarketID < 31423 LIMIT 10000","SELECT SUM(OriginAirportID) FROM mytable WHERE DestCityMarketID < 31423 LIMIT 10000"],"pql":"SELECT COUNT(Flights), SUM(OriginAirportID) FROM mytable WHERE DestCityMarketID < 31423 TOP 5"}
+{"hsqls":["SELECT COUNT(LongestAddGTime) FROM mytable WHERE Month BETWEEN 1 AND 1 OR CRSArrTime NOT IN (1723) LIMIT 10000","SELECT SUM(OriginCityMarketID) FROM mytable WHERE Month BETWEEN 1 AND 1 OR CRSArrTime NOT IN (1723) LIMIT 10000"],"pql":"SELECT COUNT(LongestAddGTime), SUM(OriginCityMarketID) FROM mytable WHERE Month BETWEEN 1 AND 1 OR CRSArrTime NOT IN (1723) TOP 18"}
+{"hsqls":["SELECT COUNT(Month) FROM mytable WHERE (DivTailNums__MV0 <= 'N530MQ' OR DivTailNums__MV1 <= 'N530MQ' OR DivTailNums__MV2 <= 'N530MQ' OR DivTailNums__MV3 <= 'N530MQ' OR DivTailNums__MV4 <= 'N530MQ') AND AirTime NOT IN (122, 158, 73, 142) OR DestAirportID NOT IN (10423, 13303, 10581, 10747) LIMIT 10000","SELECT SUM(OriginAirportSeqID) FROM mytable WHERE (DivTailNums__MV0 <= 'N530MQ' OR DivTailNums__MV1 <= 'N530MQ' OR DivTailNums__MV2 <= 'N530MQ' OR DivTailNums__MV3 <= 'N530MQ' O [...]
+{"hsqls":["SELECT COUNT(NASDelay) FROM mytable WHERE ArrDel15 IN (1, 0, -9999) OR OriginAirportID >= 12177 LIMIT 10000","SELECT SUM(DepDelayMinutes) FROM mytable WHERE ArrDel15 IN (1, 0, -9999) OR OriginAirportID >= 12177 LIMIT 10000"],"pql":"SELECT COUNT(NASDelay), SUM(DepDelayMinutes) FROM mytable WHERE ArrDel15 IN (1, 0, -9999) OR OriginAirportID >= 12177 TOP 6"}
+{"hsqls":["SELECT COUNT(OriginCityMarketID) FROM mytable WHERE AirTime IN (67, 254, 76) AND SecurityDelay <= 1 LIMIT 10000","SELECT SUM(DestStateFips) FROM mytable WHERE AirTime IN (67, 254, 76) AND SecurityDelay <= 1 LIMIT 10000"],"pql":"SELECT COUNT(OriginCityMarketID), SUM(DestStateFips) FROM mytable WHERE AirTime IN (67, 254, 76) AND SecurityDelay <= 1 TOP 25"}
+{"hsqls":["SELECT COUNT(OriginCityName) FROM mytable WHERE ActualElapsedTime NOT IN (113, 271) LIMIT 10000","SELECT SUM(DistanceGroup) FROM mytable WHERE ActualElapsedTime NOT IN (113, 271) LIMIT 10000"],"pql":"SELECT COUNT(OriginCityName), SUM(DistanceGroup) FROM mytable WHERE ActualElapsedTime NOT IN (113, 271) TOP 3"}
+{"hsqls":["SELECT COUNT(SecurityDelay) FROM mytable WHERE Diverted < 1 AND DistanceGroup NOT IN (7, 5, 11) LIMIT 10000","SELECT SUM(TaxiOut) FROM mytable WHERE Diverted < 1 AND DistanceGroup NOT IN (7, 5, 11) LIMIT 10000","SELECT AVG(CAST(DestWac AS DOUBLE)) FROM mytable WHERE Diverted < 1 AND DistanceGroup NOT IN (7, 5, 11) LIMIT 10000"],"pql":"SELECT COUNT(SecurityDelay), SUM(TaxiOut), AVG(DestWac) FROM mytable WHERE Diverted < 1 AND DistanceGroup NOT IN (7, 5, 11) TOP 9"}
+{"hsqls":["SELECT COUNT(TaxiIn) FROM mytable WHERE DestAirportSeqID >= 1560702 OR SecurityDelay NOT IN (0, 18) OR WeatherDelay = 103 LIMIT 10000","SELECT MIN(DaysSinceEpoch) FROM mytable WHERE DestAirportSeqID >= 1560702 OR SecurityDelay NOT IN (0, 18) OR WeatherDelay = 103 LIMIT 10000","SELECT SUM(OriginAirportSeqID) FROM mytable WHERE DestAirportSeqID >= 1560702 OR SecurityDelay NOT IN (0, 18) OR WeatherDelay = 103 LIMIT 10000"],"pql":"SELECT COUNT(TaxiIn), MIN(DaysSinceEpoch), SUM(Ori [...]
+{"hsqls":["SELECT MAX(AirlineID) FROM mytable WHERE Year = 2014 AND DestStateFips IN (15) LIMIT 10000","SELECT MIN(OriginAirportSeqID) FROM mytable WHERE Year = 2014 AND DestStateFips IN (15) LIMIT 10000","SELECT SUM(ArrivalDelayGroups) FROM mytable WHERE Year = 2014 AND DestStateFips IN (15) LIMIT 10000"],"pql":"SELECT MAX(AirlineID), MIN(OriginAirportSeqID), SUM(ArrivalDelayGroups) FROM mytable WHERE Year = 2014 AND DestStateFips IN (15) TOP 6"}
+{"hsqls":["SELECT MAX(DepDel15) FROM mytable WHERE DestCityName = 'Laramie, WY' LIMIT 10000","SELECT SUM(Diverted) FROM mytable WHERE DestCityName = 'Laramie, WY' LIMIT 10000"],"pql":"SELECT MAX(DepDel15), SUM(Diverted) FROM mytable WHERE DestCityName = 'Laramie, WY'"}
+{"hsqls":["SELECT MAX(DepTime) FROM mytable WHERE DepTime IN (1005, 1811, 1016, 1354, 2023) AND ArrivalDelayGroups = -1 OR TailNum IN ('N597AA', 'N14125', 'N902FR', 'N280WN') LIMIT 10000","SELECT SUM(Month) FROM mytable WHERE DepTime IN (1005, 1811, 1016, 1354, 2023) AND ArrivalDelayGroups = -1 OR TailNum IN ('N597AA', 'N14125', 'N902FR', 'N280WN') LIMIT 10000","SELECT MIN(WheelsOff) FROM mytable WHERE DepTime IN (1005, 1811, 1016, 1354, 2023) AND ArrivalDelayGroups = -1 OR TailNum IN (' [...]
+{"hsqls":["SELECT MAX(DestAirportSeqID) FROM mytable WHERE CRSElapsedTime >= 102 OR LongestAddGTime IN (19, 54) AND FlightDate IN ('2014-01-05', '2014-01-06', '2014-01-03', '2014-01-20', '2014-01-24') LIMIT 10000","SELECT COUNT(DaysSinceEpoch) FROM mytable WHERE CRSElapsedTime >= 102 OR LongestAddGTime IN (19, 54) AND FlightDate IN ('2014-01-05', '2014-01-06', '2014-01-03', '2014-01-20', '2014-01-24') LIMIT 10000","SELECT SUM(FlightNum) FROM mytable WHERE CRSElapsedTime >= 102 OR Longest [...]
+{"hsqls":["SELECT MAX(DestAirportSeqID) FROM mytable WHERE FlightNum NOT IN (5065, 2539, 3182, 3605) LIMIT 10000","SELECT MIN(DivReachedDest) FROM mytable WHERE FlightNum NOT IN (5065, 2539, 3182, 3605) LIMIT 10000","SELECT SUM(Quarter) FROM mytable WHERE FlightNum NOT IN (5065, 2539, 3182, 3605) LIMIT 10000"],"pql":"SELECT MAX(DestAirportSeqID), MIN(DivReachedDest), SUM(Quarter) FROM mytable WHERE FlightNum NOT IN (5065, 2539, 3182, 3605) TOP 26"}
+{"hsqls":["SELECT MAX(DivDistance) FROM mytable WHERE Diverted BETWEEN 0 AND 0 LIMIT 10000","SELECT SUM(CarrierDelay) FROM mytable WHERE Diverted BETWEEN 0 AND 0 LIMIT 10000"],"pql":"SELECT MAX(DivDistance), SUM(CarrierDelay) FROM mytable WHERE Diverted BETWEEN 0 AND 0 TOP 7"}
+{"hsqls":["SELECT MAX(FirstDepTime) FROM mytable WHERE DepTimeBlk BETWEEN '1900-1959' AND '1600-1659' OR TailNum NOT IN ('N584NW') LIMIT 10000","SELECT SUM(DestStateFips) FROM mytable WHERE DepTimeBlk BETWEEN '1900-1959' AND '1600-1659' OR TailNum NOT IN ('N584NW') LIMIT 10000"],"pql":"SELECT MAX(FirstDepTime), SUM(DestStateFips) FROM mytable WHERE DepTimeBlk BETWEEN '1900-1959' AND '1600-1659' OR TailNum NOT IN ('N584NW') TOP 15"}
+{"hsqls":["SELECT MAX(Flights) FROM mytable WHERE WeatherDelay BETWEEN 43 AND 55 LIMIT 10000","SELECT SUM(WeatherDelay) FROM mytable WHERE WeatherDelay BETWEEN 43 AND 55 LIMIT 10000","SELECT AVG(CAST(Diverted AS DOUBLE)) FROM mytable WHERE WeatherDelay BETWEEN 43 AND 55 LIMIT 10000"],"pql":"SELECT MAX(Flights), SUM(WeatherDelay), AVG(Diverted) FROM mytable WHERE WeatherDelay BETWEEN 43 AND 55 TOP 4"}
+{"hsqls":["SELECT MAX(NASDelay) FROM mytable WHERE CRSArrTime < 2352 OR ArrDel15 BETWEEN -9999 AND -9999 OR OriginAirportID BETWEEN 10785 AND 10930 LIMIT 10000","SELECT SUM(Flights) FROM mytable WHERE CRSArrTime < 2352 OR ArrDel15 BETWEEN -9999 AND -9999 OR OriginAirportID BETWEEN 10785 AND 10930 LIMIT 10000","SELECT MAX(Cancelled) FROM mytable WHERE CRSArrTime < 2352 OR ArrDel15 BETWEEN -9999 AND -9999 OR OriginAirportID BETWEEN 10785 AND 10930 LIMIT 10000"],"pql":"SELECT MAX(NASDelay), [...]
+{"hsqls":["SELECT MAX(OriginAirportSeqID) FROM mytable WHERE DestAirportID = 14828 LIMIT 10000","SELECT SUM(DepDel15) FROM mytable WHERE DestAirportID = 14828 LIMIT 10000","SELECT MIN(DepartureDelayGroups) FROM mytable WHERE DestAirportID = 14828 LIMIT 10000"],"pql":"SELECT MAX(OriginAirportSeqID), SUM(DepDel15), MIN(DepartureDelayGroups) FROM mytable WHERE DestAirportID = 14828 TOP 6"}
+{"hsqls":["SELECT MAX(Quarter) FROM mytable WHERE ArrDelayMinutes > 321.0 OR ArrDel15 = 1 LIMIT 10000","SELECT SUM(OriginAirportID) FROM mytable WHERE ArrDelayMinutes > 321.0 OR ArrDel15 = 1 LIMIT 10000","SELECT SUM(DestAirportID) FROM mytable WHERE ArrDelayMinutes > 321.0 OR ArrDel15 = 1 LIMIT 10000"],"pql":"SELECT MAX(Quarter), SUM(OriginAirportID), SUM(DestAirportID) FROM mytable WHERE ArrDelayMinutes > 321.0 OR ArrDel15 = 1 TOP 14"}
+{"hsqls":["SELECT MAX(SecurityDelay) FROM mytable WHERE Origin NOT IN ('BQN', 'HIB') AND ArrDelayMinutes NOT IN (15.0, 218.0) AND DivReachedDest BETWEEN -9999 AND 0 LIMIT 10000","SELECT SUM(DivReachedDest) FROM mytable WHERE Origin NOT IN ('BQN', 'HIB') AND ArrDelayMinutes NOT IN (15.0, 218.0) AND DivReachedDest BETWEEN -9999 AND 0 LIMIT 10000","SELECT MAX(DivReachedDest) FROM mytable WHERE Origin NOT IN ('BQN', 'HIB') AND ArrDelayMinutes NOT IN (15.0, 218.0) AND DivReachedDest BETWEEN - [...]
+{"hsqls":["SELECT MAX(TotalAddGTime) FROM mytable WHERE (DivAirportIDs__MV0 BETWEEN 10721 AND 11953 OR DivAirportIDs__MV1 BETWEEN 10721 AND 11953 OR DivAirportIDs__MV2 BETWEEN 10721 AND 11953 OR DivAirportIDs__MV3 BETWEEN 10721 AND 11953 OR DivAirportIDs__MV4 BETWEEN 10721 AND 11953) OR SecurityDelay BETWEEN 18 AND -9999 AND ArrTime > 1548 LIMIT 10000","SELECT SUM(DayofMonth) FROM mytable WHERE (DivAirportIDs__MV0 BETWEEN 10721 AND 11953 OR DivAirportIDs__MV1 BETWEEN 10721 AND 11953 OR D [...]
+{"hsqls":["SELECT MIN(ArrDelayMinutes) FROM mytable WHERE DistanceGroup = 3 AND CancellationCode IN ('A', 'B', 'C') OR Distance IN (4983, 723, 1120, 214, 1635) LIMIT 10000","SELECT COUNT(ActualElapsedTime) FROM mytable WHERE DistanceGroup = 3 AND CancellationCode IN ('A', 'B', 'C') OR Distance IN (4983, 723, 1120, 214, 1635) LIMIT 10000","SELECT SUM(FlightNum) FROM mytable WHERE DistanceGroup = 3 AND CancellationCode IN ('A', 'B', 'C') OR Distance IN (4983, 723, 1120, 214, 1635) LIMIT 10 [...]
+{"hsqls":["SELECT MIN(ArrTime) FROM mytable WHERE FirstDepTime NOT IN (2009, 1957, 550) AND DayofMonth <> 2 AND OriginState NOT IN ('IA', 'NY', 'RI', 'MD') LIMIT 10000","SELECT SUM(OriginStateFips) FROM mytable WHERE FirstDepTime NOT IN (2009, 1957, 550) AND DayofMonth <> 2 AND OriginState NOT IN ('IA', 'NY', 'RI', 'MD') LIMIT 10000"],"pql":"SELECT MIN(ArrTime), SUM(OriginStateFips) FROM mytable WHERE FirstDepTime NOT IN (2009, 1957, 550) AND DayofMonth <> 2 AND OriginState NOT IN ('IA', [...]
+{"hsqls":["SELECT MIN(DivDistance) FROM mytable WHERE DivActualElapsedTime >= 265 LIMIT 10000","SELECT SUM(DestWac) FROM mytable WHERE DivActualElapsedTime >= 265 LIMIT 10000","SELECT MIN(CRSElapsedTime) FROM mytable WHERE DivActualElapsedTime >= 265 LIMIT 10000"],"pql":"SELECT MIN(DivDistance), SUM(DestWac), MIN(CRSElapsedTime) FROM mytable WHERE DivActualElapsedTime >= 265 TOP 2"}
+{"hsqls":["SELECT MIN(FlightNum) FROM mytable WHERE FlightNum BETWEEN 2345 AND 4441 AND FlightNum = 3747 LIMIT 10000","SELECT AVG(CAST(DestAirportID AS DOUBLE)) FROM mytable WHERE FlightNum BETWEEN 2345 AND 4441 AND FlightNum = 3747 LIMIT 10000","SELECT SUM(FlightNum) FROM mytable WHERE FlightNum BETWEEN 2345 AND 4441 AND FlightNum = 3747 LIMIT 10000"],"pql":"SELECT MIN(FlightNum), AVG(DestAirportID), SUM(FlightNum) FROM mytable WHERE FlightNum BETWEEN 2345 AND 4441 AND FlightNum = 3747 [...]
+{"hsqls":["SELECT MIN(Flights) FROM mytable WHERE DayofMonth >= 12 OR DepDelayMinutes <= 171.0 OR Quarter BETWEEN 1 AND 1 LIMIT 10000","SELECT SUM(WheelsOff) FROM mytable WHERE DayofMonth >= 12 OR DepDelayMinutes <= 171.0 OR Quarter BETWEEN 1 AND 1 LIMIT 10000"],"pql":"SELECT MIN(Flights), SUM(WheelsOff) FROM mytable WHERE DayofMonth >= 12 OR DepDelayMinutes <= 171.0 OR Quarter BETWEEN 1 AND 1 TOP 0"}
+{"hsqls":["SELECT MIN(Flights) FROM mytable WHERE FlightNum NOT IN (4484) AND (DivAirportSeqIDs__MV0 >= 1323202 OR DivAirportSeqIDs__MV1 >= 1323202 OR DivAirportSeqIDs__MV2 >= 1323202 OR DivAirportSeqIDs__MV3 >= 1323202 OR DivAirportSeqIDs__MV4 >= 1323202) AND DayOfWeek NOT IN (2, 1) LIMIT 10000","SELECT SUM(CRSArrTime) FROM mytable WHERE FlightNum NOT IN (4484) AND (DivAirportSeqIDs__MV0 >= 1323202 OR DivAirportSeqIDs__MV1 >= 1323202 OR DivAirportSeqIDs__MV2 >= 1323202 OR DivAirportSeqI [...]
+{"hsqls":["SELECT MIN(OriginStateFips) FROM mytable WHERE (DivAirports__MV0 > 'PSG' OR DivAirports__MV1 > 'PSG' OR DivAirports__MV2 > 'PSG' OR DivAirports__MV3 > 'PSG' OR DivAirports__MV4 > 'PSG') LIMIT 10000","SELECT SUM(FirstDepTime) FROM mytable WHERE (DivAirports__MV0 > 'PSG' OR DivAirports__MV1 > 'PSG' OR DivAirports__MV2 > 'PSG' OR DivAirports__MV3 > 'PSG' OR DivAirports__MV4 > 'PSG') LIMIT 10000"],"pql":"SELECT MIN(OriginStateFips), SUM(FirstDepTime) FROM mytable WHERE DivAirports [...]
+{"hsqls":["SELECT MIN(OriginStateFips) FROM mytable WHERE (DivWheelsOns__MV0 IN (2041, 2350, 1553, 1546) OR DivWheelsOns__MV1 IN (2041, 2350, 1553, 1546) OR DivWheelsOns__MV2 IN (2041, 2350, 1553, 1546) OR DivWheelsOns__MV3 IN (2041, 2350, 1553, 1546) OR DivWheelsOns__MV4 IN (2041, 2350, 1553, 1546)) LIMIT 10000","SELECT AVG(CAST(OriginAirportSeqID AS DOUBLE)) FROM mytable WHERE (DivWheelsOns__MV0 IN (2041, 2350, 1553, 1546) OR DivWheelsOns__MV1 IN (2041, 2350, 1553, 1546) OR DivWheelsOn [...]
+{"hsqls":["SELECT MIN(Quarter) FROM mytable WHERE ArrTimeBlk > '0600-0659' LIMIT 10000","SELECT SUM(FlightNum) FROM mytable WHERE ArrTimeBlk > '0600-0659' LIMIT 10000"],"pql":"SELECT MIN(Quarter), SUM(FlightNum) FROM mytable WHERE ArrTimeBlk > '0600-0659' TOP 11"}
+{"hsqls":["SELECT MIN(Quarter) FROM mytable WHERE DestState BETWEEN 'CT' AND 'SC' OR Origin IN ('SJU', 'MGM', 'ORF', 'STT', 'GSO') AND DestCityName NOT IN ('Valdosta, GA', 'San Antonio, TX', 'Alexandria, LA') LIMIT 10000","SELECT SUM(DestAirportID) FROM mytable WHERE DestState BETWEEN 'CT' AND 'SC' OR Origin IN ('SJU', 'MGM', 'ORF', 'STT', 'GSO') AND DestCityName NOT IN ('Valdosta, GA', 'San Antonio, TX', 'Alexandria, LA') LIMIT 10000","SELECT MIN(TaxiOut) FROM mytable WHERE DestState BE [...]
+{"hsqls":["SELECT MIN(SecurityDelay) FROM mytable WHERE FlightDate < '2014-01-11' OR FlightDate BETWEEN '2014-01-31' AND '2014-01-04' LIMIT 10000","SELECT SUM(FirstDepTime) FROM mytable WHERE FlightDate < '2014-01-11' OR FlightDate BETWEEN '2014-01-31' AND '2014-01-04' LIMIT 10000","SELECT MIN(WheelsOff) FROM mytable WHERE FlightDate < '2014-01-11' OR FlightDate BETWEEN '2014-01-31' AND '2014-01-04' LIMIT 10000"],"pql":"SELECT MIN(SecurityDelay), SUM(FirstDepTime), MIN(WheelsOff) FROM my [...]
+{"hsqls":["SELECT MIN(WheelsOn) FROM mytable WHERE (DivTotalGTimes__MV0 IN (1, 59, 44, 56, 201) OR DivTotalGTimes__MV1 IN (1, 59, 44, 56, 201) OR DivTotalGTimes__MV2 IN (1, 59, 44, 56, 201) OR DivTotalGTimes__MV3 IN (1, 59, 44, 56, 201) OR DivTotalGTimes__MV4 IN (1, 59, 44, 56, 201)) LIMIT 10000","SELECT SUM(DivDistance) FROM mytable WHERE (DivTotalGTimes__MV0 IN (1, 59, 44, 56, 201) OR DivTotalGTimes__MV1 IN (1, 59, 44, 56, 201) OR DivTotalGTimes__MV2 IN (1, 59, 44, 56, 201) OR DivTotal [...]
+{"hsqls":["SELECT SUM(ActualElapsedTime) FROM mytable WHERE DepDelay < 177.0 AND TailNum BETWEEN 'N176PQ' AND 'N181PQ' AND LateAircraftDelay BETWEEN 96 AND 123 LIMIT 10000"],"pql":"SELECT SUM(ActualElapsedTime) FROM mytable WHERE DepDelay < 177.0 AND TailNum BETWEEN 'N176PQ' AND 'N181PQ' AND LateAircraftDelay BETWEEN 96 AND 123 TOP 24"}
+{"hsqls":["SELECT SUM(ActualElapsedTime) FROM mytable WHERE DepTime BETWEEN 1520 AND 2221 LIMIT 10000","SELECT MAX(DayOfWeek) FROM mytable WHERE DepTime BETWEEN 1520 AND 2221 LIMIT 10000"],"pql":"SELECT SUM(ActualElapsedTime), MAX(DayOfWeek) FROM mytable WHERE DepTime BETWEEN 1520 AND 2221 TOP 17"}
+{"hsqls":["SELECT SUM(ActualElapsedTime) FROM mytable WHERE DestCityMarketID IN (32884, 30070, 30466, 30868, 34696) OR Cancelled <= 1 OR Quarter BETWEEN 1 AND 1 LIMIT 10000","SELECT COUNT(ArrDelay) FROM mytable WHERE DestCityMarketID IN (32884, 30070, 30466, 30868, 34696) OR Cancelled <= 1 OR Quarter BETWEEN 1 AND 1 LIMIT 10000","SELECT MAX(ActualElapsedTime) FROM mytable WHERE DestCityMarketID IN (32884, 30070, 30466, 30868, 34696) OR Cancelled <= 1 OR Quarter BETWEEN 1 AND 1 LIMIT 1000 [...]
+{"hsqls":["SELECT SUM(AirTime) FROM mytable WHERE DestAirportID BETWEEN 15389 AND 10731 AND DestState NOT IN ('WI', 'WV') OR DestStateFips < 56 LIMIT 10000","SELECT SUM(DepartureDelayGroups) FROM mytable WHERE DestAirportID BETWEEN 15389 AND 10731 AND DestState NOT IN ('WI', 'WV') OR DestStateFips < 56 LIMIT 10000"],"pql":"SELECT SUM(AirTime), SUM(DepartureDelayGroups) FROM mytable WHERE DestAirportID BETWEEN 15389 AND 10731 AND DestState NOT IN ('WI', 'WV') OR DestStateFips < 56 TOP 24"}
+{"hsqls":["SELECT SUM(AirlineID) FROM mytable WHERE ArrDelay NOT IN (185.0, 193.0, 190.0) LIMIT 10000","SELECT COUNT(DestState) FROM mytable WHERE ArrDelay NOT IN (185.0, 193.0, 190.0) LIMIT 10000"],"pql":"SELECT SUM(AirlineID), COUNT(DestState) FROM mytable WHERE ArrDelay NOT IN (185.0, 193.0, 190.0) TOP 18"}
+{"hsqls":["SELECT SUM(AirlineID) FROM mytable WHERE DayOfWeek BETWEEN 5 AND 7 OR LateAircraftDelay NOT IN (102, 118) OR DistanceGroup BETWEEN 10 AND 6 LIMIT 10000"],"pql":"SELECT SUM(AirlineID) FROM mytable WHERE DayOfWeek BETWEEN 5 AND 7 OR LateAircraftDelay NOT IN (102, 118) OR DistanceGroup BETWEEN 10 AND 6 TOP 1"}
+{"hsqls":["SELECT SUM(ArrDel15) FROM mytable WHERE DivAirportLandings <= 1 AND OriginWac <> 1 LIMIT 10000","SELECT COUNT(ActualElapsedTime) FROM mytable WHERE DivAirportLandings <= 1 AND OriginWac <> 1 LIMIT 10000","SELECT AVG(CAST(ArrDelay AS DOUBLE)) FROM mytable WHERE DivAirportLandings <= 1 AND OriginWac <> 1 LIMIT 10000"],"pql":"SELECT SUM(ArrDel15), COUNT(ActualElapsedTime), AVG(ArrDelay) FROM mytable WHERE DivAirportLandings <= 1 AND OriginWac <> 1 TOP 24"}
+{"hsqls":["SELECT SUM(ArrDelay) FROM mytable WHERE DayOfWeek IN (5, 4) LIMIT 10000","SELECT MIN(Month) FROM mytable WHERE DayOfWeek IN (5, 4) LIMIT 10000"],"pql":"SELECT SUM(ArrDelay), MIN(Month) FROM mytable WHERE DayOfWeek IN (5, 4) TOP 27"}
+{"hsqls":["SELECT SUM(ArrDelayMinutes) FROM mytable WHERE OriginCityMarketID IN (32467, 31721) OR TaxiIn NOT IN (116, 96, 44) AND OriginAirportSeqID BETWEEN 1295302 AND 1288403 LIMIT 10000","SELECT SUM(WheelsOn) FROM mytable WHERE OriginCityMarketID IN (32467, 31721) OR TaxiIn NOT IN (116, 96, 44) AND OriginAirportSeqID BETWEEN 1295302 AND 1288403 LIMIT 10000","SELECT COUNT(ArrTimeBlk) FROM mytable WHERE OriginCityMarketID IN (32467, 31721) OR TaxiIn NOT IN (116, 96, 44) AND OriginAirpor [...]
+{"hsqls":["SELECT SUM(ArrivalDelayGroups) FROM mytable WHERE AirlineID IN (21171) OR TotalAddGTime NOT IN (128, 31, 34, 37) LIMIT 10000","SELECT SUM(DayOfWeek) FROM mytable WHERE AirlineID IN (21171) OR TotalAddGTime NOT IN (128, 31, 34, 37) LIMIT 10000","SELECT SUM(DepDelay) FROM mytable WHERE AirlineID IN (21171) OR TotalAddGTime NOT IN (128, 31, 34, 37) LIMIT 10000"],"pql":"SELECT SUM(ArrivalDelayGroups), SUM(DayOfWeek), SUM(DepDelay) FROM mytable WHERE AirlineID IN (21171) OR TotalAd [...]
+{"hsqls":["SELECT SUM(ArrivalDelayGroups) FROM mytable WHERE DestStateFips >= 37 OR AirlineID BETWEEN 19930 AND 20304 LIMIT 10000"],"pql":"SELECT SUM(ArrivalDelayGroups) FROM mytable WHERE DestStateFips >= 37 OR AirlineID BETWEEN 19930 AND 20304 TOP 5"}
+{"hsqls":["SELECT SUM(CRSArrTime) FROM mytable WHERE (DivAirportSeqIDs__MV0 >= 1099402 OR DivAirportSeqIDs__MV1 >= 1099402 OR DivAirportSeqIDs__MV2 >= 1099402 OR DivAirportSeqIDs__MV3 >= 1099402 OR DivAirportSeqIDs__MV4 >= 1099402) OR AirTime IN (152, 239, 240, 264) LIMIT 10000","SELECT SUM(OriginAirportSeqID) FROM mytable WHERE (DivAirportSeqIDs__MV0 >= 1099402 OR DivAirportSeqIDs__MV1 >= 1099402 OR DivAirportSeqIDs__MV2 >= 1099402 OR DivAirportSeqIDs__MV3 >= 1099402 OR DivAirportSeqIDs [...]
+{"hsqls":["SELECT SUM(CRSDepTime) FROM mytable WHERE WheelsOff BETWEEN 1147 AND 2002 AND DivAirportLandings > 1 LIMIT 10000"],"pql":"SELECT SUM(CRSDepTime) FROM mytable WHERE WheelsOff BETWEEN 1147 AND 2002 AND DivAirportLandings > 1 TOP 25"}
+{"hsqls":["SELECT SUM(CarrierDelay) FROM mytable WHERE Quarter = 1 AND CarrierDelay = 66 AND OriginStateFips IN (78, 45, 35, 24) LIMIT 10000"],"pql":"SELECT SUM(CarrierDelay) FROM mytable WHERE Quarter = 1 AND CarrierDelay = 66 AND OriginStateFips IN (78, 45, 35, 24) TOP 5"}
+{"hsqls":["SELECT SUM(DayOfWeek) FROM mytable WHERE (DivAirportIDs__MV0 = 11298 OR DivAirportIDs__MV1 = 11298 OR DivAirportIDs__MV2 = 11298 OR DivAirportIDs__MV3 = 11298 OR DivAirportIDs__MV4 = 11298) OR Flights <= 1 LIMIT 10000"],"pql":"SELECT SUM(DayOfWeek) FROM mytable WHERE DivAirportIDs = 11298 OR Flights <= 1 TOP 2"}
+{"hsqls":["SELECT SUM(DayOfWeek) FROM mytable WHERE Year BETWEEN 2014 AND 2014 AND WheelsOn BETWEEN 1417 AND 1955 LIMIT 10000"],"pql":"SELECT SUM(DayOfWeek) FROM mytable WHERE Year BETWEEN 2014 AND 2014 AND WheelsOn BETWEEN 1417 AND 1955 TOP 2"}
+{"hsqls":["SELECT SUM(DaysSinceEpoch) FROM mytable WHERE (DivAirports__MV0 BETWEEN 'MSP' AND 'SAT' OR DivAirports__MV1 BETWEEN 'MSP' AND 'SAT' OR DivAirports__MV2 BETWEEN 'MSP' AND 'SAT' OR DivAirports__MV3 BETWEEN 'MSP' AND 'SAT' OR DivAirports__MV4 BETWEEN 'MSP' AND 'SAT') AND OriginWac < 66 OR DivDistance <= 328 LIMIT 10000","SELECT AVG(CAST(DepartureDelayGroups AS DOUBLE)) FROM mytable WHERE (DivAirports__MV0 BETWEEN 'MSP' AND 'SAT' OR DivAirports__MV1 BETWEEN 'MSP' AND 'SAT' OR DivA [...]
+{"hsqls":["SELECT SUM(Diverted) FROM mytable WHERE DestState BETWEEN 'AZ' AND 'GA' OR TailNum IN ('N341NB') OR Dest <> 'RNO' LIMIT 10000","SELECT MAX(DivReachedDest) FROM mytable WHERE DestState BETWEEN 'AZ' AND 'GA' OR TailNum IN ('N341NB') OR Dest <> 'RNO' LIMIT 10000"],"pql":"SELECT SUM(Diverted), MAX(DivReachedDest) FROM mytable WHERE DestState BETWEEN 'AZ' AND 'GA' OR TailNum IN ('N341NB') OR Dest <> 'RNO' TOP 21"}
+{"hsqls":["SELECT SUM(FirstDepTime) FROM mytable WHERE TailNum IN ('N77296') OR WheelsOn BETWEEN 2101 AND 1814 LIMIT 10000","SELECT COUNT(OriginAirportID) FROM mytable WHERE TailNum IN ('N77296') OR WheelsOn BETWEEN 2101 AND 1814 LIMIT 10000"],"pql":"SELECT SUM(FirstDepTime), COUNT(OriginAirportID) FROM mytable WHERE TailNum IN ('N77296') OR WheelsOn BETWEEN 2101 AND 1814 TOP 21"}
+{"hsqls":["SELECT SUM(Flights) FROM mytable WHERE (DivAirportIDs__MV0 > 10257 OR DivAirportIDs__MV1 > 10257 OR DivAirportIDs__MV2 > 10257 OR DivAirportIDs__MV3 > 10257 OR DivAirportIDs__MV4 > 10257) OR DepDel15 BETWEEN 1 AND -9999 OR ArrDel15 BETWEEN -9999 AND 0 LIMIT 10000","SELECT AVG(CAST(WheelsOn AS DOUBLE)) FROM mytable WHERE (DivAirportIDs__MV0 > 10257 OR DivAirportIDs__MV1 > 10257 OR DivAirportIDs__MV2 > 10257 OR DivAirportIDs__MV3 > 10257 OR DivAirportIDs__MV4 > 10257) OR DepDel1 [...]
+{"hsqls":["SELECT SUM(LongestAddGTime) FROM mytable WHERE CancellationCode NOT IN ('A', 'B', 'C', 'noodles') OR CancellationCode NOT IN ('A', 'noodles') LIMIT 10000","SELECT AVG(CAST(ArrDelayMinutes AS DOUBLE)) FROM mytable WHERE CancellationCode NOT IN ('A', 'B', 'C', 'noodles') OR CancellationCode NOT IN ('A', 'noodles') LIMIT 10000","SELECT MAX(TaxiOut) FROM mytable WHERE CancellationCode NOT IN ('A', 'B', 'C', 'noodles') OR CancellationCode NOT IN ('A', 'noodles') LIMIT 10000"],"pql" [...]
+{"hsqls":["SELECT SUM(Month) FROM mytable WHERE FirstDepTime <> 1742 AND DestStateName BETWEEN 'Maine' AND 'South Dakota' OR Carrier <= 'UA' LIMIT 10000"],"pql":"SELECT SUM(Month) FROM mytable WHERE FirstDepTime <> 1742 AND DestStateName BETWEEN 'Maine' AND 'South Dakota' OR Carrier <= 'UA' TOP 23"}
+{"hsqls":["SELECT SUM(NASDelay) FROM mytable WHERE CRSDepTime NOT IN (723, 1141) OR DepartureDelayGroups NOT IN (10, 7, 9, 11, 12) LIMIT 10000","SELECT SUM(ArrDelay) FROM mytable WHERE CRSDepTime NOT IN (723, 1141) OR DepartureDelayGroups NOT IN (10, 7, 9, 11, 12) LIMIT 10000"],"pql":"SELECT SUM(NASDelay), SUM(ArrDelay) FROM mytable WHERE CRSDepTime NOT IN (723, 1141) OR DepartureDelayGroups NOT IN (10, 7, 9, 11, 12) TOP 13"}
+{"hsqls":["SELECT SUM(OriginAirportID) FROM mytable WHERE FirstDepTime BETWEEN 612 AND 624 OR ArrDelayMinutes BETWEEN 321.0 AND 996.0 AND Flights IN (1) LIMIT 10000","SELECT COUNT(AirTime) FROM mytable WHERE FirstDepTime BETWEEN 612 AND 624 OR ArrDelayMinutes BETWEEN 321.0 AND 996.0 AND Flights IN (1) LIMIT 10000","SELECT MIN(FirstDepTime) FROM mytable WHERE FirstDepTime BETWEEN 612 AND 624 OR ArrDelayMinutes BETWEEN 321.0 AND 996.0 AND Flights IN (1) LIMIT 10000"],"pql":"SELECT SUM(Orig [...]
+{"hsqls":["SELECT SUM(OriginStateFips) FROM mytable WHERE ArrTime > 858 LIMIT 10000"],"pql":"SELECT SUM(OriginStateFips) FROM mytable WHERE ArrTime > 858 TOP 27"}
+{"hsqls":["SELECT SUM(OriginWac) FROM mytable WHERE ArrTime > 903 AND DivAirportLandings IN (2, 1, 0, 9) OR ArrDelayMinutes NOT IN (7.0) LIMIT 10000","SELECT MIN(Quarter) FROM mytable WHERE ArrTime > 903 AND DivAirportLandings IN (2, 1, 0, 9) OR ArrDelayMinutes NOT IN (7.0) LIMIT 10000","SELECT AVG(CAST(Quarter AS DOUBLE)) FROM mytable WHERE ArrTime > 903 AND DivAirportLandings IN (2, 1, 0, 9) OR ArrDelayMinutes NOT IN (7.0) LIMIT 10000"],"pql":"SELECT SUM(OriginWac), MIN(Quarter), AVG(Q [...]
+{"hsqls":["SELECT SUM(Quarter) FROM mytable WHERE DaysSinceEpoch BETWEEN 16094 AND 16093 OR OriginStateFips >= 41 LIMIT 10000"],"pql":"SELECT SUM(Quarter) FROM mytable WHERE DaysSinceEpoch BETWEEN 16094 AND 16093 OR OriginStateFips >= 41 TOP 8"}
+{"hsqls":["SELECT SUM(SecurityDelay) FROM mytable WHERE (DivTailNums__MV0 < 'N712SW' OR DivTailNums__MV1 < 'N712SW' OR DivTailNums__MV2 < 'N712SW' OR DivTailNums__MV3 < 'N712SW' OR DivTailNums__MV4 < 'N712SW') OR Distance BETWEEN 426 AND 994 AND TaxiIn BETWEEN 65 AND 9 LIMIT 10000"],"pql":"SELECT SUM(SecurityDelay) FROM mytable WHERE DivTailNums < 'N712SW' OR Distance BETWEEN 426 AND 994 AND TaxiIn BETWEEN 65 AND 9 TOP 17"}
+{"hsqls":["SELECT SUM(TaxiOut) FROM mytable WHERE DestWac BETWEEN 2 AND 85 LIMIT 10000","SELECT SUM(ActualElapsedTime) FROM mytable WHERE DestWac BETWEEN 2 AND 85 LIMIT 10000","SELECT SUM(DepDelay) FROM mytable WHERE DestWac BETWEEN 2 AND 85 LIMIT 10000"],"pql":"SELECT SUM(TaxiOut), SUM(ActualElapsedTime), SUM(DepDelay) FROM mytable WHERE DestWac BETWEEN 2 AND 85 TOP 25"}
+{"hsqls":["SELECT SUM(TotalAddGTime) FROM mytable WHERE AirlineID <> 20304 AND Year BETWEEN 2014 AND 2014 AND Quarter IN (1) LIMIT 10000"],"pql":"SELECT SUM(TotalAddGTime) FROM mytable WHERE AirlineID <> 20304 AND Year BETWEEN 2014 AND 2014 AND Quarter IN (1) TOP 16"}
+{"hsqls":["SELECT SUM(WeatherDelay) FROM mytable WHERE DaysSinceEpoch NOT IN (16073, 16090, 16079) AND DivAirportLandings BETWEEN 2 AND 1 OR ArrTimeBlk IN ('2000-2059', '0700-0759', '1100-1159', '1300-1359') LIMIT 10000","SELECT SUM(DepTime) FROM mytable WHERE DaysSinceEpoch NOT IN (16073, 16090, 16079) AND DivAirportLandings BETWEEN 2 AND 1 OR ArrTimeBlk IN ('2000-2059', '0700-0759', '1100-1159', '1300-1359') LIMIT 10000","SELECT MIN(TaxiOut) FROM mytable WHERE DaysSinceEpoch NOT IN (16 [...]
+{"hsqls":["SELECT SUM(WheelsOff) FROM mytable WHERE (DivAirportIDs__MV0 IN (11292, 11986, 12819, 13424, 16271) OR DivAirportIDs__MV1 IN (11292, 11986, 12819, 13424, 16271) OR DivAirportIDs__MV2 IN (11292, 11986, 12819, 13424, 16271) OR DivAirportIDs__MV3 IN (11292, 11986, 12819, 13424, 16271) OR DivAirportIDs__MV4 IN (11292, 11986, 12819, 13424, 16271)) OR FlightNum BETWEEN 4294 AND 5280 LIMIT 10000"],"pql":"SELECT SUM(WheelsOff) FROM mytable WHERE DivAirportIDs IN (11292, 11986, 12819, [...]
+{"hsqls":["SELECT SUM(WheelsOn) FROM mytable WHERE TailNum IN ('N313US', 'N544AA', 'N619AS') LIMIT 10000","SELECT MIN(DistanceGroup) FROM mytable WHERE TailNum IN ('N313US', 'N544AA', 'N619AS') LIMIT 10000","SELECT MAX(CRSArrTime) FROM mytable WHERE TailNum IN ('N313US', 'N544AA', 'N619AS') LIMIT 10000"],"pql":"SELECT SUM(WheelsOn), MIN(DistanceGroup), MAX(CRSArrTime) FROM mytable WHERE TailNum IN ('N313US', 'N544AA', 'N619AS')"}
+{"hsqls":["SELECT SUM(Year) FROM mytable WHERE OriginCityMarketID NOT IN (32457, 33795, 33495, 31049) OR DestWac BETWEEN 65 AND 87 OR OriginState NOT IN ('ND', 'CO') LIMIT 10000","SELECT COUNT(ArrTime) FROM mytable WHERE OriginCityMarketID NOT IN (32457, 33795, 33495, 31049) OR DestWac BETWEEN 65 AND 87 OR OriginState NOT IN ('ND', 'CO') LIMIT 10000"],"pql":"SELECT SUM(Year), COUNT(ArrTime) FROM mytable WHERE OriginCityMarketID NOT IN (32457, 33795, 33495, 31049) OR DestWac BETWEEN 65 AN [...]
+{"hsqls":["SELECT SUM(Year) FROM mytable WHERE WheelsOff > 1737 AND (DivTotalGTimes__MV0 IN (30, 113, 102, 37) OR DivTotalGTimes__MV1 IN (30, 113, 102, 37) OR DivTotalGTimes__MV2 IN (30, 113, 102, 37) OR DivTotalGTimes__MV3 IN (30, 113, 102, 37) OR DivTotalGTimes__MV4 IN (30, 113, 102, 37)) LIMIT 10000","SELECT MAX(DayofMonth) FROM mytable WHERE WheelsOff > 1737 AND (DivTotalGTimes__MV0 IN (30, 113, 102, 37) OR DivTotalGTimes__MV1 IN (30, 113, 102, 37) OR DivTotalGTimes__MV2 IN (30, 113, [...]
+
+# Filtering & Grouping on Aggregation
+{"hsqls":["SELECT OriginStateName, AVG(CAST(DaysSinceEpoch AS DOUBLE)) FROM mytable WHERE DepartureDelayGroups BETWEEN 1 AND -9999 OR (DivAirportIDs__MV0 BETWEEN 15070 AND 14288 OR DivAirportIDs__MV1 BETWEEN 15070 AND 14288 OR DivAirportIDs__MV2 BETWEEN 15070 AND 14288 OR DivAirportIDs__MV3 BETWEEN 15070 AND 14288 OR DivAirportIDs__MV4 BETWEEN 15070 AND 14288) GROUP BY OriginStateName LIMIT 10000"],"pql":"SELECT AVG(DaysSinceEpoch) FROM mytable WHERE DepartureDelayGroups BETWEEN 1 AND -9 [...]
+{"hsqls":["SELECT Distance, SUM(Month) FROM mytable WHERE TaxiOut = 74 OR DayOfWeek IN (3, 6, 5) GROUP BY Distance LIMIT 10000","SELECT Distance, AVG(CAST(ArrDelayMinutes AS DOUBLE)) FROM mytable WHERE TaxiOut = 74 OR DayOfWeek IN (3, 6, 5) GROUP BY Distance LIMIT 10000","SELECT Distance, SUM(TaxiIn) FROM mytable WHERE TaxiOut = 74 OR DayOfWeek IN (3, 6, 5) GROUP BY Distance LIMIT 10000"],"pql":"SELECT SUM(Month), AVG(ArrDelayMinutes), SUM(TaxiIn) FROM mytable WHERE TaxiOut = 74 OR DayOf [...]
+{"hsqls":["SELECT ActualElapsedTime, SUM(DivReachedDest) FROM mytable WHERE DestAirportID BETWEEN 10551 AND 10792 GROUP BY ActualElapsedTime LIMIT 10000","SELECT ActualElapsedTime, MAX(DepDelay) FROM mytable WHERE DestAirportID BETWEEN 10551 AND 10792 GROUP BY ActualElapsedTime LIMIT 10000"],"pql":"SELECT SUM(DivReachedDest), MAX(DepDelay) FROM mytable WHERE DestAirportID BETWEEN 10551 AND 10792 GROUP BY ActualElapsedTime TOP 15"}
+{"hsqls":["SELECT ArrDel15, SUM(DivDistance) FROM mytable WHERE DestState IN ('NC', 'MS', 'MD', 'SC') AND DestState NOT IN ('DE', 'CT', 'CO', 'FL', 'AL') GROUP BY ArrDel15 LIMIT 10000"],"pql":"SELECT SUM(DivDistance) FROM mytable WHERE DestState IN ('NC', 'MS', 'MD', 'SC') AND DestState NOT IN ('DE', 'CT', 'CO', 'FL', 'AL') GROUP BY ArrDel15 TOP 24"}
+{"hsqls":["SELECT ArrDelay, CancellationCode, SUM(LongestAddGTime) FROM mytable WHERE TailNum <= 'N465WN' GROUP BY ArrDelay, CancellationCode LIMIT 10000","SELECT ArrDelay, CancellationCode, COUNT(DestCityMarketID) FROM mytable WHERE TailNum <= 'N465WN' GROUP BY ArrDelay, CancellationCode LIMIT 10000"],"pql":"SELECT SUM(LongestAddGTime), COUNT(DestCityMarketID) FROM mytable WHERE TailNum <= 'N465WN' GROUP BY ArrDelay, CancellationCode TOP 18"}
+{"hsqls":["SELECT ArrDelayMinutes, WheelsOn, ArrivalDelayGroups, SUM(DepDelay) FROM mytable WHERE ArrivalDelayGroups BETWEEN 9 AND 1 OR Distance IN (2724, 73, 2300) GROUP BY ArrDelayMinutes, WheelsOn, ArrivalDelayGroups LIMIT 10000","SELECT ArrDelayMinutes, WheelsOn, ArrivalDelayGroups, MIN(AirlineID) FROM mytable WHERE ArrivalDelayGroups BETWEEN 9 AND 1 OR Distance IN (2724, 73, 2300) GROUP BY ArrDelayMinutes, WheelsOn, ArrivalDelayGroups LIMIT 10000"],"pql":"SELECT SUM(DepDelay), MIN(A [...]
+{"hsqls":["SELECT ArrTime, CRSElapsedTime, SUM(DestAirportID) FROM mytable WHERE ArrTimeBlk > '1000-1059' AND (DivLongestGTimes__MV0 IN (107.0) OR DivLongestGTimes__MV1 IN (107.0) OR DivLongestGTimes__MV2 IN (107.0) OR DivLongestGTimes__MV3 IN (107.0) OR DivLongestGTimes__MV4 IN (107.0)) GROUP BY ArrTime, CRSElapsedTime LIMIT 10000"],"pql":"SELECT SUM(DestAirportID) FROM mytable WHERE ArrTimeBlk > '1000-1059' AND DivLongestGTimes IN (107.0) GROUP BY ArrTime, CRSElapsedTime TOP 15"}
+{"hsqls":["SELECT ArrTimeBlk, DivAirportLandings, SUM(WheelsOn) FROM mytable WHERE ArrDelay BETWEEN 92.0 AND -15.0 AND WheelsOff BETWEEN 1513 AND 910 OR TaxiIn >= 16 GROUP BY ArrTimeBlk, DivAirportLandings LIMIT 10000","SELECT ArrTimeBlk, DivAirportLandings, SUM(CRSDepTime) FROM mytable WHERE ArrDelay BETWEEN 92.0 AND -15.0 AND WheelsOff BETWEEN 1513 AND 910 OR TaxiIn >= 16 GROUP BY ArrTimeBlk, DivAirportLandings LIMIT 10000","SELECT ArrTimeBlk, DivAirportLandings, SUM(OriginAirportID) F [...]
+{"hsqls":["SELECT CRSArrTime, SUM(DayofMonth) FROM mytable WHERE DaysSinceEpoch IN (16095, 16079) AND DivAirportLandings BETWEEN 1 AND 2 OR DestCityName <= 'Tucson, AZ' GROUP BY CRSArrTime LIMIT 10000","SELECT CRSArrTime, SUM(ArrTime) FROM mytable WHERE DaysSinceEpoch IN (16095, 16079) AND DivAirportLandings BETWEEN 1 AND 2 OR DestCityName <= 'Tucson, AZ' GROUP BY CRSArrTime LIMIT 10000"],"pql":"SELECT SUM(DayofMonth), SUM(ArrTime) FROM mytable WHERE DaysSinceEpoch IN (16095, 16079) AND [...]
+{"hsqls":["SELECT CRSDepTime, SUM(WeatherDelay) FROM mytable WHERE WheelsOn BETWEEN 1939 AND 2335 OR Quarter NOT IN (1) GROUP BY CRSDepTime LIMIT 10000","SELECT CRSDepTime, MIN(DestAirportSeqID) FROM mytable WHERE WheelsOn BETWEEN 1939 AND 2335 OR Quarter NOT IN (1) GROUP BY CRSDepTime LIMIT 10000","SELECT CRSDepTime, MAX(DayOfWeek) FROM mytable WHERE WheelsOn BETWEEN 1939 AND 2335 OR Quarter NOT IN (1) GROUP BY CRSDepTime LIMIT 10000"],"pql":"SELECT SUM(WeatherDelay), MIN(DestAirportSeq [...]
+{"hsqls":["SELECT CRSElapsedTime, SUM(ArrivalDelayGroups) FROM mytable WHERE (DivWheelsOffs__MV0 IN (1831, 1337, 1816) OR DivWheelsOffs__MV1 IN (1831, 1337, 1816) OR DivWheelsOffs__MV2 IN (1831, 1337, 1816) OR DivWheelsOffs__MV3 IN (1831, 1337, 1816) OR DivWheelsOffs__MV4 IN (1831, 1337, 1816)) OR CarrierDelay = 235 GROUP BY CRSElapsedTime LIMIT 10000"],"pql":"SELECT SUM(ArrivalDelayGroups) FROM mytable WHERE DivWheelsOffs IN (1831, 1337, 1816) OR CarrierDelay = 235 GROUP BY CRSElapsedTi [...]
+{"hsqls":["SELECT CancellationCode, SUM(WheelsOn) FROM mytable WHERE Quarter NOT IN (1) OR Cancelled BETWEEN 1 AND 0 GROUP BY CancellationCode LIMIT 10000","SELECT CancellationCode, MIN(DaysSinceEpoch) FROM mytable WHERE Quarter NOT IN (1) OR Cancelled BETWEEN 1 AND 0 GROUP BY CancellationCode LIMIT 10000","SELECT CancellationCode, MIN(AirlineID) FROM mytable WHERE Quarter NOT IN (1) OR Cancelled BETWEEN 1 AND 0 GROUP BY CancellationCode LIMIT 10000"],"pql":"SELECT SUM(WheelsOn), MIN(Day [...]
+{"hsqls":["SELECT Cancelled, DivActualElapsedTime, SUM(DepDelay) FROM mytable WHERE DaysSinceEpoch > 16086 OR Flights NOT IN (1) GROUP BY Cancelled, DivActualElapsedTime LIMIT 10000"],"pql":"SELECT SUM(DepDelay) FROM mytable WHERE DaysSinceEpoch > 16086 OR Flights NOT IN (1) GROUP BY Cancelled, DivActualElapsedTime TOP 5"}
+{"hsqls":["SELECT CarrierDelay, ArrivalDelayGroups, SUM(AirTime) FROM mytable WHERE DestAirportID >= 15096 AND DestWac BETWEEN 15 AND 74 OR ArrTime BETWEEN 1941 AND 951 GROUP BY CarrierDelay, ArrivalDelayGroups LIMIT 10000","SELECT CarrierDelay, ArrivalDelayGroups, MIN(CRSDepTime) FROM mytable WHERE DestAirportID >= 15096 AND DestWac BETWEEN 15 AND 74 OR ArrTime BETWEEN 1941 AND 951 GROUP BY CarrierDelay, ArrivalDelayGroups LIMIT 10000","SELECT CarrierDelay, ArrivalDelayGroups, MIN(Arriv [...]
+{"hsqls":["SELECT DayofMonth, SUM(CRSArrTime) FROM mytable WHERE ArrDelay <> 364.0 GROUP BY DayofMonth LIMIT 10000","SELECT DayofMonth, MIN(CRSElapsedTime) FROM mytable WHERE ArrDelay <> 364.0 GROUP BY DayofMonth LIMIT 10000"],"pql":"SELECT SUM(CRSArrTime), MIN(CRSElapsedTime) FROM mytable WHERE ArrDelay <> 364.0 GROUP BY DayofMonth TOP 2"}
+{"hsqls":["SELECT DaysSinceEpoch, DayOfWeek, SUM(FirstDepTime) FROM mytable WHERE Quarter BETWEEN 1 AND 1 AND DestState IN ('UT') GROUP BY DaysSinceEpoch, DayOfWeek LIMIT 10000","SELECT DaysSinceEpoch, DayOfWeek, COUNT(AirTime) FROM mytable WHERE Quarter BETWEEN 1 AND 1 AND DestState IN ('UT') GROUP BY DaysSinceEpoch, DayOfWeek LIMIT 10000","SELECT DaysSinceEpoch, DayOfWeek, MAX(LateAircraftDelay) FROM mytable WHERE Quarter BETWEEN 1 AND 1 AND DestState IN ('UT') GROUP BY DaysSinceEpoch, [...]
+{"hsqls":["SELECT DaysSinceEpoch, SUM(OriginStateFips) FROM mytable WHERE CRSDepTime BETWEEN 2145 AND 2219 AND Month IN (1) GROUP BY DaysSinceEpoch LIMIT 10000"],"pql":"SELECT SUM(OriginStateFips) FROM mytable WHERE CRSDepTime BETWEEN 2145 AND 2219 AND Month IN (1) GROUP BY DaysSinceEpoch TOP 15"}
+{"hsqls":["SELECT DepDel15, SUM(Flights) FROM mytable WHERE ArrivalDelayGroups BETWEEN 12 AND 9 AND Flights IN (1) OR DestCityName = 'Fort Lauderdale, FL' GROUP BY DepDel15 LIMIT 10000","SELECT DepDel15, MIN(DivReachedDest) FROM mytable WHERE ArrivalDelayGroups BETWEEN 12 AND 9 AND Flights IN (1) OR DestCityName = 'Fort Lauderdale, FL' GROUP BY DepDel15 LIMIT 10000"],"pql":"SELECT SUM(Flights), MIN(DivReachedDest) FROM mytable WHERE ArrivalDelayGroups BETWEEN 12 AND 9 AND Flights IN (1) [...]
+{"hsqls":["SELECT DepTimeBlk, SUM(ArrivalDelayGroups) FROM mytable WHERE ArrivalDelayGroups BETWEEN -1 AND 4 GROUP BY DepTimeBlk LIMIT 10000","SELECT DepTimeBlk, COUNT(OriginStateName) FROM mytable WHERE ArrivalDelayGroups BETWEEN -1 AND 4 GROUP BY DepTimeBlk LIMIT 10000","SELECT DepTimeBlk, AVG(CAST(DayofMonth AS DOUBLE)) FROM mytable WHERE ArrivalDelayGroups BETWEEN -1 AND 4 GROUP BY DepTimeBlk LIMIT 10000"],"pql":"SELECT SUM(ArrivalDelayGroups), COUNT(OriginStateName), AVG(DayofMonth) [...]
+{"hsqls":["SELECT DepartureDelayGroups, SUM(DepDelayMinutes) FROM mytable WHERE DestStateName IN ('North Carolina') GROUP BY DepartureDelayGroups LIMIT 10000","SELECT DepartureDelayGroups, MIN(DestAirportSeqID) FROM mytable WHERE DestStateName IN ('North Carolina') GROUP BY DepartureDelayGroups LIMIT 10000"],"pql":"SELECT SUM(DepDelayMinutes), MIN(DestAirportSeqID) FROM mytable WHERE DestStateName IN ('North Carolina') GROUP BY DepartureDelayGroups TOP 6"}
+{"hsqls":["SELECT Dest, SUM(CarrierDelay) FROM mytable WHERE DivReachedDest IN (1, -9999) OR (DivWheelsOffs__MV0 BETWEEN 940 AND 1534 OR DivWheelsOffs__MV1 BETWEEN 940 AND 1534 OR DivWheelsOffs__MV2 BETWEEN 940 AND 1534 OR DivWheelsOffs__MV3 BETWEEN 940 AND 1534 OR DivWheelsOffs__MV4 BETWEEN 940 AND 1534) GROUP BY Dest LIMIT 10000","SELECT Dest, MIN(DestAirportSeqID) FROM mytable WHERE DivReachedDest IN (1, -9999) OR (DivWheelsOffs__MV0 BETWEEN 940 AND 1534 OR DivWheelsOffs__MV1 BETWEEN [...]
+{"hsqls":["SELECT DestAirportID, SUM(TaxiIn) FROM mytable WHERE CRSArrTime <= 1646 GROUP BY DestAirportID LIMIT 10000","SELECT DestAirportID, MIN(Month) FROM mytable WHERE CRSArrTime <= 1646 GROUP BY DestAirportID LIMIT 10000"],"pql":"SELECT SUM(TaxiIn), MIN(Month) FROM mytable WHERE CRSArrTime <= 1646 GROUP BY DestAirportID TOP 21"}
+{"hsqls":["SELECT DestAirportSeqID, DepDel15, ArrivalDelayGroups, SUM(WheelsOff) FROM mytable WHERE DivReachedDest IN (1, 0, -9999) GROUP BY DestAirportSeqID, DepDel15, ArrivalDelayGroups LIMIT 10000"],"pql":"SELECT SUM(WheelsOff) FROM mytable WHERE DivReachedDest IN (1, 0, -9999) GROUP BY DestAirportSeqID, DepDel15, ArrivalDelayGroups TOP 11"}
+{"hsqls":["SELECT DestStateName, DepDel15, Origin, SUM(ArrDelayMinutes) FROM mytable WHERE DestAirportSeqID > 1312702 AND ArrDelayMinutes BETWEEN 14.0 AND 305.0 GROUP BY DestStateName, DepDel15, Origin LIMIT 10000"],"pql":"SELECT SUM(ArrDelayMinutes) FROM mytable WHERE DestAirportSeqID > 1312702 AND ArrDelayMinutes BETWEEN 14.0 AND 305.0 GROUP BY DestStateName, DepDel15, Origin TOP 11"}
+{"hsqls":["SELECT DestWac, SUM(LateAircraftDelay) FROM mytable WHERE FirstDepTime NOT IN (1016, 1301, 731) GROUP BY DestWac LIMIT 10000","SELECT DestWac, AVG(CAST(ArrDelay AS DOUBLE)) FROM mytable WHERE FirstDepTime NOT IN (1016, 1301, 731) GROUP BY DestWac LIMIT 10000","SELECT DestWac, SUM(DayofMonth) FROM mytable WHERE FirstDepTime NOT IN (1016, 1301, 731) GROUP BY DestWac LIMIT 10000"],"pql":"SELECT SUM(LateAircraftDelay), AVG(ArrDelay), SUM(DayofMonth) FROM mytable WHERE FirstDepTime [...]
+{"hsqls":["SELECT Distance, SUM(Month) FROM mytable WHERE TaxiOut = 74 OR DayOfWeek IN (3, 6, 5) GROUP BY Distance LIMIT 10000","SELECT Distance, AVG(CAST(ArrDelayMinutes AS DOUBLE)) FROM mytable WHERE TaxiOut = 74 OR DayOfWeek IN (3, 6, 5) GROUP BY Distance LIMIT 10000","SELECT Distance, SUM(TaxiIn) FROM mytable WHERE TaxiOut = 74 OR DayOfWeek IN (3, 6, 5) GROUP BY Distance LIMIT 10000"],"pql":"SELECT SUM(Month), AVG(ArrDelayMinutes), SUM(TaxiIn) FROM mytable WHERE TaxiOut = 74 OR DayOf [...]
+{"hsqls":["SELECT DistanceGroup, CarrierDelay, AirTime, SUM(LateAircraftDelay) FROM mytable WHERE Dest BETWEEN 'MBS' AND 'LCH' OR (DivAirportSeqIDs__MV0 >= 1489302 OR DivAirportSeqIDs__MV1 >= 1489302 OR DivAirportSeqIDs__MV2 >= 1489302 OR DivAirportSeqIDs__MV3 >= 1489302 OR DivAirportSeqIDs__MV4 >= 1489302) GROUP BY DistanceGroup, CarrierDelay, AirTime LIMIT 10000","SELECT DistanceGroup, CarrierDelay, AirTime, AVG(CAST(FirstDepTime AS DOUBLE)) FROM mytable WHERE Dest BETWEEN 'MBS' AND 'L [...]
+{"hsqls":["SELECT Diverted, SUM(NASDelay) FROM mytable WHERE Cancelled NOT IN (1) OR Distance IN (764, 301, 715, 945) GROUP BY Diverted LIMIT 10000","SELECT Diverted, SUM(FirstDepTime) FROM mytable WHERE Cancelled NOT IN (1) OR Distance IN (764, 301, 715, 945) GROUP BY Diverted LIMIT 10000","SELECT Diverted, COUNT(CRSDepTime) FROM mytable WHERE Cancelled NOT IN (1) OR Distance IN (764, 301, 715, 945) GROUP BY Diverted LIMIT 10000"],"pql":"SELECT SUM(NASDelay), SUM(FirstDepTime), COUNT(CR [...]
+{"hsqls":["SELECT FirstDepTime, NASDelay, SUM(WheelsOff) FROM mytable WHERE DivReachedDest >= 1 GROUP BY FirstDepTime, NASDelay LIMIT 10000","SELECT FirstDepTime, NASDelay, AVG(CAST(DistanceGroup AS DOUBLE)) FROM mytable WHERE DivReachedDest >= 1 GROUP BY FirstDepTime, NASDelay LIMIT 10000"],"pql":"SELECT SUM(WheelsOff), AVG(DistanceGroup) FROM mytable WHERE DivReachedDest >= 1 GROUP BY FirstDepTime, NASDelay TOP 16"}
+{"hsqls":["SELECT FlightDate, SUM(OriginAirportID) FROM mytable WHERE DepDel15 IN (1, 0, -9999) OR DivActualElapsedTime <= 338 GROUP BY FlightDate LIMIT 10000","SELECT FlightDate, SUM(CRSArrTime) FROM mytable WHERE DepDel15 IN (1, 0, -9999) OR DivActualElapsedTime <= 338 GROUP BY FlightDate LIMIT 10000"],"pql":"SELECT SUM(OriginAirportID), SUM(CRSArrTime) FROM mytable WHERE DepDel15 IN (1, 0, -9999) OR DivActualElapsedTime <= 338 GROUP BY FlightDate TOP 18"}
+{"hsqls":["SELECT FlightNum, DestStateFips, DestCityName, SUM(ArrDelay) FROM mytable WHERE SecurityDelay BETWEEN 1 AND 14 GROUP BY FlightNum, DestStateFips, DestCityName LIMIT 10000","SELECT FlightNum, DestStateFips, DestCityName, COUNT(CancellationCode) FROM mytable WHERE SecurityDelay BETWEEN 1 AND 14 GROUP BY FlightNum, DestStateFips, DestCityName LIMIT 10000"],"pql":"SELECT SUM(ArrDelay), COUNT(CancellationCode) FROM mytable WHERE SecurityDelay BETWEEN 1 AND 14 GROUP BY FlightNum, De [...]
+{"hsqls":["SELECT Flights, TotalAddGTime, Cancelled, SUM(DestAirportSeqID) FROM mytable WHERE DestStateFips < 32 OR TaxiIn >= 56 GROUP BY Flights, TotalAddGTime, Cancelled LIMIT 10000"],"pql":"SELECT SUM(DestAirportSeqID) FROM mytable WHERE DestStateFips < 32 OR TaxiIn >= 56 GROUP BY Flights, TotalAddGTime, Cancelled TOP 26"}
+{"hsqls":["SELECT LateAircraftDelay, ArrivalDelayGroups, SUM(DestAirportSeqID) FROM mytable WHERE UniqueCarrier NOT IN ('EV', 'DL', 'AA', 'VX') OR (DivLongestGTimes__MV0 > 108.0 OR DivLongestGTimes__MV1 > 108.0 OR DivLongestGTimes__MV2 > 108.0 OR DivLongestGTimes__MV3 > 108.0 OR DivLongestGTimes__MV4 > 108.0) OR NASDelay BETWEEN 13 AND 14 GROUP BY LateAircraftDelay, ArrivalDelayGroups LIMIT 10000","SELECT LateAircraftDelay, ArrivalDelayGroups, MAX(DestCityMarketID) FROM mytable WHERE Uni [...]
+{"hsqls":["SELECT LongestAddGTime, SUM(DepDelayMinutes) FROM mytable WHERE (DivWheelsOns__MV0 IN (1437, 813, 58, 2357, 140) OR DivWheelsOns__MV1 IN (1437, 813, 58, 2357, 140) OR DivWheelsOns__MV2 IN (1437, 813, 58, 2357, 140) OR DivWheelsOns__MV3 IN (1437, 813, 58, 2357, 140) OR DivWheelsOns__MV4 IN (1437, 813, 58, 2357, 140)) GROUP BY LongestAddGTime LIMIT 10000"],"pql":"SELECT SUM(DepDelayMinutes) FROM mytable WHERE DivWheelsOns IN (1437, 813, 58, 2357, 140) GROUP BY LongestAddGTime TOP 19"}
+{"hsqls":["SELECT Month, SUM(Cancelled) FROM mytable WHERE Dest BETWEEN 'ATL' AND 'PSE' AND UniqueCarrier BETWEEN 'US' AND 'US' OR ArrTimeBlk <= '0800-0859' GROUP BY Month LIMIT 10000","SELECT Month, COUNT(DestAirportID) FROM mytable WHERE Dest BETWEEN 'ATL' AND 'PSE' AND UniqueCarrier BETWEEN 'US' AND 'US' OR ArrTimeBlk <= '0800-0859' GROUP BY Month LIMIT 10000","SELECT Month, AVG(CAST(DepartureDelayGroups AS DOUBLE)) FROM mytable WHERE Dest BETWEEN 'ATL' AND 'PSE' AND UniqueCarrier BET [...]
+{"hsqls":["SELECT NASDelay, SUM(TaxiOut) FROM mytable WHERE CancellationCode > 'C' GROUP BY NASDelay LIMIT 10000","SELECT NASDelay, MAX(Distance) FROM mytable WHERE CancellationCode > 'C' GROUP BY NASDelay LIMIT 10000"],"pql":"SELECT SUM(TaxiOut), MAX(Distance) FROM mytable WHERE CancellationCode > 'C' GROUP BY NASDelay TOP 6"}
+{"hsqls":["SELECT Origin, AirlineID, SUM(AirTime) FROM mytable WHERE OriginState BETWEEN 'MS' AND 'PR' GROUP BY Origin, AirlineID LIMIT 10000","SELECT Origin, AirlineID, COUNT(DaysSinceEpoch) FROM mytable WHERE OriginState BETWEEN 'MS' AND 'PR' GROUP BY Origin, AirlineID LIMIT 10000","SELECT Origin, AirlineID, COUNT(WeatherDelay) FROM mytable WHERE OriginState BETWEEN 'MS' AND 'PR' GROUP BY Origin, AirlineID LIMIT 10000"],"pql":"SELECT SUM(AirTime), COUNT(DaysSinceEpoch), COUNT(WeatherDe [...]
+{"hsqls":["SELECT Origin, SUM(CarrierDelay) FROM mytable WHERE DepDelayMinutes BETWEEN 141.0 AND 192.0 AND DestAirportID IN (11042, 11630, 11481, 10693) GROUP BY Origin LIMIT 10000","SELECT Origin, MAX(DestAirportSeqID) FROM mytable WHERE DepDelayMinutes BETWEEN 141.0 AND 192.0 AND DestAirportID IN (11042, 11630, 11481, 10693) GROUP BY Origin LIMIT 10000","SELECT Origin, SUM(CRSDepTime) FROM mytable WHERE DepDelayMinutes BETWEEN 141.0 AND 192.0 AND DestAirportID IN (11042, 11630, 11481, [...]
+{"hsqls":["SELECT OriginAirportID, SUM(CRSArrTime) FROM mytable WHERE DepDelay IN (270.0) OR OriginCityMarketID BETWEEN 32389 AND 32511 OR CRSDepTime BETWEEN 1028 AND 1408 GROUP BY OriginAirportID LIMIT 10000","SELECT OriginAirportID, MAX(CRSDepTime) FROM mytable WHERE DepDelay IN (270.0) OR OriginCityMarketID BETWEEN 32389 AND 32511 OR CRSDepTime BETWEEN 1028 AND 1408 GROUP BY OriginAirportID LIMIT 10000","SELECT OriginAirportID, MAX(Cancelled) FROM mytable WHERE DepDelay IN (270.0) OR [...]
+{"hsqls":["SELECT OriginAirportSeqID, DestAirportSeqID, CancellationCode, SUM(DayOfWeek) FROM mytable WHERE DestStateFips NOT IN (46) OR UniqueCarrier IN ('US') GROUP BY OriginAirportSeqID, DestAirportSeqID, CancellationCode LIMIT 10000","SELECT OriginAirportSeqID, DestAirportSeqID, CancellationCode, AVG(CAST(DistanceGroup AS DOUBLE)) FROM mytable WHERE DestStateFips NOT IN (46) OR UniqueCarrier IN ('US') GROUP BY OriginAirportSeqID, DestAirportSeqID, CancellationCode LIMIT 10000"],"pql" [...]
+{"hsqls":["SELECT OriginCityMarketID, SUM(Year) FROM mytable WHERE (DivTotalGTimes__MV0 IN (6, 36) OR DivTotalGTimes__MV1 IN (6, 36) OR DivTotalGTimes__MV2 IN (6, 36) OR DivTotalGTimes__MV3 IN (6, 36) OR DivTotalGTimes__MV4 IN (6, 36)) GROUP BY OriginCityMarketID LIMIT 10000"],"pql":"SELECT SUM(Year) FROM mytable WHERE DivTotalGTimes IN (6, 36) GROUP BY OriginCityMarketID TOP 2"}
+{"hsqls":["SELECT OriginCityName, ArrTime, DestAirportID, SUM(LateAircraftDelay) FROM mytable WHERE Month < 1 OR SecurityDelay IN (18, 8, 27) GROUP BY OriginCityName, ArrTime, DestAirportID LIMIT 10000","SELECT OriginCityName, ArrTime, DestAirportID, AVG(CAST(SecurityDelay AS DOUBLE)) FROM mytable WHERE Month < 1 OR SecurityDelay IN (18, 8, 27) GROUP BY OriginCityName, ArrTime, DestAirportID LIMIT 10000"],"pql":"SELECT SUM(LateAircraftDelay), AVG(SecurityDelay) FROM mytable WHERE Month < [...]
+{"hsqls":["SELECT OriginState, Dest, SUM(AirTime) FROM mytable WHERE (DivLongestGTimes__MV0 < 6.0 OR DivLongestGTimes__MV1 < 6.0 OR DivLongestGTimes__MV2 < 6.0 OR DivLongestGTimes__MV3 < 6.0 OR DivLongestGTimes__MV4 < 6.0) AND FlightDate NOT IN ('2014-01-14', '2014-01-13', '2014-01-09', '2014-01-23') GROUP BY OriginState, Dest LIMIT 10000","SELECT OriginState, Dest, SUM(DestAirportSeqID) FROM mytable WHERE (DivLongestGTimes__MV0 < 6.0 OR DivLongestGTimes__MV1 < 6.0 OR DivLongestGTimes__M [...]
+{"hsqls":["SELECT OriginStateFips, Flights, SUM(CarrierDelay) FROM mytable WHERE OriginCityName < 'Pittsburgh, PA' OR ArrTimeBlk IN ('1700-1759', '1000-1059', '0800-0859', '0001-0559') OR DepDelayMinutes IN (337.0, 11.0) GROUP BY OriginStateFips, Flights LIMIT 10000","SELECT OriginStateFips, Flights, MAX(DepDelayMinutes) FROM mytable WHERE OriginCityName < 'Pittsburgh, PA' OR ArrTimeBlk IN ('1700-1759', '1000-1059', '0800-0859', '0001-0559') OR DepDelayMinutes IN (337.0, 11.0) GROUP BY O [...]
+{"hsqls":["SELECT OriginStateFips, SUM(ArrDelay) FROM mytable WHERE OriginCityName >= 'Muskegon, MI' OR CRSDepTime BETWEEN 1558 AND 1336 OR SecurityDelay IN (1, 14) GROUP BY OriginStateFips LIMIT 10000"],"pql":"SELECT SUM(ArrDelay) FROM mytable WHERE OriginCityName >= 'Muskegon, MI' OR CRSDepTime BETWEEN 1558 AND 1336 OR SecurityDelay IN (1, 14) GROUP BY OriginStateFips TOP 6"}
+{"hsqls":["SELECT OriginWac, SUM(TaxiOut) FROM mytable WHERE Quarter IN (1) OR (DivAirportSeqIDs__MV0 IN (1125203) OR DivAirportSeqIDs__MV1 IN (1125203) OR DivAirportSeqIDs__MV2 IN (1125203) OR DivAirportSeqIDs__MV3 IN (1125203) OR DivAirportSeqIDs__MV4 IN (1125203)) GROUP BY OriginWac LIMIT 10000","SELECT OriginWac, AVG(CAST(DayofMonth AS DOUBLE)) FROM mytable WHERE Quarter IN (1) OR (DivAirportSeqIDs__MV0 IN (1125203) OR DivAirportSeqIDs__MV1 IN (1125203) OR DivAirportSeqIDs__MV2 IN (1 [...]
+{"hsqls":["SELECT Quarter, ArrDelay, OriginStateName, SUM(DepDelayMinutes) FROM mytable WHERE ArrDel15 = 0 GROUP BY Quarter, ArrDelay, OriginStateName LIMIT 10000","SELECT Quarter, ArrDelay, OriginStateName, AVG(CAST(DepDelay AS DOUBLE)) FROM mytable WHERE ArrDel15 = 0 GROUP BY Quarter, ArrDelay, OriginStateName LIMIT 10000"],"pql":"SELECT SUM(DepDelayMinutes), AVG(DepDelay) FROM mytable WHERE ArrDel15 = 0 GROUP BY Quarter, ArrDelay, OriginStateName TOP 5"}
+{"hsqls":["SELECT SecurityDelay, ActualElapsedTime, WheelsOn, SUM(Distance) FROM mytable WHERE ActualElapsedTime > 251 GROUP BY SecurityDelay, ActualElapsedTime, WheelsOn LIMIT 10000","SELECT SecurityDelay, ActualElapsedTime, WheelsOn, COUNT(WeatherDelay) FROM mytable WHERE ActualElapsedTime > 251 GROUP BY SecurityDelay, ActualElapsedTime, WheelsOn LIMIT 10000"],"pql":"SELECT SUM(Distance), COUNT(WeatherDelay) FROM mytable WHERE ActualElapsedTime > 251 GROUP BY SecurityDelay, ActualElaps [...]
+{"hsqls":["SELECT SecurityDelay, ArrDel15, ArrivalDelayGroups, SUM(ArrDelay) FROM mytable WHERE LongestAddGTime <> 11 GROUP BY SecurityDelay, ArrDel15, ArrivalDelayGroups LIMIT 10000","SELECT SecurityDelay, ArrDel15, ArrivalDelayGroups, SUM(Quarter) FROM mytable WHERE LongestAddGTime <> 11 GROUP BY SecurityDelay, ArrDel15, ArrivalDelayGroups LIMIT 10000"],"pql":"SELECT SUM(ArrDelay), SUM(Quarter) FROM mytable WHERE LongestAddGTime <> 11 GROUP BY SecurityDelay, ArrDel15, ArrivalDelayGroup [...]
+{"hsqls":["SELECT SecurityDelay, DivArrDelay, SUM(DivAirportLandings) FROM mytable WHERE DestState < 'CA' AND FlightDate IN ('2014-01-12', '2014-01-22', '2014-01-18', '2014-01-11', '2014-01-25') AND LateAircraftDelay < 78 GROUP BY SecurityDelay, DivArrDelay LIMIT 10000","SELECT SecurityDelay, DivArrDelay, AVG(CAST(FlightNum AS DOUBLE)) FROM mytable WHERE DestState < 'CA' AND FlightDate IN ('2014-01-12', '2014-01-22', '2014-01-18', '2014-01-11', '2014-01-25') AND LateAircraftDelay < 78 GR [...]
+{"hsqls":["SELECT TailNum, DivAirportLandings, SUM(DestAirportSeqID) FROM mytable WHERE FlightNum IN (4925, 5156, 4484, 656) AND DivActualElapsedTime BETWEEN 305 AND 363 GROUP BY TailNum, DivAirportLandings LIMIT 10000","SELECT TailNum, DivAirportLandings, SUM(DepDelay) FROM mytable WHERE FlightNum IN (4925, 5156, 4484, 656) AND DivActualElapsedTime BETWEEN 305 AND 363 GROUP BY TailNum, DivAirportLandings LIMIT 10000"],"pql":"SELECT SUM(DestAirportSeqID), SUM(DepDelay) FROM mytable WHERE [...]
+{"hsqls":["SELECT TailNum, SUM(DepDelay) FROM mytable WHERE OriginStateName NOT IN ('Texas', 'Rhode Island') AND DivArrDelay NOT IN (145, 175, 167) GROUP BY TailNum LIMIT 10000","SELECT TailNum, AVG(CAST(WheelsOn AS DOUBLE)) FROM mytable WHERE OriginStateName NOT IN ('Texas', 'Rhode Island') AND DivArrDelay NOT IN (145, 175, 167) GROUP BY TailNum LIMIT 10000"],"pql":"SELECT SUM(DepDelay), AVG(WheelsOn) FROM mytable WHERE OriginStateName NOT IN ('Texas', 'Rhode Island') AND DivArrDelay NO [...]
+{"hsqls":["SELECT TaxiIn, UniqueCarrier, DivActualElapsedTime, SUM(DivActualElapsedTime) FROM mytable WHERE LateAircraftDelay IN (164, 91, 39, 101) GROUP BY TaxiIn, UniqueCarrier, DivActualElapsedTime LIMIT 10000"],"pql":"SELECT SUM(DivActualElapsedTime) FROM mytable WHERE LateAircraftDelay IN (164, 91, 39, 101) GROUP BY TaxiIn, UniqueCarrier, DivActualElapsedTime"}
+{"hsqls":["SELECT TaxiOut, ActualElapsedTime, Dest, SUM(ArrDelayMinutes) FROM mytable WHERE (DivTotalGTimes__MV0 = 13 OR DivTotalGTimes__MV1 = 13 OR DivTotalGTimes__MV2 = 13 OR DivTotalGTimes__MV3 = 13 OR DivTotalGTimes__MV4 = 13) AND (DivAirportSeqIDs__MV0 <= 1385103 OR DivAirportSeqIDs__MV1 <= 1385103 OR DivAirportSeqIDs__MV2 <= 1385103 OR DivAirportSeqIDs__MV3 <= 1385103 OR DivAirportSeqIDs__MV4 <= 1385103) AND DestWac <> 14 GROUP BY TaxiOut, ActualElapsedTime, Dest LIMIT 10000","SELE [...]
+{"hsqls":["SELECT TaxiOut, ArrDel15, SUM(AirTime) FROM mytable WHERE TailNum = 'N76528' OR OriginWac BETWEEN 13 AND 22 GROUP BY TaxiOut, ArrDel15 LIMIT 10000"],"pql":"SELECT SUM(AirTime) FROM mytable WHERE TailNum = 'N76528' OR OriginWac BETWEEN 13 AND 22 GROUP BY TaxiOut, ArrDel15 TOP 9"}
+{"hsqls":["SELECT TotalAddGTime, SUM(ArrDelay) FROM mytable WHERE ArrDelayMinutes > 246.0 AND DayOfWeek < 6 AND AirlineID IN (20398, 19805, 21171, 19977) GROUP BY TotalAddGTime LIMIT 10000"],"pql":"SELECT SUM(ArrDelay) FROM mytable WHERE ArrDelayMinutes > 246.0 AND DayOfWeek < 6 AND AirlineID IN (20398, 19805, 21171, 19977) GROUP BY TotalAddGTime TOP 4"}
+{"hsqls":["SELECT UniqueCarrier, SUM(ArrDelayMinutes) FROM mytable WHERE Distance = 220 GROUP BY UniqueCarrier LIMIT 10000","SELECT UniqueCarrier, MAX(ArrDelayMinutes) FROM mytable WHERE Distance = 220 GROUP BY UniqueCarrier LIMIT 10000","SELECT UniqueCarrier, MIN(DayofMonth) FROM mytable WHERE Distance = 220 GROUP BY UniqueCarrier LIMIT 10000"],"pql":"SELECT SUM(ArrDelayMinutes), MAX(ArrDelayMinutes), MIN(DayofMonth) FROM mytable WHERE Distance = 220 GROUP BY UniqueCarrier TOP 6"}
+{"hsqls":["SELECT WeatherDelay, SUM(DestAirportSeqID) FROM mytable WHERE OriginCityMarketID IN (30431, 32177, 32982, 34236, 34027) OR AirlineID IN (20398, 19393) GROUP BY WeatherDelay LIMIT 10000"],"pql":"SELECT SUM(DestAirportSeqID) FROM mytable WHERE OriginCityMarketID IN (30431, 32177, 32982, 34236, 34027) OR AirlineID IN (20398, 19393) GROUP BY WeatherDelay TOP 17"}
+{"hsqls":["SELECT WeatherDelay, SUM(Diverted) FROM mytable WHERE (DivTailNums__MV0 >= 'N462WN' OR DivTailNums__MV1 >= 'N462WN' OR DivTailNums__MV2 >= 'N462WN' OR DivTailNums__MV3 >= 'N462WN' OR DivTailNums__MV4 >= 'N462WN') GROUP BY WeatherDelay LIMIT 10000"],"pql":"SELECT SUM(Diverted) FROM mytable WHERE DivTailNums >= 'N462WN' GROUP BY WeatherDelay TOP 25"}
+{"hsqls":["SELECT WheelsOff, DestAirportSeqID, DayofMonth, SUM(WheelsOn) FROM mytable WHERE Cancelled NOT IN (1, 0) OR SecurityDelay > -9999 AND DestStateName BETWEEN 'Oklahoma' AND 'South Dakota' GROUP BY WheelsOff, DestAirportSeqID, DayofMonth LIMIT 10000","SELECT WheelsOff, DestAirportSeqID, DayofMonth, SUM(DestWac) FROM mytable WHERE Cancelled NOT IN (1, 0) OR SecurityDelay > -9999 AND DestStateName BETWEEN 'Oklahoma' AND 'South Dakota' GROUP BY WheelsOff, DestAirportSeqID, DayofMont [...]
+{"hsqls":["SELECT WheelsOff, TotalAddGTime, SUM(OriginAirportSeqID) FROM mytable WHERE CancellationCode BETWEEN 'C' AND 'B' OR DayofMonth < 21 OR DivArrDelay BETWEEN 231 AND 1651 GROUP BY WheelsOff, TotalAddGTime LIMIT 10000","SELECT WheelsOff, TotalAddGTime, MAX(DestWac) FROM mytable WHERE CancellationCode BETWEEN 'C' AND 'B' OR DayofMonth < 21 OR DivArrDelay BETWEEN 231 AND 1651 GROUP BY WheelsOff, TotalAddGTime LIMIT 10000"],"pql":"SELECT SUM(OriginAirportSeqID), MAX(DestWac) FROM myt [...]
+{"hsqls":["SELECT WheelsOff, Year, DivArrDelay, SUM(AirlineID) FROM mytable WHERE DestAirportID = 14730 AND FlightDate <> '2014-01-08' AND TailNum <> 'N965WN' GROUP BY WheelsOff, Year, DivArrDelay LIMIT 10000"],"pql":"SELECT SUM(AirlineID) FROM mytable WHERE DestAirportID = 14730 AND FlightDate <> '2014-01-08' AND TailNum <> 'N965WN' GROUP BY WheelsOff, Year, DivArrDelay TOP 11"}
+{"hsqls":["SELECT WheelsOn, DayOfWeek, SUM(DepDelay) FROM mytable WHERE DestAirportSeqID IN (1195302, 1349503, 1425202, 1467903) GROUP BY WheelsOn, DayOfWeek LIMIT 10000","SELECT WheelsOn, DayOfWeek, MAX(AirTime) FROM mytable WHERE DestAirportSeqID IN (1195302, 1349503, 1425202, 1467903) GROUP BY WheelsOn, DayOfWeek LIMIT 10000","SELECT WheelsOn, DayOfWeek, MIN(Distance) FROM mytable WHERE DestAirportSeqID IN (1195302, 1349503, 1425202, 1467903) GROUP BY WheelsOn, DayOfWeek LIMIT 10000"] [...]
+{"hsqls":["SELECT WheelsOn, SUM(ArrDelayMinutes) FROM mytable WHERE TailNum IN ('N3EEAA', 'N646JB', 'N453SW', 'N929DL', 'N913SW') OR Origin <> 'CMI' GROUP BY WheelsOn LIMIT 10000","SELECT WheelsOn, SUM(DaysSinceEpoch) FROM mytable WHERE TailNum IN ('N3EEAA', 'N646JB', 'N453SW', 'N929DL', 'N913SW') OR Origin <> 'CMI' GROUP BY WheelsOn LIMIT 10000","SELECT WheelsOn, AVG(CAST(Flights AS DOUBLE)) FROM mytable WHERE TailNum IN ('N3EEAA', 'N646JB', 'N453SW', 'N929DL', 'N913SW') OR Origin <> 'C [...]
+{"hsqls":["SELECT WheelsOn, SUM(Year) FROM mytable WHERE (DivAirports__MV0 IN ('TUS', 'DAY', 'TWF') OR DivAirports__MV1 IN ('TUS', 'DAY', 'TWF') OR DivAirports__MV2 IN ('TUS', 'DAY', 'TWF') OR DivAirports__MV3 IN ('TUS', 'DAY', 'TWF') OR DivAirports__MV4 IN ('TUS', 'DAY', 'TWF')) OR CRSDepTime NOT IN (735, 813, 1042, 946) OR DestAirportID NOT IN (12523, 10185, 11612, 12888, 13367) GROUP BY WheelsOn LIMIT 10000"],"pql":"SELECT SUM(Year) FROM mytable WHERE DivAirports IN ('TUS', 'DAY', 'TW [...]
+{"hsqls":["SELECT Year, AirlineID, SUM(DivReachedDest) FROM mytable WHERE DaysSinceEpoch IN (16078, 16091) AND WheelsOff <> 1536 GROUP BY Year, AirlineID LIMIT 10000","SELECT Year, AirlineID, MAX(FlightNum) FROM mytable WHERE DaysSinceEpoch IN (16078, 16091) AND WheelsOff <> 1536 GROUP BY Year, AirlineID LIMIT 10000","SELECT Year, AirlineID, MIN(DayofMonth) FROM mytable WHERE DaysSinceEpoch IN (16078, 16091) AND WheelsOff <> 1536 GROUP BY Year, AirlineID LIMIT 10000"],"pql":"SELECT SUM(D [...]
+{"hsqls":["SELECT Year, ArrDelayMinutes, SUM(CRSDepTime) FROM mytable WHERE DepDelay = 109.0 AND DivArrDelay < 85 GROUP BY Year, ArrDelayMinutes LIMIT 10000","SELECT Year, ArrDelayMinutes, MAX(DepartureDelayGroups) FROM mytable WHERE DepDelay = 109.0 AND DivArrDelay < 85 GROUP BY Year, ArrDelayMinutes LIMIT 10000","SELECT Year, ArrDelayMinutes, MIN(ArrivalDelayGroups) FROM mytable WHERE DepDelay = 109.0 AND DivArrDelay < 85 GROUP BY Year, ArrDelayMinutes LIMIT 10000"],"pql":"SELECT SUM(C [...]
+{"hsqls":["SELECT Year, ArrTime, SUM(DistanceGroup) FROM mytable WHERE DestAirportID NOT IN (11076, 14193) AND DestWac <= 86 AND ArrTime = 1343 GROUP BY Year, ArrTime LIMIT 10000"],"pql":"SELECT SUM(DistanceGroup) FROM mytable WHERE DestAirportID NOT IN (11076, 14193) AND DestWac <= 86 AND ArrTime = 1343 GROUP BY Year, ArrTime TOP 1"}
+{"hsqls":["SELECT Year, CancellationCode, SUM(LongestAddGTime) FROM mytable WHERE DayofMonth BETWEEN 27 AND 6 OR LongestAddGTime NOT IN (20, 29) AND DestAirportID >= 10170 GROUP BY Year, CancellationCode LIMIT 10000","SELECT Year, CancellationCode, SUM(DivReachedDest) FROM mytable WHERE DayofMonth BETWEEN 27 AND 6 OR LongestAddGTime NOT IN (20, 29) AND DestAirportID >= 10170 GROUP BY Year, CancellationCode LIMIT 10000"],"pql":"SELECT SUM(LongestAddGTime), SUM(DivReachedDest) FROM mytable [...]
+{"hsqls":["SELECT Year, DayOfWeek, SUM(CRSArrTime) FROM mytable WHERE DestState IN ('TX', 'MS', 'IL', 'MI') OR WeatherDelay IN (2, 10, 30, 62, 177) GROUP BY Year, DayOfWeek LIMIT 10000","SELECT Year, DayOfWeek, MIN(WheelsOff) FROM mytable WHERE DestState IN ('TX', 'MS', 'IL', 'MI') OR WeatherDelay IN (2, 10, 30, 62, 177) GROUP BY Year, DayOfWeek LIMIT 10000"],"pql":"SELECT SUM(CRSArrTime), MIN(WheelsOff) FROM mytable WHERE DestState IN ('TX', 'MS', 'IL', 'MI') OR WeatherDelay IN (2, 10, [...]
+{"hsqls":["SELECT Year, DepDelayMinutes, ArrDel15, SUM(OriginAirportID) FROM mytable WHERE FlightDate BETWEEN '2014-01-06' AND '2014-01-09' GROUP BY Year, DepDelayMinutes, ArrDel15 LIMIT 10000","SELECT Year, DepDelayMinutes, ArrDel15, AVG(CAST(Diverted AS DOUBLE)) FROM mytable WHERE FlightDate BETWEEN '2014-01-06' AND '2014-01-09' GROUP BY Year, DepDelayMinutes, ArrDel15 LIMIT 10000"],"pql":"SELECT SUM(OriginAirportID), AVG(Diverted) FROM mytable WHERE FlightDate BETWEEN '2014-01-06' AND [...]
+{"hsqls":["SELECT Year, FlightNum, SUM(DestCityMarketID) FROM mytable WHERE DepTime IN (2222, 1323, 1310, 1604) GROUP BY Year, FlightNum LIMIT 10000"],"pql":"SELECT SUM(DestCityMarketID) FROM mytable WHERE DepTime IN (2222, 1323, 1310, 1604) GROUP BY Year, FlightNum TOP 0"}
+{"hsqls":["SELECT Year, LongestAddGTime, SUM(NASDelay) FROM mytable WHERE CRSElapsedTime BETWEEN 257 AND 224 AND DayofMonth NOT IN (20, 18, 13) OR DepTimeBlk >= '1600-1659' GROUP BY Year, LongestAddGTime LIMIT 10000","SELECT Year, LongestAddGTime, MAX(ActualElapsedTime) FROM mytable WHERE CRSElapsedTime BETWEEN 257 AND 224 AND DayofMonth NOT IN (20, 18, 13) OR DepTimeBlk >= '1600-1659' GROUP BY Year, LongestAddGTime LIMIT 10000","SELECT Year, LongestAddGTime, AVG(CAST(DestWac AS DOUBLE)) [...]
+{"hsqls":["SELECT Year, SUM(NASDelay) FROM mytable WHERE Cancelled = 0 AND OriginAirportID IN (11503, 11884, 12891, 12206) AND Cancelled BETWEEN 0 AND 0 GROUP BY Year LIMIT 10000","SELECT Year, AVG(CAST(CRSElapsedTime AS DOUBLE)) FROM mytable WHERE Cancelled = 0 AND OriginAirportID IN (11503, 11884, 12891, 12206) AND Cancelled BETWEEN 0 AND 0 GROUP BY Year LIMIT 10000"],"pql":"SELECT SUM(NASDelay), AVG(CRSElapsedTime) FROM mytable WHERE Cancelled = 0 AND OriginAirportID IN (11503, 11884, [...]
\ No newline at end of file
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org