Web Service to query database and send data in an email

I need a webservice to query a SQL database (database is to manage license expiration) to retrieve licenses that are 30 days away from expiring. It will take that entire row with (data included such as first name last name license number and expiration date) and send that in an email to a single email (distribution group).