Scribd
Upload
5 views6 pages

P16 MySQL Queries

The document outlines a series of database operations including selecting a database, creating a table, and performing various data manipulations. Tasks include adding and modifying attributes, displaying student details based on specific criteria, and calculating statistics such as min, max, and average marks. It also involves deleting records and filtering students based on their streams and marks.

Uploaded by

Jeevitha Rajeshkanna
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 views6 pages

P16 MySQL Queries

The document outlines a series of database operations including selecting a database, creating a table, and performing various data manipulations. Tasks include adding and modifying attributes, displaying student details based on specific criteria, and calculating statistics such as min, max, and average marks. It also involves deleting records and filtering students based on their streams and marks.

Uploaded by

Jeevitha Rajeshkanna
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

>> Selecting the database:

>> Creating the table and Inserting Values:


1. Add a new attribute Age after Name:

2. Modify the data type of Class to char:


3. Drop the Column Age:

4. Increase the total marks of Humanities students by 10:


5. Display the names of students in descending order:

6. Display the details of students whose stream is NULL:

7. Display the names of students whose marks are between 450 and 500 (Both inclusive):
8. Display the details of students who are in 12A or 12B (use condition based on a list):

9. Delete the tuple 5555 from the table student:

10. Display the details of students whose name starts with S and in Science stream:
11. Display the number of Students in each Stream:

12. Display the details of student who is in 12A and got highest marks:

13. Display the min, max and average of Total marks:

You might also like