DATA 225 Database Systems for Analytics (Instructor: Ron Mak)
Introduction to SQL Queries
Database tables
student
id
last
first
S1001
Doe
John
S1005
Nova
Tim
S1009
Klein
Leslie
S1014
Jane
Mary
S1021
Smith
Kim
teacher
id
last
first
T7003
Rogers
Pat
T7008
Thompson
Sidney
T7012
Lane
John
T7051
Flynn
Mabel
Queries
Who are the students?
Who are the teachers?
Query result
Result table to appear here.