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

How many captains with younger than 50 are in each rank, display by the the total number from high to low.
SELECT Rank, COUNT(*) FROM captain WHERE age < 50 GROUP BY Rank ORDER BY COUNT(*) DESC
SELECT "Rank", COUNT(*) FROM "captain" WHERE "age" < 50 GROUP BY "Rank" ORDER BY COUNT(*) DESC