Halving Course Credits

Problem

The curriculum department is testing a new system where every course's credit weight is cut in half. Retrieve the course name and a new column named half_credits which is the course credits divided by 2.

Database Schema

Table: students

• id (INT): Unique identifier for the student.
• name (VARCHAR): Full name of the student.
• grade_level (INT): The student's current grade level (9-12).
• enrollment_year (INT): The year the student enrolled.

Table: courses

• id (INT): Unique identifier for the course.
• name (VARCHAR): Name of the course.
• subject (VARCHAR): Subject area (e.g., Math, Science).
• credits (INT): Number of course credits.

Table: grades

• id (INT): Unique identifier for the grade entry.
• student_id (INT): Foreign key referencing the student.
• course_id (INT): Foreign key referencing the course.
• score (INT): Numeric score (0-100).
• term (VARCHAR): Term of the grade (e.g., Fall 2022).

Try It

Hint

Solution