Practicing for Functions & Procedures of Database Management System

Questions 1 of 10
  • Q.
    Create function dept count(dept_name varchar(20))
    begin
    declare d count integer;
    select count(*) into d count
    from instructor
    where instructor.dept_name= dept_name
    return d count;
    end
    Find the error in the the above statement.