ฟังก์ชัน TRIM

-- Concatenate the uppercase category name and film title
SELECT 
  ___(___(___), ': ', ___) AS film_category, 
  -- Truncate the description remove trailing whitespace
  ___(___(___, ___)) AS film_desc
FROM 
  film AS f 
  INNER JOIN film_category AS fc 
  	ON f.film_id = fc.film_id 
  INNER JOIN category AS c 
  	ON fc.category_id = c.category_id;