Create a composite index named "idx$\_$batting$\_$bowling" on the "CricketPlayer" table for the "batting$\_$average" and "bowling$\_$average" columns. Retrieve the player$\_$name, batting$\_$style, and bowling$\_$style of players with a batting$\_$average greater than $30$ and a bowling$\_$average less than $50$ from the "CricketPlayer" table using the composite index "idx$\_$batting$\_$bowling".

Tables Schema as Below:

CricketPlayer

columnName dataType

player$\_$id INTEGER

player$\_$name TEXT

country TEXT

batting$\_$style TEXT

bowling$\_$style TEXT

matches$\_$played INTEGER

runs$\_$scored INTEGER

wickets$\_$taken INTEGER

batting$\_$average DECIMAL$(5,2)$

bowling$\_$average DECIMAL$(5,2)$

Team

columnName dataType

team$\_$id INTEGER

team$\_$name TEXT

country TEXT

coach TEXT

captain TEXT

player$\_$id INTEGER