22 hours ago

Sarthak • 10

Hyderabad

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.

(Note: TheGamestable schema is implied to contain theMap,Team1, andTeam2columns based on the query requirements).

Question 2: Top Movies by Genre (Window Functions)

Problem Statement:

Write a SQL query to find the top three movies with the highest domestic earnings for each genre. The result should include the genre, movie title, and domestic earnings.

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:earnings

Records earnings for movies, including domestic and worldwide revenue.

(Note: Amoviesorgenrestable is implied to exist to join theMovie_idwith the actual movie title and genre).