$1.$ Write an SQL query to count the number of students in each department.

$2.$ How would you select departments with more than $2$ students enrolled, along with the count of students in each department?

$3.$ Provide an SQL query to retrieve the first names of students along with the names of the courses they are enrolled in$,$ using a left join.

$4.$ How would you retrieve the first names of students along with the names of the courses they are enrolled in$,$ using an inner join?

$5.$ Write an SQL query to retrieve the first names of students along with the names of the courses they are enrolled in$,$ using an outer join.

$6.$ Retrieve the average age of students in each department.

$7.$ Count the number of courses each student is enrolled in$.$

$8.$ Select the departments and the number of students in each, but include only departments with more than $5$ students.

$9.$ Retrieve students who are not enrolled in any course

$10.$ Retrieve all course names along with the count of students enrolled in each course, including courses with no students.

$11.$ Select students who have NULL as their contact number.

$12.$ Retrieve the total number of students in each department, along with the department name $($assuming a "Departments" table$).$

$13.$ Select the average admission year of students grouped by gender.

$14.$ Retrieve the list of courses where no students are enrolled.

$15.$ Count the number of students in each gender category and in each departmentWrite an SQL query to count the number of students in each department.

How would you select departments with more than $2$ students enrolled, along with the count of

students in each department?

Provide an SQL query to retrieve the first names of students along with the names of the courses

they are enrolled in$,$ using a left join.

How would you retrieve the first names of students along with the names of the courses they are

enrolled in$,$ using an inner join?

Write an SQL query to retrieve the first names of students along with the names of the courses

they are enrolled in$,$ using an outer join.

Retrieve the average age of students in each department.

Count the number of courses each student is enrolled in$.$

Select the departments and the number of students in each, but include only departments with

more than $5$ students.

Retrieve students who are not enrolled in any course

Retrieve all course names along with the count of students enrolled in each course, including

courses with no students.

Select students who have NULL as their contact number.

Retrieve the total number of students in each department, along with the department name

$($assuming a "Departments" table$).$

Select the average admission year of students grouped by gender.

Retrieve the list of courses where no students are enrolled.

Count the number of students in each gender category and in each department