52. Create a view that shows all the customers who have the highest ratings.
CREATE VIEW highest_rating AS
SELECT
*
FROM
customer
WHERE
rating = (
SELECT
MAX(rating)
FROM
customer
);
Output:

CREATE VIEW highest_rating AS
SELECT
*
FROM
customer
WHERE
rating = (
SELECT
MAX(rating)
FROM
customer
);
