These are some general projects that I have been able to work on during my time at 121 marketing as Support Director including regex, SQL, JS, and PHP. Not everything is listed as some changes are confidential and others were bug fixes in larger projects.
SELECT COUNT(*) AS QTY
FROM 'Tickets', 'Tag Links'
WHERE 'Tickets.Creation Date' = LastMonth() and ('Tag Links.Tag' NOT IN('proplan', 'ezlinks', 'courseco', 'score profitably'))
GROUP BY Y('Tag Links.Tag')
ORDER BY 'QTY'
SELECT COUNT(*)
FROM Tickets, 'Tag Links'
WHERE Year('Tickets.Creation Date') IN '2017'
GROUP BY Y('Tag Links.Tag'), X('Tickets.Creation Date':Month)