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;
Telegram: DB developers channel