Need to create 2 MySQL queries:
1. In the database, one table (shops table) gives details of outlets of companies associated with the website . Shop id is there product ID also there.
The next table (products table), there are different numbers of different products of each shop. Product ID is there in the second table, but no shop ID.
We need to get the number of each product under each shop in the website using single query
Max 500 Rs