Sort Rows By A Column's Values

Create Table Of Superheroes

-- Create a table called SUPERHEROES.
CREATE OR REPLACE TABLE SUPERHEROES (
  -- Column called ALTER_EGO allowing up to 100 characters
  "ALTER_EGO" VARCHAR(100),
  -- Column called BANK_BALANCE allowing 38 digits with 2 after the decimal point
  "AGE" INT,
  -- Column called STATE allowing up to 100 characters
  "STATE" VARCHAR(100)
);

Insert Rows For Each Superhero

-- Insert rows into SUPERHEROES
INSERT INTO SUPERHEROES 
    -- With the values
    VALUES
    ('The Bomber', '24', 'Maine'),
    ('Mr. Money', '12', 'Maine'),
    ('Nuke Miner', '59', 'Maine'),
    ('The Knife', '43', 'Maine'),
    ('Ninka Baker', '32', 'California'),
    ('Banana Bomber', '34', 'California'),
    ('Augustine', '12', 'California'),
    ('The Kid', '21', 'New York'),
    ('The Viking', '291', 'New York'),
    ('Skull Hustle', '10', 'New York');

Sort Rows By Age (Ascending)

-- Select all columns from SUPERHEROES
SELECT * FROM SUPERHEROES
-- Sort by AGE (ascending)
ORDER BY AGE;
ALTER_EGO AGE STATE
Mr. Money 12 Maine
Augustine 12 California
The Kid 21 New York
The Bomber 24 Maine
Ninka Baker 32 California
Banana Bomber 34 California
The Knife 43 Maine
Nuke Miner 59 Maine
The Viking New York
Skull Hustle New York

Sort Rows By Age (Descending)

-- Select all columns from SUPERHEROES
SELECT * FROM SUPERHEROES
-- Sort by AGE (descending)
ORDER BY AGE DESC;
ALTER_EGO AGE STATE
The Viking New York
Skull Hustle New York
Nuke Miner 59 Maine
The Knife 43 Maine
Banana Bomber 34 California
Ninka Baker 32 California
The Bomber 24 Maine
The Kid 21 New York
Mr. Money 12 Maine
Augustine 12 California

Sort Rows By Age With NULL Values First

-- Select all columns from SUPERHEROES
SELECT * FROM SUPERHEROES
-- Sort by AGE with NULL values put first
ORDER BY AGE NULLS FIRST;
ALTER_EGO AGE STATE
The Viking New York
Skull Hustle New York
Mr. Money 12 Maine
Augustine 12 California
The Kid 21 New York
The Bomber 24 Maine
Ninka Baker 32 California
Banana Bomber 34 California
The Knife 43 Maine
Nuke Miner 59 Maine