我想要生成一个包含Windows机器和Linux机器数量的报告。这是我目前的密码。FROM Machines ( (OperatingSystem LIKE '%Linux%') GROUP BY OperatingSystemRed Hat Enterprise Linux 20
Novell SUSE Linu
这会创建一个段,说明订单是否具有2+单位: CASEWHEN SUM(quantity) > 1 then '2+ Units' ELSE '1 Unit' END as qty_flag_total我有一个产品‘自行车’的数量总和: SUM(CASEWHEN category = 'bike' THEN quantity END) AS qty_bike 但是想知道是否有一种干净的方法在这个上面创建相同的标志
D Linux DellLaptopSELECT Department, casewhen Operating_System = 'Windows' THEN COUNT(Department) ELSE '' END AS 'Windows',
casewhen Operating_System = 'IOS' THEN