For this question you need to look at the orderdetails table to get the subtotal and quantity of purchases to determine the revenue of a given order. You also need to link this to a specific game, group by games of the same ID, and make sure you're only looking at action games via genres table. Make sure to submit the 5th one.

SELECT SUM(od.quantity \* od.subtotal) AS total_revenue
FROM Orders o
INNER JOIN OrderDetails od ON o.order_id = od.order_id
INNER JOIN Games g ON od.game_id = g.game_id
INNER JOIN Genres gn ON g.genre_id = gn.genre_id
WHERE gn.genre_name = 'Action'
AND YEAR(o.order_date) = 2023
GROUP BY g.game_id
ORDER BY total_revenue DESC
LIMIT 5;

flag is texsaw{247.16}