CREATE TABLE captain (Captain_ID INT, Name TEXT, Ship_ID INT, age TEXT, Class TEXT, Rank TEXT)
CREATE TABLE Ship (Ship_ID INT, Name TEXT, Type TEXT, Built_Year FLOAT, Class TEXT, Flag TEXT)

How many captains with younger than 50 are in each rank, and sort in desc by the bar.
SELECT Rank, COUNT(*) FROM captain WHERE age < 50 GROUP BY Rank ORDER BY Rank DESC
SELECT "Rank", COUNT(*) FROM "captain" WHERE "age" < 50 GROUP BY "Rank" ORDER BY "Rank" DESC NULLS LAST