http://stackoverflow.com/questions/15136868/why-is-group-by-giving-only-one-column-as-output

I couldn't figure out the answer..