added support for outer joins
added test for group-by