For each director, return the highest rating among all of their movies and the value of that rating, group by director in a scatter, and Ignore movies whose director is NULL.
CREATE TABLE Reviewer (
    rID int,
    name text
)

CREATE TABLE Movie (
    mID int,
    title text,
    year int,
    director text
)

CREATE TABLE Rating (
    rID int,
    mID int,
    stars int,
    ratingDate date
)
SELECT stars, MAX(T1.stars) FROM Rating AS T1 JOIN Movie AS T2 ON T1.mID = T2.mID WHERE director <> "null" GROUP BY director
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: For each director, return the highest rating among all of their movies and the value of that rating, group by director in a scatter, and Ignore movies whose director is NULL. ### Input: CREATE TABLE Reviewer (
    rID int,
    name text
)

CREATE TABLE Movie (
    mID int,
    title text,
    year int,
    director text
)

CREATE TABLE Rating (
    rID int,
    mID int,
    stars int,
    ratingDate date
) ### Response: SELECT stars, MAX(T1.stars) FROM Rating AS T1 JOIN Movie AS T2 ON T1.mID = T2.mID WHERE director <> "null" GROUP BY director