Scribd
Upload
5 views1 page

SQL Practical Questions

The document outlines a practical SQL exercise consisting of 20 mixed questions. It includes tasks such as creating a database and tables, inserting and displaying records, performing queries, and manipulating data. The exercises cover various SQL operations including JOINs, aggregations, and data updates.

Uploaded by

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

SQL Practical Questions

The document outlines a practical SQL exercise consisting of 20 mixed questions. It includes tasks such as creating a database and tables, inserting and displaying records, performing queries, and manipulating data. The exercises cover various SQL operations including JOINs, aggregations, and data updates.

Uploaded by

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

SQL Practical File - 20 Mixed Questions

1. Create a database named College.

2. Create a table Student with fields: Roll_No, Name, Age, Class, Marks.

3. Insert at least 5 records into the Student table.

4. Display all records from the Student table.

5. Display Name and Marks of students.

6. Find students who scored more than 75 marks.

7. Display students whose age is between 18 and 22.

8. Sort students by Marks in ascending order.

9. Find students whose name starts with 'A'.

10. Use LIKE operator to find names ending with 'n'.

11. Find the maximum marks.

12. Find the average marks of students.

13. Count total number of students.

14. Display average marks of each class using GROUP BY.

15. Update marks of a student.

16. Delete a student record using Roll_No.

17. Create another table Course with Course_ID, Course_Name, Roll_No.

18. Perform INNER JOIN between Student and Course tables.

19. Find the second highest marks using subquery.

20. ALTER table to add a new column Email.

You might also like