What are the movie titles with the highest average rating and what are those ratings?
CREATE TABLE rating (
    rid number,
    mid number,
    stars number,
    ratingdate time
)

CREATE TABLE reviewer (
    rid number,
    name text
)

CREATE TABLE movie (
    mid number,
    title text,
    year number,
    director text
)
SELECT T2.title, AVG(T1.stars) FROM rating AS T1 JOIN movie AS T2 ON T1.mid = T2.mid GROUP BY T1.mid ORDER BY AVG(T1.stars) DESC LIMIT 1
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: What are the movie titles with the highest average rating and what are those ratings? ### Input: CREATE TABLE rating (
    rid number,
    mid number,
    stars number,
    ratingdate time
)

CREATE TABLE reviewer (
    rid number,
    name text
)

CREATE TABLE movie (
    mid number,
    title text,
    year number,
    director text
) ### Response: SELECT T2.title, AVG(T1.stars) FROM rating AS T1 JOIN movie AS T2 ON T1.mid = T2.mid GROUP BY T1.mid ORDER BY AVG(T1.stars) DESC LIMIT 1