Scribd
Upload
8 views4 pages

SQL Queries for Student Data Analysis

The document outlines a series of SQL queries related to a student database. It includes tasks such as displaying student names based on percentage, filtering students by section, and updating records. Additionally, it requests to add new records and calculate averages based on gender and section.

Uploaded by

connectwithrajul
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
8 views4 pages

SQL Queries for Student Data Analysis

The document outlines a series of SQL queries related to a student database. It includes tasks such as displaying student names based on percentage, filtering students by section, and updating records. Additionally, it requests to add new records and calculate averages based on gender and section.

Uploaded by

connectwithrajul
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

Project Work

(SQL)
• Refer to the table below for the following queries:

1. Display the names of the students in order of


increasing percentage?

2. Display the names and percentage of students where


percentage is between 60 and 90?
3. Select information of students where section is ‘G’ or
‘F’?

4. Display the name and roll no. of students where name


has ‘l’ somewhere?

5. Increase the percentage by 5% where percentage of a


student is less than 80?
6. Add two more records to the table where one of them
has percentage set as null and other has section ‘B’?

7. Display name of students who are born in the month


of ‘June’?

8. Display the average percentage of students gender


wise?
9. Display the average percentage of student’s section
wise?

[Link] the name and section of students whose


surname is ‘Singh’?

You might also like