1.先找到sampledatabase.sbl_team_data where team_id = 5;

SELECT * FROM sampledatabase.sbl_team_data where team_id = 5;

#平均贏多少場使用AVG

SELECT  avg(win) FROM sampledatabase.sbl_team_data where team_id = 5;

#總共撈出幾筆資料count

SELECT  count(*) FROM sampledatabase.sbl_team_data where team_id = 5;

#使用max抓出欄位最大值,min抓出最小值

SELECT  max(win) FROM sampledatabase.sbl_team_data where team_id = 5;

SELECT  min(win) FROM sampledatabase.sbl_team_data where team_id = 5;

#總共贏多少場用sum

SELECT  sum(win) FROM sampledatabase.sbl_team_data where team_id = 5;

#使用concat將兩欄數值加起來(這邊加總win+lost)