The "students" Dataset:
| Field Name | Description |
|---|---|
inter_dom | Types of students (international or domestic) |
japanese_cate | Japanese language proficiency |
english_cate | English language proficiency |
academic | Current academic level (undergraduate or graduate) |
age | Current age of student |
stay | Current length of stay in years |
todep | Total score of depression (PHQ-9 test) |
tosc | Total score of social connectedness (SCS test) |
toas | Total score of acculturative stress (ASISS test) |
-- View the data in "students"
SELECT *
FROM students;Project Instructions: Explore and analyze the students data to see how the length of stay impacts the average mental health diagnostic scores of the international students present in the study.
Results:
-- Organized Results
SELECT
stay AS stay,
COUNT(inter_dom = 'Inter') AS count_int,
ROUND(AVG(todep), 2) AS average_phq,
ROUND (AVG(tosc), 2) AS average_scs,
ROUND (AVG(toas), 2) AS average_as
FROM students
WHERE inter_dom = 'Inter'
GROUP BY stay
ORDER BY stay DESC
LIMIT 9;The table presented summarizes the relationship between the length of stay and the average mental health diagnostic scores for international students. Here is an explanation of each column in the results:
- stay: Represents the length of stay of the international students, likely measured in years or another time unit.
- count_int: The number of international students for each length of stay category.
- average_phq: The average PHQ (Patient Health Questionnaire) score, which is commonly used to assess depression severity.
- average_scs: The average SCS (Self-Compassion Scale) score, which measures self-compassion levels.
- average_as: The average AS (Anxiety Scale) score, which reflects anxiety levels.
The table is sorted by the length of stay in descending order, so students with the longest stays appear at the top. This allows you to observe how mental health scores change as the length of stay increases or decreases. By analyzing these averages, you can identify trends, such as whether longer stays are associated with better or worse mental health outcomes among international students.