On 22 Dec 2019, at 8:43pm, Csanyi Pal <csanyi...@gmail.com> wrote: > I can easily create a View to see my expenses between two dates, but how > could I create such a View in which I can see the average of my expenses by > using my Views that I earlier created?
A view acts like a tablee. If you can figure out a SELECT for a table, just use the name of the view instead of the name of the table. So first create the view you mentioned above. Then use a SELECT to perform calculations on it. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
