For each branch id, what are the names of the branches that were registered after 2015 Visualize by bar chart, and I want to order by the the total number in desc.
CREATE TABLE membership_register_branch (
    Member_ID int,
    Branch_ID text,
    Register_Year text
)

CREATE TABLE branch (
    Branch_ID int,
    Name text,
    Open_year text,
    Address_road text,
    City text,
    membership_amount text
)

CREATE TABLE purchase (
    Member_ID int,
    Branch_ID text,
    Year text,
    Total_pounds real
)

CREATE TABLE member (
    Member_ID int,
    Card_Number text,
    Name text,
    Hometown text,
    Level int
)
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
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: For each branch id, what are the names of the branches that were registered after 2015 Visualize by bar chart, and I want to order by the the total number in desc. ### Input: CREATE TABLE membership_register_branch (
    Member_ID int,
    Branch_ID text,
    Register_Year text
)

CREATE TABLE branch (
    Branch_ID int,
    Name text,
    Open_year text,
    Address_road text,
    City text,
    membership_amount text
)

CREATE TABLE purchase (
    Member_ID int,
    Branch_ID text,
    Year text,
    Total_pounds real
)

CREATE TABLE member (
    Member_ID int,
    Card_Number text,
    Name text,
    Hometown text,
    Level int
) ### Response: 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