KEMBAR78
CBSE Class12 SQL Project | PDF
Scribd
Upload
15 views1 page

CBSE Class12 SQL Project

This project focuses on SQL queries practice for Class 12 Computer Science students, featuring five specific questions aimed at enhancing skills in data retrieval and manipulation. A sample STUDENT table is provided, including data on students' roll numbers, names, classes, sections, marks, and genders. The project emphasizes the importance of mastering these queries for effective data management and analysis.

Uploaded by

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

CBSE Class12 SQL Project

This project focuses on SQL queries practice for Class 12 Computer Science students, featuring five specific questions aimed at enhancing skills in data retrieval and manipulation. A sample STUDENT table is provided, including data on students' roll numbers, names, classes, sections, marks, and genders. The project emphasizes the importance of mastering these queries for effective data management and analysis.

Uploaded by

jhah71201
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 1

CBSE Class 12 Computer Science Project

Topic: SQL Queries Practice

Introduction
Structured Query Language (SQL) is used to communicate with a database. This project
contains 5 SQL questions to help students strengthen their skills in retrieving, filtering, and
manipulating data using SQL queries.

Sample Table: STUDENT


Below is the structure and sample data for the STUDENT table used in the queries:

| RollNo | Name | Class | Section | Marks | Gender |


|--------|----------|-------|---------|-------|--------|
| 101 | Anjali | 12 | A | 89 | F |
| 102 | Rohan | 12 | B | 75 | M |
| 103 | Priya | 12 | A | 92 | F |
| 104 | Sameer | 12 | B | 68 | M |
| 105 | Shruti | 12 | A | 85 | F |

SQL Questions
1. 1. Display the names of all students who have scored more than 80 marks.
2. 2. List all female students from Section A.
3. 3. Show the details of students sorted by Marks in descending order.
4. 4. Display the total number of students in each section.
5. 5. Find the average marks of male and female students separately.

Conclusion
Through these questions, students can gain hands-on experience in querying databases
using SQL. Understanding these types of queries is essential for managing and analyzing
data effectively.

You might also like