How many students are in each department?
CREATE TABLE department (
    dept_code text,
    dept_name text,
    school_code text,
    emp_num number,
    dept_address text,
    dept_extension text
)

CREATE TABLE course (
    crs_code text,
    dept_code text,
    crs_description text,
    crs_credit number
)

CREATE TABLE employee (
    emp_num number,
    emp_lname text,
    emp_fname text,
    emp_initial text,
    emp_jobcode text,
    emp_hiredate time,
    emp_dob time
)

CREATE TABLE student (
    stu_num number,
    stu_lname text,
    stu_fname text,
    stu_init text,
    stu_dob time,
    stu_hrs number,
    stu_class text,
    stu_gpa number,
    stu_transfer number,
    dept_code text,
    stu_phone text,
    prof_num number
)

CREATE TABLE enroll (
    class_code text,
    stu_num number,
    enroll_grade text
)

CREATE TABLE class (
    class_code text,
    crs_code text,
    class_section text,
    class_time text,
    class_room text,
    prof_num number
)

CREATE TABLE professor (
    emp_num number,
    dept_code text,
    prof_office text,
    prof_extension text,
    prof_high_degree text
)
SELECT COUNT(*), dept_code FROM student GROUP BY dept_code
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: How many students are in each department? ### Input: CREATE TABLE department (
    dept_code text,
    dept_name text,
    school_code text,
    emp_num number,
    dept_address text,
    dept_extension text
)

CREATE TABLE course (
    crs_code text,
    dept_code text,
    crs_description text,
    crs_credit number
)

CREATE TABLE employee (
    emp_num number,
    emp_lname text,
    emp_fname text,
    emp_initial text,
    emp_jobcode text,
    emp_hiredate time,
    emp_dob time
)

CREATE TABLE student (
    stu_num number,
    stu_lname text,
    stu_fname text,
    stu_init text,
    stu_dob time,
    stu_hrs number,
    stu_class text,
    stu_gpa number,
    stu_transfer number,
    dept_code text,
    stu_phone text,
    prof_num number
)

CREATE TABLE enroll (
    class_code text,
    stu_num number,
    enroll_grade text
)

CREATE TABLE class (
    class_code text,
    crs_code text,
    class_section text,
    class_time text,
    class_room text,
    prof_num number
)

CREATE TABLE professor (
    emp_num number,
    dept_code text,
    prof_office text,
    prof_extension text,
    prof_high_degree text
) ### Response: SELECT COUNT(*), dept_code FROM student GROUP BY dept_code