Which directors had a movie in either 1999 or 2000, and count them by a bar chart, I want to order Y from low to high order.
CREATE TABLE movie (
    movie_id int,
    Title text,
    Year int,
    Director text,
    Budget_million real,
    Gross_worldwide int
)

CREATE TABLE culture_company (
    Company_name text,
    Type text,
    Incorporated_in text,
    Group_Equity_Shareholding real,
    book_club_id text,
    movie_id text
)

CREATE TABLE book_club (
    book_club_id int,
    Year int,
    Author_or_Editor text,
    Book_Title text,
    Publisher text,
    Category text,
    Result text
)
SELECT Director, COUNT(Director) FROM movie WHERE Year = 1999 OR Year = 2000 GROUP BY Director ORDER BY COUNT(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: Which directors had a movie in either 1999 or 2000, and count them by a bar chart, I want to order Y from low to high order. ### Input: CREATE TABLE movie (
    movie_id int,
    Title text,
    Year int,
    Director text,
    Budget_million real,
    Gross_worldwide int
)

CREATE TABLE culture_company (
    Company_name text,
    Type text,
    Incorporated_in text,
    Group_Equity_Shareholding real,
    book_club_id text,
    movie_id text
)

CREATE TABLE book_club (
    book_club_id int,
    Year int,
    Author_or_Editor text,
    Book_Title text,
    Publisher text,
    Category text,
    Result text
) ### Response: SELECT Director, COUNT(Director) FROM movie WHERE Year = 1999 OR Year = 2000 GROUP BY Director ORDER BY COUNT(Director)