Need a Count, but Multiple other fields
- by user3727752
I have a table that looks like this:
person trip_id date home destination
joe 1 3/10 chicago new york
joe 2 4/10 chicago l.a.
joe 3 5/10 chicago boston
luther 4 3/12 new york chicago
luther 5 3/18 new york boston
I want to get a result like
…