When to use Inner join & when to use subquery?
Inner joins to be used on the constrains(primary key/foregin key) on the table, when to extract information from the multiple tables.