In this version SQliter can perform aggregate queries. Specifically, COUNT, AVG, and MAX.
COUNT is performed by suming the number of rows in a table excluding the header.
AVG is performed by summing the values of a column and dividing the total number of rows excluding the header.
MAX is performed by traversing the specified column and returns the largest value in that column.
Python version >= 3.10
Run SQLiter using standard input.
python main.py < PA5_test.sql
Run SQLiter using editor.
python main.py