Ontological Web Organizer (O.W.O.) - Go Back

SQLITE3> -- Prende tutta la lista dei personaggi, poi scegli il personaggio con la statistica specificata piu alta e piu bassa
WITH cte AS (
            SELECT CompleteModifiers.NomeStatistica AS "Stat", ReadyCharacters.NomePersonaggio AS "Nome Personaggio", CompleteModifiers.Modifier AS "Modifier",
		   ROW_NUMBER() OVER (ORDER BY CompleteModifiers.Modifier) as "rn",
           count(*) over () as total_count
        FROM CompleteModifiers
        INNER JOIN ReadyCharacters ON ReadyCharacters.ID = CompleteModifiers.PersonaggioID
		WHERE CompleteModifiers.StatisticaID = :stat AND (CompleteModifiers.Sistema="Pathfinder 1e" OR 0!=(1-:IncludiSoloPathfinder ))
        )

SELECT "Stat", "Nome Personaggio", "Modifier" FROM  cte
where rn = 1
   or rn = total_count