Please use Big Query public NCAA basketball dataset (bigquery-public-data.ncaa_basketball) and write code in SQL

Hexadecimal colors codes are a way of representing color on a computer. Hex color codes are of form \#AABBCC, where AA,BB, and CC are hexadecimal numbers (00,01,,FE,FF) indicating the intensity of red, green, and blue in the color, respectively. Hint: be careful with the case of the colors in the dataset -- some use lower case characters and some use upper case characters. Note that in the expected answer below, the original case from the dataset is kept. What teams have the maximum possible red intensity in their color? Give (team market, color) as your answer. Order your results alphabetically by the team market