ib_q00.sql:# METACOMMAND - SHOW TABLE STATUS
ib_q01.sql:# COUNT
ib_q02.sql:# DISTINCT
ib_q03.sql:# COUNT DISTINCT
ib_q04.sql:# DISTINCT, ORDER BY
ib_q05.sql:# DISTINCT, COUNT, GROUP BY, ORDER BY DESC
ib_q06.sql:# DISTINCT, COUNT, SUM, GROUP BY, ORDER BY DESC
ib_q07.sql:# SUM, COUNT, JOIN in FROM, EQ FILTER
ib_q08.sql:# SUM, COUNT, JOIN in FROM, EQ FILTER, GROUP BY
ib_q09.sql:# THREE TABLES, SUM, DATE RANGE, LIKE and JOIN in WHERE, MULTIPLE GROUP BY
ib_q10.sql:# SUM, JOIN in FROM, ISNULL in WHERE, GROUP BY, ORDER BY DESC, LIMIT 5
ib_q11.sql:# SUM, COMPARATORS - MULTIPLE ORs
ib_q12.sql:# SUM, DATERANGE, JOIN in FROM
ib_q13.sql:# FULL SCAN FACT TABLE with LIMIT 10000,5
ib_q14.sql:# FULL SCAN FACT TABLE with LIMIT 9000000,1
ib_q15.sql:# COMPARATORS - IN LIST
ib_q16.sql:# COMPARATORS - GTE and LTE
ib_q17.sql:# COMPARATORS - BETWEEN
ib_q18.sql:# COMPARATORS - NOT BETWEEN
ib_q19.sql:# LOJ (LEFT OUTER JOIN)
ib_q20.sql:# SUM, COMPARATORS - BETWEEN and GT, GROUP BY
ib_q21.sql:# DISTINCT, COMPARATORS - BETWEEN and GT, ORDER BY DESC
ib_q22.sql:# SUM, COMPARATORS - BETWEEN and GT, GROUP BY, ORDER BY DESC
ib_q23.sql:# SUM, COMPARATORS - BETWEEN and GT, GROUP BY, HAVING
ib_q24.sql:# SUM, COMPARATORS - BETWEEN and GT, GROUP BY, HAVING, ORDER BY DESC
ib_q25.sql:# COUNT, JOIN in FROM, COMPARATORS - BETWEEN and GT (same results as subquery)
ib_q26.sql:# COUNT, JOIN in FROM, COMPARATORS - BETWEEN and GT, GROUP BY
ib_q27.sql:# DISTINCT, JOIN in FROM, COMPARATORS - BETWEEN and GT, ORDER BY DESC
ib_q28.sql:# COUNT, JOIN in FROM, COMPARATORS - BETWEEN and GT, GROUP BY, ORDER BY DESC
ib_q29.sql:# COUNT, JOIN in WHERE, COMPARATORS - BETWEEN, GT and EQ, GROUP BY, HAVING
ib_q30.sql:# COUNT, JOIN in WHERE, COMPARATORS - BETWEEN, GT and EQ, GROUP BY, HAVING, ORDER BY DESC
ib_q31.sql:# COUNT, JOIN in FROM, COMPARATORS - BETWEEN, GT and EQ, GROUP BY, HAVING
ib_q32.sql:# COUNT, JOIN in FROM, COMPARATORS - BETWEEN, GT and EQ, GROUP BY, HAVING, ORDER BY DESC
ib_q33.sql:# THREE TABLES, JOIN in FROM, COMPARATORS - BETWEEN and EQ (same results as multi-level subquery)
ib_q34.sql:# THREE TABLES, AVG, JOIN in FROM, COMPARATORS - BETWEEN and EQ, GROUP BY
ib_q35.sql:# THREE TABLES, JOIN in FROM, COMPARATORS - BETWEEN and EQ, ORDER BY DESC
ib_q36.sql:# THREE TABLES, AVG, JOIN in FROM, COMPARATORS - BETWEEN and EQ, GROUP BY, ORDER BY DESC
ib_q37.sql:# THREE TABLES, AVG, JOIN in FROM, COMPARATORS - BETWEEN and EQ, GROUP BY, HAVING
ib_q38.sql:# THREE TABLES, AVG, JOIN in FROM, COMPARATORS - BETWEEN and EQ, GROUP BY, HAVING, ORDER BY DESC
ib_q39.sql:# DISTINCT, COMPARATORs - BETWEEN and GT, IN (SUBQUERY), ORDER BY
ib_q40.sql:# COUNT, COMPARATORs - BETWEEN and GT, IN (SUBQUERY)
ib_q41.sql:# COUNT, COMPARATORs - BETWEEN and GT, IN (SUBQUERY), GROUP BY
ib_q42.sql:# COUNT, COMPARATORs - BETWEEN and GT, IN (SUBQUERY), GROUP BY, ORDER BY
ib_q43.sql:# COUNT, COMPARATORs - BETWEEN and GT, IN (SUBQUERY), GROUP BY, HAVING
ib_q44.sql:# COUNT, COMPARATORs - BETWEEN and GT, IN (SUBQUERY), GROUP BY, HAVING, ORDER BY DESC
ib_q45.sql:# COMPARATORS - BETWEEN and EQ, MULTIPLE and NESTED SUBQUERIES, ORDER BY DESC
ib_q46.sql:# AVG, COMPARATORS - BETWEEN and EQ, MULTIPLE and NESTED SUBQUERIES
ib_q47.sql:# AVG, COMPARATORS - BETWEEN and EQ, MULTIPLE and NESTED SUBQUERIES, GROUP BY
ib_q48.sql:# AVG, COMPARATORS - BETWEEN and EQ, MULTIPLE and NESTED SUBQUERIES, GROUP BY, ORDER BY DESC
ib_q49.sql:# AVG, COMPARATORS - BETWEEN and EQ, MULTIPLE and NESTED SUBQUERIES, GROUP BY, HAVING
ib_q50.sql:# MULTI-LEVEL SUB-QUERY, GROUP BY, HAVING, ORDER BY DESC
ib_q51.sql:# AVG, SUBQUERY (SUM, BETWEEN, GROUP BY) as FROM
ib_q52.sql:# CREATE and SELECT from VIEW (SAME RESULT SET AS Query 40)
ib_q53.sql:# UNION ALL (with AVG, BETWEEN)
ib_q54.sql:# DATE/TIME FUNCTIONS (with AVG)
mi_q00.sql:# METACOMMAND - SHOW TABLE STATUS
mi_q01.sql:# COUNT
mi_q02.sql:# DISTINCT
mi_q03.sql:# COUNT DISTINCT
mi_q04.sql:# DISTINCT, ORDER BY
mi_q05.sql:# DISTINCT, COUNT, GROUP BY, ORDER BY DESC
mi_q06.sql:# DISTINCT, COUNT, SUM, GROUP BY, ORDER BY DESC
mi_q07.sql:# SUM, COUNT, JOIN in FROM, EQ FILTER
mi_q08.sql:# SUM, COUNT, JOIN in FROM, EQ FILTER, GROUP BY
mi_q09.sql:# THREE TABLES, SUM, DATE RANGE, LIKE and JOIN in WHERE, MULTIPLE GROUP BY
mi_q10.sql:# SUM, JOIN in FROM, ISNULL in WHERE, GROUP BY, ORDER BY DESC, LIMIT 5
mi_q11.sql:# SUM, COMPARATORS - MULTIPLE ORs
mi_q12.sql:# SUM, DATERANGE, JOIN in FROM
mi_q13.sql:# FULL SCAN FACT TABLE with LIMIT 10000,5
mi_q14.sql:# FULL SCAN FACT TABLE with LIMIT 9000000,1
mi_q15.sql:# COMPARATORS - IN LIST
mi_q16.sql:# COMPARATORS - GTE and LTE
mi_q17.sql:# COMPARATORS - BETWEEN
mi_q18.sql:# COMPARATORS - NOT BETWEEN
mi_q19.sql:# LOJ (LEFT OUTER JOIN)
mi_q20.sql:# SUM, COMPARATORS - BETWEEN and GT, GROUP BY
mi_q21.sql:# DISTINCT, COMPARATORS - BETWEEN and GT, ORDER BY DESC
mi_q22.sql:# SUM, COMPARATORS - BETWEEN and GT, GROUP BY, ORDER BY DESC
mi_q23.sql:# SUM, COMPARATORS - BETWEEN and GT, GROUP BY, HAVING
mi_q24.sql:# SUM, COMPARATORS - BETWEEN and GT, GROUP BY, HAVING, ORDER BY DESC
mi_q25.sql:# COUNT, JOIN in FROM, COMPARATORS - BETWEEN and GT (same results as subquery)
mi_q26.sql:# COUNT, JOIN in FROM, COMPARATORS - BETWEEN and GT, GROUP BY
mi_q27.sql:# DISTINCT, JOIN in FROM, COMPARATORS - BETWEEN and GT, ORDER BY DESC
mi_q28.sql:# COUNT, JOIN in FROM, COMPARATORS - BETWEEN and GT, GROUP BY, ORDER BY DESC
mi_q29.sql:# COUNT, JOIN in WHERE, COMPARATORS - BETWEEN, GT and EQ, GROUP BY, HAVING
mi_q30.sql:# COUNT, JOIN in WHERE, COMPARATORS - BETWEEN, GT and EQ, GROUP BY, HAVING, ORDER BY DESC
mi_q31.sql:# COUNT, JOIN in FROM, COMPARATORS - BETWEEN, GT and EQ, GROUP BY, HAVING
mi_q32.sql:# COUNT, JOIN in FROM, COMPARATORS - BETWEEN, GT and EQ, GROUP BY, HAVING, ORDER BY DESC
mi_q33.sql:# THREE TABLES, JOIN in FROM, COMPARATORS - BETWEEN and EQ (same results as multi-level subquery)
mi_q34.sql:# THREE TABLES, AVG, JOIN in FROM, COMPARATORS - BETWEEN and EQ, GROUP BY
mi_q35.sql:# THREE TABLES, JOIN in FROM, COMPARATORS - BETWEEN and EQ, ORDER BY DESC
mi_q36.sql:# THREE TABLES, AVG, JOIN in FROM, COMPARATORS - BETWEEN and EQ, GROUP BY, ORDER BY DESC
mi_q37.sql:# THREE TABLES, AVG, JOIN in FROM, COMPARATORS - BETWEEN and EQ, GROUP BY, HAVING
mi_q38.sql:# THREE TABLES, AVG, JOIN in FROM, COMPARATORS - BETWEEN and EQ, GROUP BY, HAVING, ORDER BY DESC
mi_q39.sql:# DISTINCT, COMPARATORs - BETWEEN and GT, IN (SUBQUERY), ORDER BY
mi_q40.sql:# COUNT, COMPARATORs - BETWEEN and GT, IN (SUBQUERY)
mi_q41.sql:# COUNT, COMPARATORs - BETWEEN and GT, IN (SUBQUERY), GROUP BY
mi_q42.sql:# COUNT, COMPARATORs - BETWEEN and GT, IN (SUBQUERY), GROUP BY, ORDER BY
mi_q43.sql:# COUNT, COMPARATORs - BETWEEN and GT, IN (SUBQUERY), GROUP BY, HAVING
mi_q44.sql:# COUNT, COMPARATORs - BETWEEN and GT, IN (SUBQUERY), GROUP BY, HAVING, ORDER BY DESC
mi_q45.sql:# COMPARATORS - BETWEEN and EQ, MULTIPLE and NESTED SUBQUERIES, ORDER BY DESC
mi_q46.sql:# AVG, COMPARATORS - BETWEEN and EQ, MULTIPLE and NESTED SUBQUERIES
mi_q47.sql:# AVG, COMPARATORS - BETWEEN and EQ, MULTIPLE and NESTED SUBQUERIES, GROUP BY
mi_q48.sql:# AVG, COMPARATORS - BETWEEN and EQ, MULTIPLE and NESTED SUBQUERIES, GROUP BY, ORDER BY DESC
mi_q49.sql:# AVG, COMPARATORS - BETWEEN and EQ, MULTIPLE and NESTED SUBQUERIES, GROUP BY, HAVING
mi_q50.sql:# MULTI-LEVEL SUB-QUERY, GROUP BY, HAVING, ORDER BY DESC
mi_q51.sql:# AVG, SUBQUERY (SUM, BETWEEN, GROUP BY) as FROM
mi_q52.sql:# CREATE and SELECT from VIEW (SAME RESULT SET AS Query 40)
mi_q53.sql:# UNION ALL (with AVG, BETWEEN)
mi_q54.sql:# DATE/TIME FUNCTIONS (with AVG)