HealthTrackDB-Project

Instructions:

Tasks:

Extract the data from the url https://www.kaggle.com/datasets/slmsshk/medical-students-dataset

Create a database called medical_db on MySQL server.

Create a table named dbo.medical and upload the CSV file on the table.

Using stored procedure, get students with height above a height of 160.

Use subquery to find students with height above 160.

Used common table expression to rank Students by BMI within Each Gender.

Use temporary view for students with medical conditions.

Count by blood group

Find the highest weights of students in each gender using a CTE.

Create an index to speed up queries filtering by Gender and Blood type.

Find students whose Ages are below the overall average using subquery.