-- your code goes here
create table product
(
product_id INT,
product_name VARCHAR(100),
is_recyclable BOOLEAN,
is_low_fat BOOLEAN
);
insert into product(product_id,product_name,is_recyclable,is_low_fat)
values(1 ,"Product A", TRUE, TRUE),
(2 ,"Product B", TRUE, FALSE),
(3 ,"Product C", FALSE, TRUE),
(4 ,"Product D", TRUE, TRUE);
select product_id , product_name
from product
where (is_recyclable = TRUE) and (is_low_fat = TRUE);
LS0geW91ciBjb2RlIGdvZXMgaGVyZQpjcmVhdGUgdGFibGUgcHJvZHVjdAooCnByb2R1Y3RfaWQgSU5ULApwcm9kdWN0X25hbWUgVkFSQ0hBUigxMDApLAppc19yZWN5Y2xhYmxlIEJPT0xFQU4sCmlzX2xvd19mYXQgQk9PTEVBTgopOwoKaW5zZXJ0IGludG8gcHJvZHVjdChwcm9kdWN0X2lkLHByb2R1Y3RfbmFtZSxpc19yZWN5Y2xhYmxlLGlzX2xvd19mYXQpCnZhbHVlcygxICwiUHJvZHVjdCBBIiwgVFJVRSwgVFJVRSksCgkgICgyICwiUHJvZHVjdCBCIiwgVFJVRSwgRkFMU0UpLAoJICAoMyAsIlByb2R1Y3QgQyIsIEZBTFNFLCBUUlVFKSwKCSAgKDQgLCJQcm9kdWN0IEQiLCBUUlVFLCBUUlVFKTsKCnNlbGVjdCBwcm9kdWN0X2lkICwgcHJvZHVjdF9uYW1lIApmcm9tIHByb2R1Y3QKd2hlcmUgKGlzX3JlY3ljbGFibGUgPSBUUlVFKSBhbmQgKGlzX2xvd19mYXQgPSBUUlVFKTs=