Scribd
Upload
5 views2 pages

Practice SQL Query

The document lists student information including names, ages, genders, majors, GPAs, and enrollment dates. It also outlines various queries to extract specific data such as students with GPAs above 3.5, those majoring in Physics, and students older than 20. Additionally, it includes tasks to calculate the total number of students and the average GPA.

Uploaded by

dabhamare
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
5 views2 pages

Practice SQL Query

The document lists student information including names, ages, genders, majors, GPAs, and enrollment dates. It also outlines various queries to extract specific data such as students with GPAs above 3.5, those majoring in Physics, and students older than 20. Additionally, it includes tasks to calculate the total number of students and the average GPA.

Uploaded by

dabhamare
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd

StudentI FirstNam LastNam Enrollme

Age Gender Major GPA


D e e ntDate

2023-01-
101 Arjun Mehta 20 M Physics 3.8
15

2022-09-
102 Beatrice Smith 22 F Biology 3.2
10

2024-01-
103 Charlie Davis 19 M Physics 3.5
20

2023-05-
104 Daisy Miller 21 F Arts 3.9
12

2022-02-
105 Ethan Hunt 23 M Biology 2.9
28
1. Write a query to show the FirstName, LastName, and Major for all
students.
Find all students who have a GPA greater than 3.5.
2. List all students who are majoring in 'Physics’.
3. Find all students who are older than 20.
4. Find students who have a GPA below 3.0 and are in the 'Biology'
major.
5. How many total students are in the table?
6. What is the average GPA of all students in the table?
7. Select all students who are between the ages of 20 and 22 (inclusive).
8. Find all students whose FirstName starts with the letter 'A'.

You might also like