Replace and Concatenate
SELECT REPLACE(review, "public relations", "PR") || " - " || username AS "Review" from reviews;