P Precreate Function Dept Countdeptname Varchar20 Begin Declare #382

</p> <pre><code class="language-text">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 </code></pre> <p>Find the error in the the above statement.

This multiple choice question (MCQ) is related to the book/course gs gs117 Database Management System. It can also be found in gs gs117 SQL: Queries, Constraints and Triggers - Functions and Procedures - Quiz No.1.

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