Xceedance interview question

Join operation in SQL and use foreign keys to implement them.