CREATE TABLE competition_result (Competition_ID INT, Club_ID_1 INT, Club_ID_2 INT, Score TEXT)
CREATE TABLE competition (Competition_ID INT, Year FLOAT, Competition_type TEXT, Country TEXT)
CREATE TABLE club_rank (Rank FLOAT, Club_ID INT, Gold FLOAT, Silver FLOAT, Bronze FLOAT, Total FLOAT)
CREATE TABLE player (Player_ID INT, name TEXT, Position TEXT, Club_ID INT, Apps FLOAT, Tries FLOAT, Goals TEXT, Points FLOAT)
CREATE TABLE club (Club_ID INT, name TEXT, Region TEXT, Start_year TEXT)

List the positions of players whose average number of points scored by that position is larger than 20, compare the number of positions, and could you rank in descending by the X?
SELECT Position, COUNT(Position) FROM player GROUP BY Position HAVING AVG(Points) >= 20 ORDER BY Position DESC
SELECT "Position", COUNT("Position") FROM "player" GROUP BY "Position" HAVING AVG("Points") >= 20 ORDER BY "Position" DESC NULLS LAST