On 28-12-2019 13:07, Csanyi Pal wrote:
Hi,
I have attached here the exported sql file of my little sqlite database.
I am a newbe in the sqlite language so I ask here only an advice in
which direction to go, eg. which functions of sqlite language to use
to achieve my goal?
SQList is able to calulate averages. lets give simple example
select min(a),avg(a),max(a)
from (select 1 as a union all select 2 union all select 3 union all
select 4);
It will output:
1|2.5|4
because 1 is the minimum values of the selected values 1,2,3,4
2.5 is the average of the selected values 1,2,3,4
and 4 is the max values of those.
For calculating with date (and/or time) function you should read this page:
https://www.sqlite.org/lang_datefunc.html
If you created an example that 'does not work' (i do mean 'that does not
do what you expect it to do' 😉), come back here with that example, and
i'm sure someone will help you
post the database structure, the query and some example data, and if
possible the expected output...
Do I think well?
Any advices will be appreciated!
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
