For each match, a score is get as input from the player and credits are given based on the following criteria.ScoreCredits<1001100 to 1502150 to 2003200 to 2504Only for the ‘Game 2’ get the  mail id too. If the mail id is having any ‘(  ‘ symbol remove it and format the mail id and print the formatted mail id.

A person wants to play online games. Get the number of times he needs to play the game. Permit him to play the game till the count is exceeded. Two types of games can be played namely ‘Game 1’ and ‘Game 2’. Create a base class ‘Game’. From class, ‘Game’, two classes ‘Game 1’ and ‘Game 2’ can be derived. Each time the player plays the game a unique integer id is created for each match. Get the details like name, phone number, score obtained for both games. Find the credit obtained and display it along with the report.  For each match, a score is get as input from the player and credits are given based on the following criteria.ScoreCredits<1001100 to 1502150 to 2003200 to 2504Only for the ‘Game 2’ get the  mail id too. If the mail id is having any ‘(  ‘ symbol remove it and format the mail id and print the formatted mail id.

Given the participants' score sheet for your University Sports Day, you are required to find the runner-up score. You are given scores. Store them in a list and find the score of the runner-up.Input FormatThe first line contains . The second line contains an array of integers each separated by a space.

Write a program that asks for the name and number of points scored by two basketball players.

Rank ScoresWrite a SQL query to rank scores. If there is a tie between two scores, both should have the same ranking. Note that after a tie, the next ranking number should be the next consecutive integer value. In other words, there should be no "holes" between ranks.IdScore13.5023.6534.0043.8554.0063.65For example, given the above Scores table, your query should generate the following report (order by highest score):ScoreRank4.0014.0013.8523.6533.6533.504Optionsselect Score over(order by Score desc) to Rank from Scores;select Score, dense_rank() as Rank from Scores;select Score, dense_rank() over(order by Score desc)select Score, dense_rank() over(order by Score desc) as Rank from Scores;

Write a SQL query to rank scores. If there is a tie between two scores, both should have the same ranking. Note that after a tie, the next ranking number should be the next consecutive integer value. In other words, there should be no "holes" between ranks.IdScore13.5023.6534.0043.8554.0063.65For example, given the above Scores table, your query should generate the following report (order by highest score):ScoreRank4.0014.0013.8523.6533.6533.504Optionsselect Score, dense_rank() as Rank from Scores;select Score, dense_rank() over(order by Score desc)select Score, dense_rank() over(order by Score desc) as Rank from Scores;select Score over(order by Score desc) to Rank from Scores;