Find count of customers whose postal code is same in sql language?

Answer 1

-> First Connect to Database
-> Select from Table Columns which users have postal code
-> Use mysqli_num_rows() to get the results and output it.

Answer 2

yes this is a table structure

Answer 3

Try this query, not sure it will work, I haven't tested it : )

SELECT COUNT(<post_code>) FROM <table_name> GROUP BY <post_code> ORDER BY <post_code>;

Where:
<table_name> is table name.
<post_code> post code column/field.