return count of select in MYSQL code example

Example: select count from table mysql

SELECT COUNT(*) FROM count_demos;