SQL Questions > Tables are given below: Structure of Department table with sample data ---------------------------------------------------------------- ID DEPARTMENT_NAME 10 ACCOUNTING 20 HR 30 IT 40 SECURITY 50 MANAGEMENT ----------------------------------------------------------------- Structure of Employee Table with sample data ID FIRST_NAME LAST_NAME DEPT_ID SALARY BONUS 1 John Smith 10 20000 400 2 Sharon Smith 10 30000 4000 3 Mary Lee 10 30000 2000 4 David Lee 10 40000 2000 5 Rob Lee 20 40000 2000 6 Joanna Jones 20 34000 2050 7 Emma Smith 20 54000 5050 8 Maria Jones 30 52000 2250 9 Jose Enriquez 30 54000 4450 10 Ashok Dey 30 55000 4450 11 Raj Singh 40 34000 4450 12 Yvonne Everts 40 35000 4450 13 Sam Leland 40 44000 5550 14 Dave Freeman 50 74000 10098 15 Andy Lee 50 75000 5600 16 Red James 50 75200 8700 1. > Show the sql that will give the count of employees in each department Dept_id count 10 4 20 3 30 3
