Give me a histogram for how many registed students do each course have? List course name and the number of their registered students?
CREATE TABLE Student_Course_Registrations (
    student_id INTEGER,
    course_id INTEGER,
    registration_date DATETIME
)

CREATE TABLE Addresses (
    address_id INTEGER,
    line_1 VARCHAR(80),
    line_2 VARCHAR(80),
    city VARCHAR(50),
    zip_postcode CHAR(20),
    state_province_county VARCHAR(50),
    country VARCHAR(50)
)

CREATE TABLE Candidate_Assessments (
    candidate_id INTEGER,
    qualification CHAR(15),
    assessment_date DATETIME,
    asessment_outcome_code CHAR(15)
)

CREATE TABLE Courses (
    course_id VARCHAR(100),
    course_name VARCHAR(120),
    course_description VARCHAR(255),
    other_details VARCHAR(255)
)

CREATE TABLE Student_Course_Attendance (
    student_id INTEGER,
    course_id INTEGER,
    date_of_attendance DATETIME
)

CREATE TABLE People (
    person_id INTEGER,
    first_name VARCHAR(255),
    middle_name VARCHAR(255),
    last_name VARCHAR(255),
    cell_mobile_number VARCHAR(40),
    email_address VARCHAR(40),
    login_name VARCHAR(40),
    password VARCHAR(40)
)

CREATE TABLE Candidates (
    candidate_id INTEGER,
    candidate_details VARCHAR(255)
)

CREATE TABLE People_Addresses (
    person_address_id INTEGER,
    person_id INTEGER,
    address_id INTEGER,
    date_from DATETIME,
    date_to DATETIME
)

CREATE TABLE Students (
    student_id INTEGER,
    student_details VARCHAR(255)
)
SELECT course_name, COUNT(*) FROM Students AS T1 JOIN Student_Course_Registrations AS T2 ON T1.student_id = T2.student_id JOIN Courses AS T3 ON T2.course_id = T3.course_id GROUP BY T2.course_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: Give me a histogram for how many registed students do each course have? List course name and the number of their registered students? ### Input: CREATE TABLE Student_Course_Registrations (
    student_id INTEGER,
    course_id INTEGER,
    registration_date DATETIME
)

CREATE TABLE Addresses (
    address_id INTEGER,
    line_1 VARCHAR(80),
    line_2 VARCHAR(80),
    city VARCHAR(50),
    zip_postcode CHAR(20),
    state_province_county VARCHAR(50),
    country VARCHAR(50)
)

CREATE TABLE Candidate_Assessments (
    candidate_id INTEGER,
    qualification CHAR(15),
    assessment_date DATETIME,
    asessment_outcome_code CHAR(15)
)

CREATE TABLE Courses (
    course_id VARCHAR(100),
    course_name VARCHAR(120),
    course_description VARCHAR(255),
    other_details VARCHAR(255)
)

CREATE TABLE Student_Course_Attendance (
    student_id INTEGER,
    course_id INTEGER,
    date_of_attendance DATETIME
)

CREATE TABLE People (
    person_id INTEGER,
    first_name VARCHAR(255),
    middle_name VARCHAR(255),
    last_name VARCHAR(255),
    cell_mobile_number VARCHAR(40),
    email_address VARCHAR(40),
    login_name VARCHAR(40),
    password VARCHAR(40)
)

CREATE TABLE Candidates (
    candidate_id INTEGER,
    candidate_details VARCHAR(255)
)

CREATE TABLE People_Addresses (
    person_address_id INTEGER,
    person_id INTEGER,
    address_id INTEGER,
    date_from DATETIME,
    date_to DATETIME
)

CREATE TABLE Students (
    student_id INTEGER,
    student_details VARCHAR(255)
) ### Response: SELECT course_name, COUNT(*) FROM Students AS T1 JOIN Student_Course_Registrations AS T2 ON T1.student_id = T2.student_id JOIN Courses AS T3 ON T2.course_id = T3.course_id GROUP BY T2.course_id