Write a query that lists ids and scores of all scores for which the next score a

Question

Write a query that lists ids and scores of all scores for which the next score above them (if any) is at least 10 points higher. The highest score in the entire table also qualifies per this rule. E.g, if a score is 70, and the next higher score is 80, or 81, then the 70 score qualifies, and you should list it.

Perform the indicated query using subqueries Use at most 300 characters. Use left at most 0 times. Use right at most 0 times. Use full at most 0 times.

create table Score (
id int primary key auto_increment,
score int
);

id score 1 30 2 20 3 25 4 39 5 40 6 50 7 52 8 18 9 8 10 20 11 30 12 60

Explanation / Answer

CREATE TABLE scores

    (

         id int primary key auto_increment,

         score int increment,

         primary key (id),

         key score (score)

    );

so, here is the Query that lists ids and scores of all next scores

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.