Write sql statements to implement return player annas grade

Assignment Help PL-SQL Programming

Reference no: EM131564358

Problem 1: Please write SQL statements to implement the following tasks.

You can ONLY use conditions listed in each task. You cannot add or change conditions by manually looking up data. E.g., if we look for a player named Anna, you cannot manually look up her pid.

Task 1: Return Player Anna's grade and rating.

Task 2: Return names of all elementary school players with rating over 1000.

Task 3: Return number of players registered for Baltimore January Action

Task 4: Return the name and rating of players who have registered for the Intermediate section of Baltimore January Action.

Task 5: Return the tournament name and number of players registered for each tournament.

Task 6: Return the name of tournament with at least 5 registered players

Task 7: Return the pairing information for the first round of Baltimore January Action.

Please include board ID, white player's name, white player's rating, black player's name, black player's rating

Task 8: Return the section name and average rating of players registered for each section in 'Baltimore January Action'

Problem 2: Please write a PL/SQL program to compute the sum of 1³, 2³, 3³, ..., 10³. Here i³ means cube of i (e.g., 2³ = 8).

Attachment:- SQL-Assignment.rar

Reference no: EM131564358

Questions Cloud

Express the portion of spherical and cylindrical coordinates : Consider the surfaces S1 : x^2 + y^2 + z^2 = 25 and S2 : x^2 + y^2 = 16.

Balanced budget amendment to the constitution : From time to time our policy makers introduce 'balanced budget amendment to the constitution'. The last attempt failed in 2011 but the Senate.

Write a debate on ban on any bags : neg no ban on any bags, single -use plastic bags all shopping

Find daily contribution margin of non-private pay resident : If 25 percent of the residents are non-private pay, what will shady Rest charge the private pay patients in order to break even?

Write sql statements to implement return player annas grade : Write SQL statements to implement Return Player Anna's grade and rating. Return names of all elementary school players with rating over 1000.

Insurance market from working perfectly : What benefit people get from the market for insurance. What two problems impede the insurance market from working perfectly?

Design a low-pass filter of order : Write a suitable matlab program with comments to indicate the logic used and generate the discrete plot - Design a low-pass filter of order

What is the status of the net float : A firm has $16,718 in outstanding checks that have not cleared the bank. What is the status of the net float.

What is the contractual mttf : There is a contractual requirement to demonstrate with 90% confidence that a vehicle can achieve a 100 KM mission with a reliability of 99%.

User Account

All Pages