SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE Age_Table (`ID` int, `First_Name` varchar(9), `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 First_Name,Age FROM Age_Table WHERE Age>30 ORDER BY First_Name ASC