JOIN with HAVING clause
JOIN with GROUP BY
JOIN with aggregate functions
JOIN with views
JOIN with subquery