SQL Interview Questions and answers Part 11 | SQL Scenario based Interview Question and Answer

SQL Interview Questions and answers Part 11 🔥🔥 This question is basically scenario based SQL interview question which has been asked in multiple companies. Input :- Table Match_Result has three columns namely Team_1, Team_2 and Result. Problem Statements :- Write SQL to display total number of matches played, matches won, matches tied and matches lost for each team ------------------------------------------------------------------------- 𝗝𝗼𝗶𝗻 𝗺𝗲 𝗼𝗻 𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮:🔥 ------------------------------------------------------------------------- 🔴 Instagram : https://www.instagram.com/itjunction4all/ 🔴 Twitter: https://twitter.com/sunilkr5672 ------------------------------------------------------------------------- 🔴 Table and Insert SQL Script : ------------------------------------------------------------------------- Create Table Match_Result ( Team_1 Varchar(20), Team_2 Varchar(20), Result Varchar(20) ) Insert into Match_Result Values('India', 'Australia','India'); Insert into Match_Result Values('India', 'England','England'); Insert into Match_Result Values('SouthAfrica', 'India','India'); Insert into Match_Result Values('Australia', 'England',NULL); Insert into Match_Result Values('England', 'SouthAfrica','SouthAfrica'); Insert into Match_Result Values('Australia', 'India','Australia'); #SQLInterviewQuestionsandanswers #sqlInterviewQuestions #SQLQuestions#SQLInterviewQuestionsandanswers#sqlInterviewQuestionsForTesting #sqlQuery #sqlInterviewQuestionsOnJoins #SQL