I've got the following query that produces a large table for me.
SELECT
router.name AS Router,
SUM(IF(speed='64000',1,0)) AS 64K,
SUM(IF(speed='128000',1,0)) AS 128K,
SUM(IF(speed='192000',1,0)) AS 192K,
SUM(IF(speed='256000',1,0)) AS 256K,
SUM(IF(speed='384000',1,0)) AS
The query as written works just fine although I'm certain there's got to be
a more efficient way of doing the same thing. I'm relatively new to MySQL
so I took the brute force approach.
My problem is that I want to produce totals of each of the columns and can't
figure out how to do it. Any