@Keith Thanks. I am new to SQL and DB in general; please clarify what *is it valid* means. How do I check validity of schema?
On Mon, Feb 18, 2019, 1:17 AM Keith Medcalf <kmedc...@dessus.com wrote: > > Nice schema. Do you have a valid one? > > > --- > The fact that there's a Highway to Hell but only a Stairway to Heaven says > a lot about anticipated traffic volume. > > > >-----Original Message----- > >From: sqlite-users [mailto:sqlite-users- > >boun...@mailinglists.sqlite.org] On Behalf Of Rocky Ji > >Sent: Sunday, 17 February, 2019 09:47 > >To: SQLite mailing list > >Subject: [sqlite] How to get aggregate without reducing number of > >rows (repeats are ok)? > > > >Hello everyone, > > > >How can I prevent group by clause from reducing the number of rows > >without > >affecting accuracy of what aggregate functions provide? > > > >Scenario: > >My club has-many coaches. > >Each coach trains a team of players. > >Of course, a player has-many matches and a match has-many players. > >Given the schema: https://pastebin.com/raw/C77mXsHJ > >and sample data: https://pastebin.com/raw/GhsYktRS > > > >I want a result like: https://pastebin.com/raw/stikDvYS > > > >NOTE: for a match X, profit/match is `sum(salary of all players > >playing in > >X) - X.bets` > > > >To get the result, here's what I came up with: > >https://pastebin.com/ckgicBWS > > > >If I un-comment those lines, I get the profit column but rows are > >reduced, > >how can I prevent that? > > > >Thanks, > >Rocky. > >_______________________________________________ > >sqlite-users mailing list > >sqlite-users@mailinglists.sqlite.org > >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
