PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE mq_active_sep21 ( Sid int primary key auto_increment, Entity_Name varchar(255), Plan_Name varchar(255) ); INSERT INTO mq_active_sep21 (Entity_Name, Plan_Name) VALUES ('Entity_Name1', 'Complementary_Package'), ('Entity_Name2', 'Complementary_Package'), ('Entity_Name3', 'Complementary_Package'), ('Entity_Name3', 'Complementary_Package'), ('Entity_Name3', 'Not_Complementary_Package'), ('Entity_Name1', 'Not_Complementary_Package'); SELECT Entity_Name, Count(*) Count_All, Count(NULLIF(Plan_Name, 'Complementary_Package')) Not_Complementary_Package FROM mq_active_sep21 GROUP BY Entity_Name ORDER BY Entity_Name;
Copy Clear
Copy Format Clear
<?php $connection = &$mysqli; $sql = mysqli_query($connection, " SELECT Entity_Name, Count(*) Count_All, Count(NULLIF(Plan_Name, 'Complementary_Package')) Not_Complementary_Package FROM mq_active_sep21 GROUP BY Entity_Name ORDER BY Entity_Name; "); while($row = mysqli_fetch_assoc($sql)) { printf( "Entity_Name: %s, Total: %d, Complementary_Package: %d " . PHP_EOL, $row['Entity_Name'], $row['Count_All'], $row['Count_All'] - $row['Not_Complementary_Package'] ); }
Show:  
Copy Clear