What are the titles and average ratings for all movies that have the lowest average rating?
CREATE TABLE movie (
    mid number,
    title text,
    year number,
    director text
)

CREATE TABLE reviewer (
    rid number,
    name text
)

CREATE TABLE rating (
    rid number,
    mid number,
    stars number,
    ratingdate time
)
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) 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 titles and average ratings for all movies that have the lowest average rating? ### Input: CREATE TABLE movie (
    mid number,
    title text,
    year number,
    director text
)

CREATE TABLE reviewer (
    rid number,
    name text
)

CREATE TABLE rating (
    rid number,
    mid number,
    stars number,
    ratingdate time
) ### 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) LIMIT 1