SQLAlchemy ORM group_by и join

У меня есть запрос

query = session.query(portfolioAnalysis_portfoliomain,portfolioAnalysis_stocklist, 
                                    stock_companymaster,
                                    stock_industrymaster,func.count(stock_industrymaster.c.INDUSTRY).label('count_ind'))\
                                .filter(portfolioAnalysis_portfoliomain.c.user_id==user_dt.id)\
                                    .join(portfolioAnalysis_stocklist, portfolioAnalysis_stocklist.c.portfolio_id==portfolioAnalysis_portfoliomain.c.id)\
                                        .join(stock_companymaster, stock_companymaster.c.FINCODE==portfolioAnalysis_stocklist.c.stock_id)\
                                            .join(stock_industrymaster, stock_industrymaster.c.IND_CODE==stock_companymaster.c.IND_CODE)\
                                                .group_by(portfolioAnalysis_stocklist.c.id)\
                                                    .all()

Я хочу получить данные как

('Refinary', 2)
('Banking', 3)

но я получаю данные как

('Refinary', 1)
('Refinary', 1)
('Banking', 1)
('Banking', 1)
('Banking', 1)

Я попробовал выполнить следующий запрос, но он выдает ошибку.

query = session.query(portfolioAnalysis_portfoliomain,portfolioAnalysis_stocklist, 
                                    stock_companymaster,
                                    stock_industrymaster,func.count(portfolioAnalysis_stocklist.c.id).label('count_ind'))\
                                .filter(portfolioAnalysis_portfoliomain.c.user_id==user_dt.id)\
                                    .join(portfolioAnalysis_stocklist, portfolioAnalysis_stocklist.c.portfolio_id==portfolioAnalysis_portfoliomain.c.id)\
                                        .join(stock_companymaster, stock_companymaster.c.FINCODE==portfolioAnalysis_stocklist.c.stock_id)\
                                            .join(stock_industrymaster, stock_industrymaster.c.IND_CODE==stock_companymaster.c.IND_CODE)\
                                                .group_by(stock_industrymaster.c.INDUSTRY)\
                                                    .all()

Вернуться на верх