CREATE TABLE membership_register_branch (Member_ID NUMBER, Branch_ID CLOB, Register_Year CLOB)
CREATE TABLE purchase (Member_ID NUMBER, Branch_ID CLOB, Year CLOB, Total_pounds FLOAT)
CREATE TABLE member (Member_ID NUMBER, Card_Number CLOB, Name CLOB, Hometown CLOB, Level NUMBER)
CREATE TABLE branch (Branch_ID NUMBER, Name CLOB, Open_year CLOB, Address_road CLOB, City CLOB, membership_amount CLOB)

Show all branch names with the number of members in each branch registered after 2015 Plot them as bar chart, and sort in descending by the Y please.
SELECT Name, COUNT(*) FROM membership_register_branch AS T1 JOIN branch AS T2 ON T1.Branch_ID = T2.Branch_ID WHERE T1.Register_Year > 2015 GROUP BY T2.Branch_ID ORDER BY COUNT(*) DESC
SELECT "Name", COUNT(*) FROM "membership_register_branch" "T1" JOIN "branch" "T2" ON "T1"."Branch_ID" = "T2"."Branch_ID" WHERE "T1"."Register_Year" > 2015 GROUP BY "T2"."Branch_ID" ORDER BY COUNT(*) DESC