mySQL

Student Faculty Stuld lastName firstName major credits facID name department rank Smith Chin 90 36 51001 S1002 S1005 S1010 Tom Ann Perry Edward History Math History Art Lee F101 F105 F110 F115 F221 Adams Tanaka Byrne Smith Smith Art CSC Math History CSC Professor Instructor Assistant Associate Professor Burns S1013 McCarthy Owen Math S1015 S1020 Jones Rivers Mary Jane Math CSC Enroll Class grade classNumber faced schedule room ART103A F101 CSC201A F105 CSC203A F105 HST205A F115 MTH101B F110 MTH103CF110 MWF9 TuThF10 MThF12 MWF11 MTuTh9 MWF11 H221 M110 M110 H221 H225 H225 Stuld 51001 51001 S1002 S1002 S1002 S1010 S1010 S1020 S1020 Class Number ART103A HST205A ART103A CSC201A MTH103C ART103A MTH103C CSC201A MTH101B 5) Find the lastName(s) of student(s) whose lastName and firstName end in 'n'. CE-Basic SQL) What basic relational algebra operation corresponds to two tables appearing in the FROM of a query? Show an example of this operation using tables that you create, each having two columns and two rows