Re: [sqlite] AVG Function HowTo

2019-12-28 Thread Keith Medcalf
m: sqlite-users On >Behalf Of Keith Medcalf >Sent: Saturday, 28 December, 2019 23:53 >To: SQLite mailing list >Subject: Re: [sqlite] AVG Function HowTo > > >The description makes no sense. > >So lets say on the 1st of a Month you have an "Earnings" of $4,000.

Re: [sqlite] AVG Function HowTo

2019-12-28 Thread Keith Medcalf
s On >Behalf Of Csanyi Pal >Sent: Saturday, 28 December, 2019 05:07 >To: sqlite-users@mailinglists.sqlite.org >Subject: [sqlite] AVG Function HowTo > >Hi, > >I have attached here the exported sql file of my little sqlite database. > >I am a newbe in the sqlite language so I

Re: [sqlite] AVG Function HowTo

2019-12-28 Thread Barry Smith
SQL is a declarative language, not a procedural one. Therefore I find it helps to think in declarative terms rather than procedural. What that means practically in this case is don’t think in terms of loops. Think about what you want, and think about how your data is related. I don’t entirely

Re: [sqlite] AVG Function HowTo

2019-12-28 Thread Luuk
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

Re: [sqlite] AVG Function HowTo

2019-12-28 Thread Csanyi Pal
2019. 12. 28. 13:07 keltezéssel, Csanyi Pal írta: 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? My

[sqlite] AVG Function HowTo

2019-12-28 Thread Csanyi Pal
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? My issue is the following. So far my database has two