CBSE 2025, Compartment, Set 4

Question

Consider the table STAFF given below :

![Table Staff](https://www.edvaya.com/images/cbse/computer-science/2025/set4/q32-staff.webp)

Write the suitable SQL queries to perform the following tasks:
(I) To display the average salary of each department.
(II) To insert the following record in the table, STAFF.
STAFF ID: S333
STAFF NAME: GURMEET
SALARY: 15000
DEPARTMENT: ADMIN
DESIGNATION: CLERK
(III) To display the unique designations from the table.
(IV) To display all the details of the staff whose name is of four letters.

Edvaya · Accepted Answer

The correct answer is Subjective. **(I) To display the average salary of each department:** ```sql SELECT DEPARTMENT, AVG(SALARY) FROM STAFF GROUP BY DEPARTMENT; ``` **(II) To insert the record:** ```sql INSERT INTO STAFF VALUES ("S333", "GURMEET", 15000, "ADMIN", "CLERK"); ``` **(III) To display unique designations:** ```sql SELECT DISTINCT DESIGNATION FROM STAFF; ``` **(IV) To display staff details whose name is exactly four letters:** ```sql SELECT * FROM STAFF WHERE STAFF_NAME LIKE "____"; ```

Edvaya Target

Edvaya Aspire

Take a Free Mock Test

Target Subjects

Aspire Subjects

Subject Mastery

Computer Science > Database Management > Structured Query Language

Keep Practicing

Edvaya Target

Current Question

Community Stats

Track Your Progress

Quick Actions

We Value Your Privacy