Install asql by entering the following commands in the terminal:
sudo apt update sudo apt install asql
Run SQL queries against apache logs
This package contains a simple tool which allows you to easily run SQL queries against Apache common logfiles. . This can be more illuminating than viewing static logfile analysis.