>_ IzzyLab

Topic breakdown

SQL aggregate functions — COUNT, SUM, AVG, MIN, MAX — collapse many rows into one value. Without GROUP BY the aggregate is computed over the whole table and SELECT returns exactly one row with one number. Given a query as an argument, sqlite3 prints the result without borders or headers, so it can be redirected straight to a file and used in scripts.

What's checked

  1. /root/pages.txt holds the page total

What it looks like