Consider the StudentInfo table shown below, which stores stu…
Consider the StudentInfo table shown below, which stores student information. The Primary Key of this table is (StudentID). Attribute DataType Description StudentID Number ID of the university student LName String Last Name FName String First Name HomeZip Number 5 digit Zip code of Home address Consider the StudentExternalEmail table shown below, which stores student’s non-university email information. The Primary Key of this table is a compound key (StudentID, Email). Not all students have registered an external email address with the University. Attribute DataType Description StudentID Number ID of the university student Email String Email address Write a SQL query to retrieve student information (id, LName, email) of students whose home zip code is ‘46556’
Read Details