added groupby statement to the venucal