Sudnya Ecommerece interview question

SQL join queries to solve