I am working on a little reporting app for work, and I am stuck on a query.

I have two tables, customers and events. The structure of those follows:

Customers
---------
CustomerId (key)
CreatedDTM
customername
accounttype (shows me whether or not they are a business)

Events
------
eventid (key)
customerid (to tie to the customers database)
created (date the event, like a call or email, was created)

I need to write a query that will show me all of the customers who have been created MORE than 30 days ago, are of the accounttype "1", and who have no events from the events table logged within the past 30 days as well

This is the most complicated query I have tried to write as of yet, and I am a little confused w/ the multiple statements that need to be made.

Thanks in advance for any help