SELECT Class, COUNT(Class) FROM captain GROUP BY Class ORDER BY COUNT(Class) DESC
What is the total number of captains with different classes?, and list Y in descending order please.
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 real,
    Class text,
    Flag text
)