'count the devices that has the same firmware

Just want to count the number of devices and display it here: Image Example

I have tried using "SELECT DISTINCT Firmware, COUNT(SerialNumber) FROM SoftwareCycle GROUP BY Model"

however, the firmware gets duplicated. Image Example

here is the table structure: Image Example

mysqlphpmyadmin


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions