 Hello welcome to SS Unit X, so April he decide today we are going to start a new playlist where will be same about top 50 interview tapped, and here these questions are coming as a squeak likewise, so this is the day 1 where we are going to discuss one very common same interview question going forward we will be same all these questions 1x1 like in day one we have this question in a day 2 you will be also same, very interesting So, supporters like this video do subscribe our channel for your support always motivate me to record more and more videos. So, let's get started with today's video. So, here as we could see we have one of the input table that is having a single column that is the group A. And here we could see it is having total four roles like India, Australia, Pakistan and Afghanistan. So, the requirement is we just wanna do the group wise matches for each team. So, here we could see India should play with Australia, India should play with Pakistan, India should play with Afghanistan. Along with that Australia should play with Pakistan, Australia should play with Afghanistan. On the same line Pakistan should play with Afghanistan. So, that's why we can see in the output we have India versus Australia, India versus Pakistan, India versus Afghanistan. Australia versus Pakistan, Australia versus Afghanistan and Pakistan versus Afghanistan. So, how we can write this equal query for getting this output. So, let's go to the sequence over and we will try to see in practical. So, here I am going to create one of the table and that table will be having these four countries. So, let me try to execute this script for creating the table and inserting the data into this table. Now, let me try to select this table and we will verify the data. So, here we could see we have the same data that we have seen in slide. Now, the requirement we need to do the matches between these teams. So, how we can do that? So, for that we can simply go and try to use the self-drain on the same table. So, this self-drain will be going to do the matches between these teams. So, I am calling the first table as A and second table as B. What we will be writing in on clause. So, this is very simple. What you have to do? You have to only do A dot teams. Should be less than B dot teams. How it will work? Let me tell you later. But let me execute and we will see the output. So, here we could see we have total six rows and Australia is going to play with India. Afghanistan is going to play with India and then India is going to play with Pakistan. So, India is playing with all these three teams. Similarly, Australia we can see playing with India. Australia is playing with Pakistan and Australia is playing with Afghanistan. So, all the matches will be happening between these two teams. And for the verses we can simply use the A dot teams and after that we can concatenate with verses and then we can simply use the B dot team. Let me try to execute. So, we will see the proper output. So, this is the output what we are expecting. But how it is working? So, here we are simply using the less than. So, how this less than is working in real time. So, behind the scene it will be picking the askies value for each characters. So, for example if we are having India. So, we have India like I first. So, it will be taking the I and whatever the askie value we have here we can simply copy. This is the askie value for I. Similarly, we can go and check the askie value for N. So, this is the N. So, we can simply copy it and let me try to plus with this. And at last we have D. So, let me try to execute and we will get the askie value for D. So, this will be the complete askie value for India. And similarly it will be also getting the askie values for other countries. So, on that basis it will be going to check this less than and it is working. So, this is what you can explain to the interviewer. Thanks for watching this video. See you in the next video with a new sequel quiz.