Q. Write SQL commands for the following on the basis of given table STUDENT:
1. Display the names of the students who are getting a grade 'C' in either GAME or SUPW.
2. Display the different games offered in the school.
3. Display the SUPW taken up by the students, whose name starts with 'A'.
Answer:-
(1)
Select name from student
Where grade1 = "C" or grade2 = "C" ;
(2)
Select distinct GAME from student ;
(3)
Select Name, SUPW from student.
Where name like “A%” ;
Display the names of the students who have have obtained Game and SUPW
ReplyDeleteCLUB
I can not understand what you want to say ?????.
DeleteThe 3.question, cannot understand
ReplyDeleteSorry. I have Corrected it.
DeleteShouldn't SUPW be also selected frm the table for question 3
ReplyDeleteRight. Now I have Corrected it.
Delete1 questions, answer is not working
ReplyDeletePlease try it again.
DeletePlease try to put correct answer on your site ...
ReplyDeleteTell me which is wrong.
Delete1st and is wrong grade 2 is not in table itself
ReplyDeleteAll answers are correct.
DeleteGOOD WORK
ReplyDeleteThankyou : )
DeleteAppreciate your work ..👍
ReplyDeleteThankyou 😊
DeleteQ3 me display supw bola h tho name tho name ko display nhi Karay ge n
ReplyDeleteSelect supw from student
Where name like 'a%';
Ye hogi coding tho
It is also correct.
Deletein 3rd part it should be supw not spuw
ReplyDeleteSorry, I have corrected it.
DeleteHmm
ReplyDeleteKeep up the good work man..."am loving it"
ReplyDeleteTruly
DeleteBruh the admin still alive (I mean active in a funny way)
ReplyDeletePost a Comment
You can help us by Clicking on ads. ^_^
Please do not send spam comment : )