Chapter 2, Problem 9EYK

I need help with the select statement using a self-join that returns the output below, without using a literal value to filter the results.

Can you please specify what you named the items in the form so we can tell how it is used in connection with the code?

What wouldbe the correct solution based on the given prompt? Such as how is my solution incorrect, in addition to that?

What is the correct line of code for this challenge?

is there any other way to do it without changing the create table instances and just do everything under this part? SELECT * FROM "arena"WHERE "people_count" >=100ORDER By "event_date" ASC

Note the multiple choice for 37 options are in the picture since this is a long question! Please show work and explanation of how you got the answer! Not an graded assignment!

Implement the "Update player rating" menu option. Prompt the user for a player's jersey number. Prompt again for a new rating for the player, and then change that player's rating. Ex: Enter a jersey number: 23 Enter a new rating for player: 6

Explain the three R commands such as plot(), lines(), and fitted() and explain what each command does.

When using Scenarios, how many cells can be specified as “changing”?  How many cells can be specified as “result”?  Should a “changing” cell contain a constant or a formula?  Should a “result” cell contain a constant or a formula?   In excel