Postgresql – SQL fetch values of goods and categories from one column and past them in two diferent
This is the table goodsandcat Item Key Electronics 0 Smartphones 1 Laptops 1 Cameras 1 Headphones 1 Clothing 0 T-shirts 1 Jeans 1 Dresses 1 Jackets 1 Column Item has names of categories and goods with their respective 0 and…