Select EmailAddress, CreatedDate
Where ListID = 10630 AND CreatedDate > (Select DATEADD (day,-90,getdate()))
DATEADD doesn't exists in Teradata SQL, depending on some settings it might work in SQL Assistant using an ODBC connection.
But it's much easier in TD SQL:
CreatedDate > current_date - 90