avoid subqueries and 4 self joins - better pre-filtering of data
avoid subqueries and 4 self joins - better pre-filtering of data

intel-hadoop/Big-Data-Benchmark-for-Big-Bench,intel-hadoop/Big-Data-Benchmark-for-Big-Bench