Replace temporary table with CTE in stats calculation #912

	name: Linters

	on: [ push, pull_request ]

	jobs:
	lint:
	runs-on: ubuntu-latest
	steps:
	- name: Set up environment
	uses: actions/checkout@v4
	with: # no need for the history
	fetch-depth: 1

	- name: Set up Python
	uses: actions/setup-python@v5
	with:
	python-version: '3.9'

	- name: Install dependencies
	run: \|
	python -m pip install --upgrade pip
	python -m pip install --upgrade tox

	- name: Run linters
	run: tox -e lint

	lint-with-black:
	runs-on: ubuntu-latest
	steps:
	- uses: actions/checkout@v4
	- uses: psf/black@stable
	with:
	options: "--check --diff --verbose"
	version: "~= 22.12.0"

Provide feedback