please follow the instructions line by line. make sure you know SQL, if you don't know the SQL plz don't try to answer i

[answerhappygod]

please follow the instructions line by line. make sure you knowSQL, if you don't know the SQL plz don't try to answer it, makesure you provide the code and screenshot and the output aswell.

Please Follow The Instructions Line By Line Make Sure You Know Sql If You Don T Know The Sql Plz Don T Try To Answer I 1 (59.9 KiB) Viewed 33 times

Please Follow The Instructions Line By Line Make Sure You Know Sql If You Don T Know The Sql Plz Don T Try To Answer I 2 (32.16 KiB) Viewed 33 times

Table Name: PLAYER playerid P101 P102 P103 P104 P105 P106 P107 P108 mid M101 M102 M103 M104 M105 Table Name: MATCH M106 M107 M108 M109 pname stanislas Stefan Mark tid T101 T102 T103 T104 T105 T106 T107 Wilander Emerson Murray Becker Nadal tid T101 T101 T101 T105 T105 T102 T102 T106 T107 tname TPL TPL-2 ISTL-16 ISTL-17 AITT ISTL-18 AITT-2 teamname Table Name: TOURNAMENT RE RW RN RS RE RW RN RS Player1 P101 P102 P103 P103 P105 P101 P102 P103 P102 startdt 42644 42852 42463 42915 41402 43280 42768 Player2 P102 P103 P104 P105 P102 contactno rank 7890556732 7 8456877431 3 7678290217 1 9431577890 5 9986656799 10 8456877432 4 768290216 9431577892 2 P102 P103 P107 P108 42402 42409 matchdt winner 42644 P102 42668 P102 42665 42852 42860 42287 42773 enddt 42668 42860 62 42474 42923 42409 43288 42775 6 P103 P105 P105 P102 P102 P107 P102 winnerprize 90 80 70 50 80 50 80
Question:3 Identify the matches won by the winners with ranking more than 6. Display mid and pname of the winner for the identified matches. For the given sample data, the following record will feature as part of the output along with other record(s). Question:4 Identify the teamname(s) with 2 or more players of ranking more than 5. Display teamname and number of such players as "PLAYERS" (column alias) for the identified teamname(s). For the given sample data Question:5 Identify the tournaments having more than 3 characters in the tournament name and same winner prize amount. Display tid and tame for the identified tournaments. For the given sample data, the following records will feature as part of the output along with other record(s).