I want to return a query that returns film titles that contain
letter 'a' followed by repeating characters from the table
below.
For example, Married Go (a film in the table) has repeating
characters following the letter a.
Table:
CREATE TABLE film_cat_rate (
category character varying(25),
title character varying(255),
rental_rate numeric(4,2)
);
INSERT INTO film_cat_rate (category, title, rental_rate) VALUES
('New', 'Amistad Midsummer', 2.99);
INSERT INTO film_cat_rate (category, title, rental_rate) VALUES
('Drama', 'Apollo Teen', 2.99);
INSERT INTO film_cat_rate (category, title, rental_rate)...