--
-- Stating new run
--
/***** query 1 *****/
SELECT
COUNT(t2.int_col) AS int_col_1
FROM alltypesagg t1
INNER JOIN alltypes t2 ON t2.tinyint_col = t1.id AND t2.int_col = t1.day AND t2.year = t1.tinyint_col
RIGHT JOIN alltypes t3 ON t3.string_col = t1.string_col;
/***** query 2 *****/
SELECT
t1.month AS int_col_1
FROM alltypestiny t1
RIGHT JOIN alltypestiny t2 ON t2.date_string_col = t1.string_col
INNER JOIN alltypes t3 ON t3.string_col = t2.date_string_col;
/***** query 3 *****/
SELECT
MAX(t1.smallint_col) AS smallint_col_1
FROM alltypesagg t1
INNER JOIN alltypestiny t2 ON t2.bigint_col = t1.day AND t2.tinyint_col = t1.tinyint_col;
/***** query 4 *****/
SELECT
MAX(t2.year) AS int_col_1
FROM alltypestiny t1
INNER JOIN alltypesagg t2 ON t2.int_col = t1.month AND t2.year = t1.tinyint_col AND t2.string_col = t1.string_col
INNER JOIN alltypestiny t3 ON t3.bigint_col = t1.year
LEFT JOIN alltypes t4 ON t4.bigint_col = t2.bigint_col;
/***** query 5 *****/
SELECT
COUNT(t1.string_col) AS int_col_1
FROM alltypes t1
INNER JOIN alltypestiny t2 ON t2.date_string_col = t1.date_string_col;
/***** query 6 *****/
SELECT
t1.date_string_col AS string_col_1
FROM alltypes t1
INNER JOIN alltypesagg t2 ON t2.id = t1.year;
/***** query 7 *****/
SELECT
SUM(t1.tinyint_col) AS tinyint_col_1
FROM alltypes t1
INNER JOIN alltypesagg t2 ON t2.smallint_col = t1.int_col
LEFT JOIN alltypes t3 ON t3.bigint_col = t1.month;
/***** query 8 *****/
SELECT
t1.int_col AS int_col_1
FROM alltypesagg t1
INNER JOIN alltypestiny t2 ON t2.int_col = t1.year
INNER JOIN alltypes t3 ON t3.id = t2.bigint_col;
/***** query 9 *****/
SELECT
COUNT(t2.date_string_col) AS int_col_1
FROM alltypestiny t1
LEFT JOIN alltypes t2 ON t2.int_col = t1.tinyint_col;
/***** query 10 *****/
SELECT
COUNT(t2.tinyint_col) AS int_col_1
FROM alltypestiny t1
INNER JOIN alltypestiny t2 ON t2.smallint_col = t1.month AND t2.string_col = t1.string_col AND t2.year = t1.year;
/***** query 11 *****/
SELECT
MIN(t5.tinyint_col) AS tinyint_col_1
FROM alltypes t1
INNER JOIN alltypestiny t2 ON t2.bigint_col = t1.month AND t2.string_col = t1.string_col
INNER JOIN alltypes t3 ON t3.bigint_col = t2.month
INNER JOIN alltypestiny t4 ON t4.date_string_col = t2.string_col
INNER JOIN alltypestiny t5 ON t5.year = t4.month
INNER JOIN alltypestiny t6 ON t6.tinyint_col = t5.id
INNER JOIN alltypesagg t7 ON t7.id = t2.smallint_col;
/***** query 12 *****/
SELECT
SUM(t1.tinyint_col) AS tinyint_col_1
FROM alltypesagg t1
LEFT JOIN alltypes t2 ON t2.smallint_col = t1.year AND t2.date_string_col = t1.date_string_col
INNER JOIN alltypestiny t3 ON t3.string_col = t1.date_string_col
RIGHT JOIN alltypesagg t4 ON t4.month = t3.month;
/***** query 13 *****/
SELECT
t3.month AS int_col_1
FROM alltypes t1
FULL OUTER JOIN alltypestiny t2 ON t2.month = t1.smallint_col AND t2.date_string_col = t1.string_col
INNER JOIN alltypes t3 ON t3.string_col = t1.date_string_col;
/***** query 14 *****/
SELECT
t1.id AS int_col_1
FROM alltypes t1
INNER JOIN alltypestiny t2 ON t2.int_col = t1.year;
/***** query 15 *****/
SELECT
t2.id AS int_col_1
FROM alltypes t1
INNER JOIN alltypestiny t2 ON t2.date_string_col = t1.date_string_col;
/***** query 16 *****/
SELECT
t1.id AS int_col_1
FROM alltypes t1
INNER JOIN alltypes t2 ON t2.month = t1.tinyint_col
INNER JOIN alltypesagg t3 ON t3.string_col = t1.date_string_col
INNER JOIN alltypestiny t4 ON t4.int_col = t3.year
RIGHT JOIN alltypestiny t5 ON t5.string_col = t1.string_col
INNER JOIN alltypestiny t6 ON t6.smallint_col = t1.month AND t6.int_col = t2.smallint_col AND t6.date_string_col = t4.date_string_col;
/***** query 17 *****/
SELECT
MAX(t4.tinyint_col) AS tinyint_col_1
FROM alltypes t1
INNER JOIN alltypestiny t2 ON t2.string_col = t1.string_col
RIGHT JOIN alltypesagg t3 ON t3.date_string_col = t1.string_col
INNER JOIN alltypesagg t4 ON t4.string_col = t1.string_col;
/***** query 18 *****/
SELECT
COUNT(t1.string_col) AS int_col_1
FROM alltypesagg t1
INNER JOIN alltypestiny t2 ON t2.smallint_col = t1.int_col AND t2.date_string_col = t1.date_string_col AND t2.string_col = t1.string_col;
/***** query 19 *****/
SELECT
t2.date_string_col AS string_col_1
FROM alltypesagg t1
RIGHT JOIN alltypestiny t2 ON t2.date_string_col = t1.string_col AND t2.year = t1.int_col;
/***** query 20 *****/
SELECT
MAX(t2.smallint_col) AS smallint_col_1
FROM alltypesagg t1
INNER JOIN alltypes t2 ON t2.string_col = t1.string_col
INNER JOIN alltypes t3 ON t3.date_string_col = t2.string_col AND t3.string_col = t1.date_string_col;
/***** query 21 *****/
SELECT
MAX(t2.year) AS int_col_1
FROM alltypes t1
INNER JOIN alltypesagg t2 ON t2.string_col = t1.string_col;
/***** query 22 *****/
SELECT
COUNT(t2.date_string_col) AS int_col_1
FROM alltypestiny t1
INNER JOIN alltypesagg t2 ON t2.day = t1.int_col AND t2.date_string_col = t1.date_string_col;
/***** query 23 *****/
SELECT
SUM(t3.smallint_col) AS smallint_col_1
FROM alltypes t1
INNER JOIN alltypesagg t2 ON t2.day = t1.smallint_col AND t2.date_string_col = t1.date_string_col
INNER JOIN alltypes t3 ON t3.date_string_col = t1.date_string_col;