E2open Interview Question

Basic SQL questions on joins primary key foreign key stored procedure subqueries where and having