Please solve these and provide text( mysql) Create a store procedure and from the following tables (player_mast, soccer_

[answerhappygod]

Please solve these and provide text( mysql)
Create a store procedure and from the following tables
(player_mast, soccer_country,
match_details), write a SQL query (joins) to find those players,
who contracted to ‘Lyon’ club
and participated in the EURO cup 2016 Finals. Return player name,
jerseyno, position to play,
age, country name.
10. Create a store procedure and From the following tables
(soccer_country, match_captain,
player_mast), write a SQL query (joins) to find the captains of the
top four teams that
participated in the semi-finals (match 48 and 49) in the
tournament. Return country name,
player name, jersey number and position to play.