[sqlite] Mathematical calculations with SQLite3????

Does anybody know how to perform mathematical calculations with the data entered into your SQLite3 tables? I'd like to get simple calculations like sums, averages, percentages, etc.. Is there a way to do this and print material afterward? If you know how, please explain how to pursue this ta

[sqlite] Problem opening a new SQLite3 database file

I cannot open a new SQLite3 database file through the command prompt. In the windows "run" window, I type "SQLite3 mydatabase.db3" and I get the following error message: ** "Cannot find the file 'SQLite3' (or one of its components). Make s