How do I build this complex sql?

How do I build this complex sql?

References

Reference NO 1

http://programmers.stackexchange.com/questions/144602/how-do-i-make-complex-sql-queries-easier-to-write

Reference NO 2

http://www.codeproject.com/Articles/13419/SelectQueryBuilder-Building-complex-and-flexible-S

Reference NO 3

http://pivotallabs.com/using-arel-to-build-complex-sql-expressions/

Reference NO 4

http://stackoverflow.com/questions/7853141/build-complex-rails-sql

Reference NO 5

http://stackoverflow.com/questions/10282780/trying-to-build-an-sql-statement-for-complex-search-scenario-comparison

Reference NO 6

http://my.safaribooksonline.com/book/databases/postgressql/0672322609/an-introduction-to-sql/ch03lev1sec7

Reference NO 7

http://www.perlmonks.org/?node_id=196672

Reference NO 8

http://internet.wonderhowto.com/how-to/build-complex-sql-queries-with-dreamcoder-for-mysql-249435/