SELECT DISTINCT name, weightInGms, CASE WHEN weightInGms < 1000 THEN 'Low' WHEN weightInGms < 5000 THEN 'Medium' ELSE 'Bulk' END AS weight_category FROM zepto; --Q8.What is the Total Inventory Weight ...
SELECT 1 AS n UNION ALL SELECT n + 1 FROM Gen_Numbers WHERE n < 1000 ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results