Problem: Write a SQL Query to swap the employeee department
drop table if EXISTS employee;
create table employee(id int identity,name varchar(15),department varchar(15));
insert into employee values('John','Sales')
insert into employee values('Tom','IT')
insert into employee values('Rohit','IT')
insert into employee values('shubham','Marketing')
insert into employee values('kavya','Management')
insert into employee values('Rohan','Sales')
insert into employee values('Shivani','IT')
select * from employee;
