CREATE TABLE member (Member_ID NUMBER, Card_Number CLOB, Name CLOB, Hometown CLOB, Level NUMBER)
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 branch (Branch_ID NUMBER, Name CLOB, Open_year CLOB, Address_road CLOB, City CLOB, membership_amount CLOB)

For each branch id, what are the names of the branches that were registered after 2015 Visualize by bar chart, and sort in ascending by the Name.
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 Name
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 "Name"