Pregunta de entrevista de scandiweb

MySQL: type of joins and how they work. aggregate functions modifiers like: limit, offset, like