使用Mysql打印板球比赛的积分表

CREATE TABLE scoreboard (
  team_name VARCHAR(50) NOT NULL,
  matches_played INT DEFAULT 0,
  matches_won INT DEFAULT 0,
  matches_lost INT DEFAULT 0,
  matches_tied INT DEFAULT 0,
  total_points INT DEFAULT 0,
  PRIMARY KEY (team_name)
);

INSERT INTO scoreboard (team_name, matches_played, matches_won, matches_lost, matches_tied, total_points)
VALUES
('Team A', 5, 3, 1, 1, 7),
('Team B', 5, 2, 2, 1, 5),
('Team C', 5, 1, 3, 1, 3),
('Team D', 5, 1, 3, 1, 3);

SELECT * FROM scoreboard ORDER BY total_points DESC;