รบกวนสอบถามการใช้หาผลรวมข้อมูลเพื่อสรุปทำรายงานครับ (ไม่ได้ใช้นานจริงๆครับ)

...GROUP BY water_id

<?php

// Connection
$host_name = 'server';
$user_name = 'user';
$pass_word = 'password';
$database_name = 'database';
$short_connect = new mysqli($host_name, $user_name, $pass_word, $database_name);

$short_connect -> set_charset("utf8");

//SQL statement for a table in the database
$sql = "SELECT water_id, prov_name, amp_name,
  COUNT(tam_name) AS nTambon,
  COUNT(moo_name) AS nMooban,
  COUNT(water_id) AS nWater,
  SUM(CASE WHEN detail = 'สาธารณะ' THEN 1 ELSE 0 END) AS nSatha,
  SUM(CASE WHEN detail = 'สปก.' THEN 1 ELSE 0 END) AS nSPK,
  SUM(CASE WHEN detail = 'ป่าไม้' THEN 1 ELSE 0 END) AS nPamai,
  SUM(CASE WHEN detail = 'ป่าชุมชน' THEN 1 ELSE 0 END) AS nCh,
  SUM(CASE WHEN detail = 'อื่นๆ' THEN 1 ELSE 0 END) AS nX
FROM water
GROUP BY water_id";	// Pay attention to this one.

//result is boolean for query other than SELECT, SHOW, DESCRIBE and EXPLAIN
$result = $short_connect->query($sql);

// Create a template from database
if (($result) && ($result->num_rows > 0))
{
	echo '<table><tr>
			<th>รหัสแหล่งน้ำ</th>
			<th>จังหวัด</th>
			<th>อำเภอ</th>
			<th>จำนวนตำบล</th>
			<th>จำนวนหมู่บ้าน</th>
			<th>จำนวนแหล่งน้ำ</th>
			<th>จำนวนที่สาธารณะ</th>
			<th>จำนวนที่ สปก.</th>
			<th>จำนวนเขตป่าไม้</th>
			<th>จำนวนเขตป่าชุมชน</th>
			<th>จำนวนอื่นๆ</th></tr>
			';

	//convert query result into an associative array
	while ($row = $result->fetch_assoc())
	{
		echo '<tr>
			<td>' . array_values($row)[0] . '</td>
			<td>' . array_values($row)[1] . '</td>
			<td>' . array_values($row)[2] . '</td>
			<td>' . array_values($row)[3] . '</td>
			<td>' . array_values($row)[4] . '</td>
			<td>' . array_values($row)[5] . '</td>
			<td>' . array_values($row)[6] . '</td>
			<td>' . array_values($row)[7] . '</td>
			<td>' . array_values($row)[8] . '</td>
			<td>' . array_values($row)[9] . '</td>
			<td>' . array_values($row)[10] . '</td>
		</tr>';
	}

	echo '</table>';
	$result->free();

}

$short_connect->close();

/* https://www.thaicreate.com/php/forum/135287.html */
?>

-- ...
SUM(CASE WHEN detail NOT IN('สาธารณะ', 'สปก.', 'ป่าไม้', 'ป่าชุมชน') THEN 1 ELSE 0 END) AS nX
-- ...