Write a SQL query to display the column value of 'Departmentid', Name of the HOD from the column value 'Name' and finally need to generate the third column as total number of lecturers working under each HOD from the 'Student_Details' table with the help of self join.
