SQLize Online / PHPize Online  /  SQLtest Online

create table Cats ( CatID int not null primary key, CatName varchar(255) null, CatWeight decimal(18, 2) null, Chonkertype int null, BodyFettAnteil decimal(5, 2) null ); insert into Cats (CatID, CatName, CatWeight, Chonkertype, BodyFettAnteil) values (1, 'Mietzi', 9.20, 3, 40.00), (2, 'Flauschi', 11.20, 5, 60.00), (3, 'Kratzbürsti', 4.20, 1, 20.00), (4, 'Motzi', 5.20, 1, 20.00), (5, 'Fat Tony', 14.20, 6, 70.00), (6, 'Big Floppa', 11.20, 1, 20.00), (7, 'Bigger Floppa', 13.20, 2, 30.00), (8, 'Rollin Molly', 6.20, 3, 40.00); select * from Cats where CatWeight = >10 or BodyFettAnteil = >40;