Hexagon Interview Question

SQL queries about joins, foreign keys,views.