Comment count shortcode snippet

// Add Shortcode
function scaefyCommentCount() {

	global $wpdb;
	$table_comments = $wpdb->prefix . 'comments';
	
	$query = "SELECT COUNT(comment_ID) AS total_comments
	          FROM $table_comments
	          WHERE comment_type = 'comment' AND comment_approved = 1";
	
	$total_comments = $wpdb->get_var( $query );
	
	echo $total_comments;

}
add_shortcode( 'yorumsayisi', 'scaefyCommentCount' );