SQL Select Data and Order By In this question, you are going to select some data

Question

SQL Select Data and Order By In this question, you are going to select some data rows from a table with a certain order Data from Big Ten Statistics is contained in a table offenseScore Here is the table with all its records FG 2 4 10 21 18 16 12 12 18 id name 1 2 Ohio State XPT XP2 POINTS 53 62 58 62 52 50 56 6 Michigan State 55 475 464 425 408 433 417 325 348 301 296 Indiana Nebraska 4 6 49 51 35 42 38 4 Michigan Iowa 1 Rutgers Wisconsin Purdue 41 1 10 Maryland 38 Note: HackerRank doesn't support SQLite, but the syntax for MySQL is identical for this question. You are going to use an SQL query to select the columns id, name and POINTS from this table and and print them in descending order of points

Explanation / Answer

select id,name, points from offenseScore ORDER BY POINTS DESC;

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

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