Write SQL statements for following: Student( Enrno, name, courseId, emailId, cellno) Course(courseId, course_nm, duration) i) Add a column city in student table. ii) Find out list of students who have...

Write SQL statements for following:
Student( Enrno, name, courseId, emailId, cellno)
Course(courseId, course_nm, duration)
i) Add a column city in student table.
ii) Find out list of students who have enrolled in “computer” course.
iii) List name of all courses with their duration.
iv) List name of all students start with „a‟.
v) List email Id and cell no of all mechanical engineering students