Export single table and email via cron job

How can I setup a cron job to execute a SQL query, export the results to a CSV formatted file and email to an address?