removed group by from schema