hhquest

span class="re5"> create table products(produсtname string, categoryname string);

insert into products values("milc", "drink");
insert into products values("milc", "cow product");
insert into products values("milc", NULL);
insert into products values("beer", "drink");
insert into products values("beer", NULL);
insert into products values("beer", "alcohol");
insert into products values("liquor with milk", "alcohol");
insert into products values("liquor with milk", "cow product");
insert into products values("liquor with milk", NULL);


select produсtname,categoryname from products where produсtname = "beer" AND (categoryname = "alcohol" OR categoryname IS NULL);