Q&A for Ubuntu users and developers
SELECT Top 20 u.DisplayName, u.Reputation, u.LastAccessDate, p.LastPost FROM Users u INNER JOIN ( SELECT OwnerUserId, Max(CreationDate) As LastPost FROM Posts WHERE CreationDate < '2012-01-01' GROUP BY OwnerUserId) As p ON u.ID = p.OwnerUserId WHERE Reputation>30000