0 0 votes Databases sql databases + – Shivani gaikawad 1.1k views answer comment Share Follow Print See all 5 Comments 5 5 Comments reply Shivani gaikawad commented Nov 3, 2018 reply Follow flag can anyone explain these query 0 0 replyShare anjali007 commented Nov 3, 2018 reply Follow flag I guess the ans should be a.. because the given query satisfies the condition in a most efficient manner.We are summing up the total sales made by selling tomato sauce within the stipulated time period. So the condition is the same in all and I think inner join is the most efficient for this case as only the required data is being considered. 0 0 replyShare Sayan Bose commented Nov 3, 2018 reply Follow flag You didn't explain why inner join ? 0 0 replyShare Shaik Masthan commented Nov 3, 2018 reply Follow flag without using Grocery table, how the options use those attributes belongs to the table ? 2 2 replyShare Swapnil Naik commented Nov 3, 2018 reply Follow flag Exactly! 0 0 replyShare Please log in or register to add a comment.