A complex sql query is a combination of many joins and subqueries. Complex queries are the queries which are the longer than other query. That means ,it can be said that when we have many tables and attributes together in a sql then it can be considered as complicated sql query .

SQL queries can be complicated with addtional case,  subqueries , UNION and so on.There are also stored procedures and triggers in most implimentation  of sql.