SQL Queries for Student Course Analysis

Beginner

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.

SQLMySQL

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

Unfinished

🎯 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

Teacher

labby

Labby

Labby is the LabEx teacher.