SQL_1

Question 1

Assuming there is a table: create table player (id int, team varchar, goals int), which query will show the total amount of goals per team?

Answer 1

✅ select team, sum(goals) from player GROUP BU team;

Question 2

What SQL statement is used to change values in the database
update
change
replace
edit

Answer 2

✅ UPDATE