Question 2|| display the name of students whose id is other than 4 and 7 from studenttable

1.Write a query to display the name of students whose id is other than 4 and 7 from student table.Order the result by student name in ascending order. drop table Student create table Student ( Student_Id int primary key , Student_Name varchar(30) , Address varchar(40) , City varchar(30) , Age int , Department_id int foreign Key references Department (Department_id) ) insert into Student select 1,'A','USA','A',10,1 union select 2,'A','USA','A',10,2 ---1.display the name of students --2.Student id other than 4 and 7 --3.by ascending order (student name) select Student_Name from Student where Student_Id not in (4,7) order by Student_Name asc