I need MYSQL query

need code and output for it

b)Given a ticker, how many analysts have made estimations for its EPS? Rank them by their confidence score, total points, error rate or accuracy percentile?

BELOW IS A DATASET links

four quarters EPS information

https://1drv.ms/x/s!AsX4xuU9Gr0ogQoA9gWTU_73snAJ

company basic information

https://1drv.ms/x/s!AsX4xuU9Gr0ogQzXA8oCMv2qaC0-

AVAILABLE analysts information

https://1drv.ms/x/s!AsX4xuU9Gr0ogQhI4exsr4Bod-_Z

analysts data

https://1drv.ms/x/s!AsX4xuU9Gr0ogRLSiBQc0-fi4hoa