join inner-join
join HAVING-clause sub-queries SELECT-clause FROM-clause
join cross-join inner-join SELECT-clause FROM-clause
join COUNT-Function NULL-values distinct
join WHERE-clause