Create the two tables for SQL and answer the questions below SQL Queries

$1.$ Courses $($Courses$)$

$$ course$\_$id $($INT PRIMARY KEY$)$: Unique identifier for each course

$$ course$\_$name $($VARCHAR$(255))$: Name of the course

$$ department$\_$id $($INT$)$: Foreign key referencing the department$\_$id in the

Departments table $($not provided$)$

$$ credits $($INT$)$: Number of credits for the course

$2.$ Enrollments $($Enrollments$)$

$$ enrollment$\_$id $($INT PRIMARY KEY$)$: Unique identifier for each enrollment

$$ student$\_$id $($INT$)$: Foreign key referencing the student$\_$id in the Students table $($not

provided$)$

$$ course$\_$id $($INT$)$: Foreign key referencing the course$\_$id in the Courses table

$$ semester $($VARCHAR$(10))$: Semester the course was enrolled in $($e$.$g$.,$ Fall $2024,$

Spring $2025)$

$$ grade $($CHAR$(2))$: Letter grade earned in the course $($e$.$g$.,$ A$,$ B$,$ C$,$ F$)$

Answer the following questions using SQL queries.

$1.$ List all course names and their corresponding credit values.

$2.$ Find the total number of courses offered by the university.

$3.$ Retrieve the names of all courses with $3$ or more credits.

$4.$ List the first $5$ course names

$5.$ Find the total number of courses with exactly $3$ credits.

$6.$ Retrieve all courses offered in the Fall $2024$ semester.

$7.$ List all student IDs enrolled in the university.

$8.$ Retrieve all courses with a course name starting with "Introduction to$"($case$-$

sensitive$).[$Hint: Use LIKE operator.$]$

$9.$ List all courses offered by the department number $3.$

$10.$ Find the list of course $($course$\_$id$),$ number of students $($student$\_$id$)$ during the

Fall $2024$ semester who got $$A$$ in the course. $[$Hint: use count and group by$]$