#!/bin/sh

psql email <<EOF
SELECT is_spam, COUNT(score), ROUND(AVG(score), 2) AS average,
       ROUND(STDDEV(score), 2) AS std_dev, MIN(score), MAX(score)
  FROM spam
  GROUP BY is_spam;
\x
\t
SELECT status FROM spam WHERE score = (SELECT MAX(score) FROM spam);
EOF