You've been tasked with identifying the top $5$ products that generated the highest total revenue during the first half of $2022,$ specifically from January to June. You aim to find these products and report their product IDs and total revenues.

Order the results in descending order of Total revenue.

Total$\_$revenue for each product is a sum of $($cost $*$ unit$\_$solds$).$

Tables Schema as Below:

product$\_$sales

columnName dataType

product$\_$id INT

promotion$\_$id INT

cost$\_$in$\_$dollars INT

customer$\_$id INT

date DATE

units$\_$sold INT