Show the id, name of each festival and the number of artworks it has nominated.
CREATE TABLE artwork (
    artwork_id number,
    type text,
    name text
)

CREATE TABLE nomination (
    artwork_id number,
    festival_id number,
    result text
)

CREATE TABLE festival_detail (
    festival_id number,
    festival_name text,
    chair_name text,
    location text,
    year number,
    num_of_audience number
)
SELECT T1.festival_id, T3.festival_name, COUNT(*) FROM nomination AS T1 JOIN artwork AS T2 ON T1.artwork_id = T2.artwork_id JOIN festival_detail AS T3 ON T1.festival_id = T3.festival_id GROUP BY T1.festival_id
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: Show the id, name of each festival and the number of artworks it has nominated. ### Input: CREATE TABLE artwork (
    artwork_id number,
    type text,
    name text
)

CREATE TABLE nomination (
    artwork_id number,
    festival_id number,
    result text
)

CREATE TABLE festival_detail (
    festival_id number,
    festival_name text,
    chair_name text,
    location text,
    year number,
    num_of_audience number
) ### Response: SELECT T1.festival_id, T3.festival_name, COUNT(*) FROM nomination AS T1 JOIN artwork AS T2 ON T1.artwork_id = T2.artwork_id JOIN festival_detail AS T3 ON T1.festival_id = T3.festival_id GROUP BY T1.festival_id