Scribd
Upload
5 views1 page

SQL Problem Set: Student Database Queries

The document outlines a SQL problem set that includes tasks such as creating a Student table with specific columns, inserting records, and performing various queries like listing students with high marks, counting enrollments, and updating course names. It also includes operations for deleting records of failing students and displaying specific student information based on criteria. The tasks are designed to test SQL skills in data manipulation and retrieval.

Uploaded by

re43634
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 views1 page

SQL Problem Set: Student Database Queries

The document outlines a SQL problem set that includes tasks such as creating a Student table with specific columns, inserting records, and performing various queries like listing students with high marks, counting enrollments, and updating course names. It also includes operations for deleting records of failing students and displaying specific student information based on criteria. The tasks are designed to test SQL skills in data manipulation and retrieval.

Uploaded by

re43634
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

SQL Problem Set

1. Create a table as for the following columns with primary key


2. Table Student(stud_id, stud_name, marks,course_name,faculty_name,doj)
3. insert at least 10 records into table.(insert some null values)
4. List students who scored more than 80 marks.
5. Retrieve students with the highest marks in each course.
6. count how many students are enrolled in each course.
7. Update the course name from “DBMS” to “Database Systems”.
8. Display students who are not enrolled in any course.
9. Write a query to show the top 2 scorers overall.
10. Delete students who failed (marks < 35).
11. Display the student records from highest marks to lowest marks
12. Display the list of student where name begins with p
13. Display the list of student date of joining is 2000 year
14. Update the student marks to 100 where faculty name is ‘xyz’
15. Make a duplicate copy of the table

You might also like