You can use generated column for status as below:
Create table statements:

create table brands (brand_id int, brand_name varchar(100),no_of_products int, 
 status boolean GENERATED ALWAYS AS (case when no_of_products=0 then false else true end));

**if no_of_products is 0 then status column will be 0 otherwise it will be 1

Insert statements:

insert into brands(brand_id,brand_name,no_of_products) values(1,'hp',0);
 insert into brands(brand_id,brand_name,no_of_products) values(2,'del',5);

Select query:

select * from brands

Output:
| brand_id | brand_name | no_of_products | status |
| ------------ | ------------ | ------------ | ------------ |
| 1 | hp | 0 | 0 |
| 2 | del | 5 | 1 |

• db<>fiddle here*