我正在尝试为超级碗表创建数据,我想用SQL创建一个表,用两列显示每个团队的获胜次数,即获胜次数和团队次数。我需要使用CASE。我希望有人能教我这一点,因为我是一个业余爱好者,刚刚开始编码我向你保证这不是SPAM,这是从第1届到第54届的超级碗名单,我不是BOT这就是我目前所拥有的:
/* Put your data in here and query it! */
CREATE TABLE superbowls(
Date TEXT ,
SB TEXT,
Winner TEXT,
Winner_Pts INTEGER,
Loser TEXT,
Loser_Pts INTEGER,
MVP TEXT,
Stadium TEXT,
City TEXT,
State TEXT
);
/* https://justpaste.it/99c41 */
select * from superbowls where winner_pts > 10 and loser_pts< 10;
可能是这样的吗?
create table YourNewTable as
select
Winner as Team,
count(*) as Wins
from superbowls
group by Winner