bp Interview Question

Sql queries on joins and normalization