CREATE TABLE artist (Artist_ID NUMBER, Name CLOB, Country CLOB, Year_Join NUMBER, Age NUMBER)
CREATE TABLE exhibition_record (Exhibition_ID NUMBER, Date CLOB, Attendance NUMBER)
CREATE TABLE exhibition (Exhibition_ID NUMBER, Year NUMBER, Theme CLOB, Artist_ID NUMBER, Ticket_Price FLOAT)

Show all artist names and the number of exhibitions for each artist Show bar chart, show X from high to low order.
SELECT Name, COUNT(*) FROM exhibition AS T1 JOIN artist AS T2 ON T1.Artist_ID = T2.Artist_ID GROUP BY T1.Artist_ID ORDER BY Name DESC
SELECT "Name", COUNT(*) FROM "exhibition" "T1" JOIN "artist" "T2" ON "T1"."Artist_ID" = "T2"."Artist_ID" GROUP BY "T1"."Artist_ID" ORDER BY "Name" DESC