Untitled query #83869

SQL

SELECT
  p.page_title AS Title,
  MAX(CASE 
      WHEN wp.wp_rating = 'FA' THEN 'FA'
      WHEN wp.wp_rating = 'GA' THEN 'GA'
      WHEN wp.wp_rating = 'B' THEN 'B'
      WHEN wp.wp_rating = 'C' THEN 'C'
      WHEN wp.wp_rating = 'Start' THEN 'Start'
      WHEN wp.wp_rating = 'Stub' THEN 'Stub'
      WHEN wp.wp_rating = 'List' THEN 'List'
      ELSE 'NA' END) AS Quality,
  MAX(CASE 
      WHEN wp.wp_importance = 'Top' THEN 'Top'
      WHEN wp.wp_importance = 'High' THEN 'High'
      WHEN wp.wp_importance = 'Mid' THEN 'Mid'
      WHEN wp.wp_importance = 'Low' THEN 'Low'
      ELSE 'NA' END) AS Importance
FROM
  page p
JOIN
  page_assessments wp ON p.page_id = wp.page_id
WHERE
  wp.wp_project = 'Climate Change'
GROUP BY
  p.page_title
ORDER BY
  Quality, Importance;
SQL

Checking query status...
