Populate the database with dummy data in my sql workbench.

Build a simple interface from which the users can query the underlying database in my sql workbench

Allow the user to execute at least $5$ different queries of the database. The query must be executed within the Python code. The following are some of the suggested queries:

Find all students enrolled in a specific course taught by a particular lecturer.

List all students with an average grade above $70\%$ who are in their final year of studies.

Identify students who haven't registered for any courses in the current semester.

Retrieve the contact information for the faculty advisor of a specific student.

Search for lecturers with expertise in a particular research area.

List all courses taught by lecturers in a specific department.

Identify lecturers who have supervised the most student research projects.

Generate a report on the publications of lecturers in the past year.

Retrieve the names of students advised by a specific lecturer.

Find all staff members employed in a specific department.

Identify employees who supervise student employees in a particular program.