Find the subject ID, subject name, and the corresponding number of available courses for each subject.
CREATE TABLE Subjects (
    subject_name VARCHAR,
    subject_id VARCHAR
)

CREATE TABLE Courses (
    subject_id VARCHAR
)
SELECT T1.subject_id, T2.subject_name, COUNT(*) FROM Courses AS T1 JOIN Subjects AS T2 ON T1.subject_id = T2.subject_id GROUP BY T1.subject_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: Find the subject ID, subject name, and the corresponding number of available courses for each subject. ### Input: CREATE TABLE Subjects (
    subject_name VARCHAR,
    subject_id VARCHAR
)

CREATE TABLE Courses (
    subject_id VARCHAR
) ### Response: SELECT T1.subject_id, T2.subject_name, COUNT(*) FROM Courses AS T1 JOIN Subjects AS T2 ON T1.subject_id = T2.subject_id GROUP BY T1.subject_id