如何显示所有表格及其名称+它们有多少行？ 不包括空行或丢弃行

So I tried to list all tables with their name and row count but I notice I got more then what I have so I'm pretty sure the reason I got more is because I drop some rows and I also would like to keep order from the table with the most rows to the table with the least rows

<?
$sql = "SELECT TABLE_NAME, table_rows FROM information_schema.TABLES WHERE table_schema = '<database name>' ORDER BY (table_rows) DESC;";
$result = mysqli_query($link, $sql);
if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
      echo $row["TABLE_NAME"].$row["table_rows"];
    }
}
?>