Question

Create a student data base with attributes student name , student roll no. & address insert 10 records into it & display the name & roll no. of those students who belongs to same address.

❌ don't Spam ❌​

Answer 1

Create table Student(StudentName vαrchαr(20), StudNo int(2) Primary Key, Address vαrchαr(20));

Insert into Student values('Vanessa J', 6, 'Dubai');

Insert into Student values('James Mirth', 7, 'Dubai');

Insert into Student values('Veronica M', 12, 'Sharjah');

Insert into Student values('Kira Kalani', 13, 'Ajman');

Insert into Student values('Tori Kay', 14, 'RAK');

Insert into Student values('Johnathan', 15, 'Dubai');

Insert into Student values('Chris Daniel', 16, 'UAQ');

Insert into Student values('Kiara Kai', 20, 'Abu Dhabi');

Insert into Student values('Ethan Dolan', 22, 'Fujairah');

Insert into Student values('Grayson Dolan', 23, 'Dubai');

Select StudentName, StudNo from Student where Address = 'Dubai';