IBM interview question

Questions about SQL and modeling a scenario.