Show all artist names and the number of exhibitions for each artist.
CREATE TABLE exhibition (
    artist_id VARCHAR
)

CREATE TABLE artist (
    name VARCHAR,
    artist_id VARCHAR
)
SELECT T2.name, COUNT(*) FROM exhibition AS T1 JOIN artist AS T2 ON T1.artist_id = T2.artist_id GROUP BY T1.artist_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 all artist names and the number of exhibitions for each artist. ### Input: CREATE TABLE exhibition (
    artist_id VARCHAR
)

CREATE TABLE artist (
    name VARCHAR,
    artist_id VARCHAR
) ### Response: SELECT T2.name, COUNT(*) FROM exhibition AS T1 JOIN artist AS T2 ON T1.artist_id = T2.artist_id GROUP BY T1.artist_id