Iqigai| OA | 18th march 2026 | Valorant Match Data | Top Movies by Genre | SQL JOINs & Window Functions

Question 1: Valorant Match Data (SQL JOINs) Problem Statement: Write a query to fetch the MatchID, Date, Team1, Team2, and Map from the 'Matches' table joined with the 'Games' table for all matches played on the 'Breeze' map. Note: In the sample tables below, column names include data types in parentheses (e.g., 'id (INTEGER)'), but the actual column name is only 'id'. Table Information: Table: Matches Contains match details, including event information, teams, date, and map scores. Column Name Data ...