Q&A about the site for administrators, end users, developers and designers for Craft CMS
--Display the PostTypeId, Title in lowercase and Body in uppercase for all posts whose PostTypeId equals 1. Remember to use TOP 20. SELECT TOP 20 PostTypeId, LOWER(Title) AS 'low_title', UPPER(Body) as 'upper_body' FROM posts WHERE postTYPEid = 1