Question

Write the queries (SQL Commands) for following table:

Table Name: STUDENT

Admno Name Class House_Color Marks

1001 Sonam 9 Blue 70

1002 Ravi 10 Yellow 60

1003 Poonam 10 Green 65


a)Write SQL command to display the table.


b) Display the list of students whose house color is blue.


c) Display the admission number of students whose color is green


d) To view records in ascending order of Marks


e) Display the class of Ravi


f) Change marks of Sonam as 75​

Answer 1

Answer:

a) select * from STUDENT;

b) select * from STUDENT where House_Color = "Blue";

c) select Admno from STUDENT where House_Color = "Green";

d) select * from STUDENT ORDER BY Marks ASC

e) select Class from STUDENT where Name = "Ravi";

f) UPDATE STUDENTS SET Marks = "75" WHERE Name = "Sonam";

Answer 2

The answer to the questions are given below.

Explanation:

• Select * form STUDENT ;
• Select * from STUDENT where House_color= 'blue';
• Select Admno from STUDENT where House_color= 'green';
• Select * from STUDENT ORDER BY Marks;
• Select Class from STUDENT where name='Ravi';
• Update STUDENT SET Marks='75' where Name='Sonam';