Hi,
Since i don't know what is "played for Sussex in two separate spells" --
what's a spell ? (sorry) -- i assume it's a different period of time,
but don't know how to calculate it.
Ignoring the "spell", i did this:
SELECT A.Playerid, A.Teamid, sum(if (A.Substitute=1,0,1))
not_a_substitute, sum(
I'm attempting to write one SQL statement to retrieve data in a
particular way, and don't seem to be able to do it despite dozens of
attempts (indeed maybe it cannot be done), but wondered if anyone could
suggest anything, such as a function I may have missed that can do it,
or that it simply isn't
