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_revenueFROM Orders oINNER JOIN OrderDetails od ON o.order_id = od.order_idINNER JOIN Games g ON od.game_id = g.game_idINNER JOIN Genres gn ON g.genre_id = gn.genre_idWHERE gn.genre_name = 'Action'AND YEAR(o.order_date) = 2023GROUP BY g.game_idORDER BY total_revenue DESCLIMIT 5;
flag is texsaw{247.16}