Data Programming

Complete following tasks. Use Notepad or Notepad++ to save the code and include it in your submission. Must submit two files. A script file and a spool file. [login to view URL] a SELECT statement to display all teams, match id, game numbers that they won, and bowlers’ name in the team. Include all teams even teams do not have a winning match. Sort the results by team id in descending order, match id, and game number in ascending order. Use proper column headings. Examples given in attached photo. [login to view URL] a SELECT statement that displays the bowlers, the matches they played in, and the bowler games scores. Include the bowlers only with the raw score higher than 190. Use proper column headings. Examples given in attached photo.