I need MYSQL query

need code and output for it

b)Given a industry, how many companies are covered, the average number of analysts, the average bias between the Estimize Consensus and the Reported Earnings?

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

and there is dataset which is like this

• Like this example i. name: Steven Halper
• ii. roles: Financial Professional, Sell Side, and Broker iii. Join Date: Jan 2017 iv. Analyst Confidence Score: 5.4 v. error rate: 17.3% vi. Accuracy Percentile: 24% vii. points: 16 viii. points/Estimate: 1 ix. stocks: 20 x. pending: 28