0

I don't know how to select the column value with its count in flask-sqlalchemy.

I've used SELECT browser, COUNT(browser) FROM visitor_stats GROUP BY browser; to get the browser name column with its count using group by in SQL, but I cannot transform it into flask-sqlalchemy function.

Haki
  • 1
  • 2
  • I would start by giving the `COUNT(browser)` an alias like `SELECT browser, COUNT(browser) as browser_count FROM visitor_stats GROUP BY browser;` – RiggsFolly Dec 10 '22 at 13:45
  • The proposed duplicate is for SQLAlchemy; for Flask-SQLAlchemy you cangenerally substitute `db` for `sqlalchemy` in imports etc. – snakecharmerb Dec 10 '22 at 13:56

0 Answers0