Create a view mumbai_staff listing emp_id and first_name of employees whose city is Mumbai. Then move employee 8 (Rohan Das) to Mumbai. The view must show him without being recreated.
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)
Solution
Unlocks after you solve it or after 3 submissions
SQL (DuckDB)
Ctrl + Enter to runLog in to save progress and earn XP