SQL and R
The best of SQL and R Programming
Read about Having.
Read about Order By.
Read about Logical Operators: And, Or, Not, In, Like, Between, Greater Than Less Than, Exists.
Read about Top N [Percent].
Read about Union and Union All here.
What I think of Group By…
Read about CRAN webpages – Task Views.