Consider the following database schema:

CREATE TABLE \`users\` (
  \`id\` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  \`first_name\` varchar(180) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  \`last_name\` varchar(180) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  \`address_line_1\` varchar(180) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  \`address_line_2\` varchar(180) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  \`city\` varchar(180) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  \`state\` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  \`zip\` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  \`email\` varchar(180) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  \`phone\` varchar(180) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  \`auth\` varchar(180) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (\`id\`),
  UNIQUE KEY \`email\` (\`email\`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE \`forum_posts\` (
  \`id\` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  \`forum_id\` bigint(20) unsigned NOT NULL,
  \`user_id\` bigint(20) unsigned NOT NULL,
  \`title\` varchar(180) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  \`content\` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (\`id\`),
  FOREIGN KEY (\`forum_id\`) REFERENCES forums(\`id\`)
  FOREIGN KEY (\`user_id\`) REFERENCES users(\`id\`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

Write out the appropriate SQL Select Query that will return all user emails along with the number of forum posts they have made.