MAX(CASE WHEN type = 'D' THEN backup_finish_date END) AS last_full_backup, MAX(CASE WHEN type = 'I' THEN backup_finish_date END) AS last_diff_backup, MAX(CASE WHEN type = 'L' THEN backup_finish_date ...