This is a script to query a table, generate the result in HTML and send an email using mailx for…