CREATE TABLE emp(id integer primary key, first_name text, last_name text, salary money, commision money);
INSERT INTO emp VALUES(1,'harish', 'maxwell', 43324, 231);
INSERT INTO emp VALUES(2,'faruk', 'morgan', 63423, 0);
INSERT INTO emp VALUES(3,'harsh', 'kohli', 87765, 443);
INSERT INTO emp VALUES(4,'alfaiz', 'dhoni', 23424, 323);
INSERT INTO emp VALUES(5,'zaid', 'sharma', 63235, 512);
SELECT last_name,salary,commision FROM emp where commision != 0 order by salary desc, commision desc;