counting value in mysql table

Question

How will you count the specified value in a column stored in the MySQL table and the result to be displayed in another table.