CREATE TABLE Age_Table
(`ID` int, `First_Name` varchar(10), `Age` int)
;
INSERT INTO Age_Table
(`ID`, `First_Name`, `Age`)
VALUES
(2, '"Gary"', 25),
(3, '"Bob"', 35),
(4, '"Bill"', 22),
(5, '"Jill"', 26),
(6, '"Todd"', 28),
(7, '"Tim"', 31),
(8, '"Mary"', 32),
(9, '"Cindy"', 32),
(10, '"Cathy"', 36),
(11, '"Greg"', 29),
(12, '"Tina"', 25),
(13, '"Harry"', 30),
(14, '"Bert"', 24),
(15, '"Kim"', 26),
(16, '"Rollo"', 42),
(17, '"Svet"', 22),
(18, '"Melissa"', 29),
(19, '"Cindy"', 21),
(20, '"Roger"', 32)
;
select * FROM Age_Table WHERE Age > 30 ORDER BY Age ASC
Telegram: DB developers channel