-- EMP7 Benchmark - SQL script -ClickHouse version
-- v.1.0.2
-- Copyright (C) 2006-2019 mail@meo.bogliolo.name

use test;

drop table if exists emp7;

create table emp7(empno integer, ename String, job String,
	mgr integer, hiredate DATE, sal float, comm float, deptno integer)
 engine=MergeTree
 order by empno;

insert into emp7(empno, ename, deptno) values(7369, 'SMITH', 10);
insert into emp7(empno, ename, deptno) values(7499, 'ALLEN', 10);
insert into emp7(empno, ename, deptno) values(7521, 'WARD',  10);
insert into emp7(empno, ename, deptno) values(7566, 'JONES', 10);
insert into emp7(empno, ename, deptno) values(7654, 'MARTIN',10);
insert into emp7(empno, ename, deptno) values(7698, 'BLAKE', 10);
insert into emp7(empno, ename, deptno) values(7782, 'CLARK', 10);
insert into emp7(empno, ename, deptno) values(7788, 'SCOTT', 10);
insert into emp7(empno, ename, deptno) values(7839, 'KING',  10);
insert into emp7(empno, ename, deptno) values(7844, 'TURNER',10);
insert into emp7(empno, ename, deptno) values(7876, 'ADAMS', 10);
insert into emp7(empno, ename, deptno) values(7900, 'JAMES', 10);
insert into emp7(empno, ename, deptno) values(7902, 'FORD',  10);
insert into emp7(empno, ename, deptno) values(7934, 'MILLER',10);

set joined_subquery_requires_alias=0;

SELECT count(*)
FROM emp7 AS emp1 
INNER JOIN 
(
    SELECT *
    FROM emp7 AS emp2 
    INNER JOIN 
    (
        SELECT *
        FROM emp7 AS emp3 
        INNER JOIN 
        (
            SELECT *
            FROM emp7 AS emp4 
            INNER JOIN 
            (
                SELECT *
                FROM emp7 AS emp5 
                INNER JOIN 
                (
                    SELECT *
                    FROM emp7 AS emp6 
                    INNER JOIN 
                    (
                        SELECT *
                        FROM emp7 AS emp_7 
                    ) ON 1 = 1
                ) ON 1 = 1
            ) ON 1 = 1
        ) ON 1 = 1
    ) ON 1 = 1
) ON 1 = 1;