Introduction
In this project, you will learn how to perform various SQL queries on a student course database. The database consists of three tables: Student table (S), Course table (C), and Student Course table (SC). You will learn how to retrieve and manipulate data from these tables to accomplish different tasks.
👀 Preview
🎯 Tasks
In this project, you will learn:
- How to list the names of all students who have not taken courses taught by the "Daniel" teacher
- How to list the student numbers and names of students who have failed (grade < 60) in two or more courses
- How to list the names of all students who have taken both course "11" and course "12"
- How to list the student numbers of all students whose grades in course "11" are higher than those in course "12", and sort them in ascending order
- How to list the names of all students who are older than "John Davis"
- How to list the student number of the student with the highest grade among all students who have taken course "12"
- How to list the names of all students, along with their selected course IDs and grades
- How to list the student numbers and total grades (alias as: SG) of students who have taken four or more courses, sorted in descending order of total grades
🏆 Achievements
After completing this project, you will be able to:
- Understand how to write complex SQL queries to retrieve and manipulate data from a relational database
- Apply various SQL techniques, such as subqueries, joins, aggregations, and sorting, to solve real-world data analysis problems
- Develop SQL skills that are essential for data-driven decision making and problem-solving