Update several columns — SQL practice · JobPrax

Practice
Live projects
Guided projects
For colleges
Pricing

Log in Start free

INSERT, UPDATE & DELETE

SQLBasic

Update several columns

PreviousProblem 7 of 40Next

Employee 20 (Manoj Tiwari) finished the internship. Change his job_title to Developer and salary to 70000 in one statement.

Tables

departments

dept_idinteger
dept_namevarchar
locationvarchar

emp_projects

emp_idinteger
project_idinteger
rolevarchar
hours_per_weekinteger

employees

emp_idinteger
first_namevarchar
last_namevarchar
emailvarchar
dept_idinteger
manager_idinteger
job_titlevarchar
salaryinteger
hire_datedate
cityvarchar
gendervarchar

projects

project_idinteger
project_namevarchar
dept_idinteger
budgetinteger
start_datedate
end_datedate

Hints(0/2)

Each hint gives a little more help. Try on your own first.

Solution

Unlocks after you solve it or after 3 submissions

SQLCtrl + Enter to run

Log in to save progress and earn XP

Run your code to see the output here.