movies isdeleted example

CREATE table MOVIES
(
    MOVIE_ID int NOT NULL primary key,
    MOVIE_TITLE varchar(20) NOT NULL,
    ISDELETED bit NOT NULL
 )

insert into MOVIES values
 (10, 'Pizza Party 2', 8),
 (2, 'Ratatouille', 0),
 (3, 'Totoro', 1),
 (4, 'Cinderella', 0),
 (5, 'Avatar', 1),
 (6, 'Lion King', 0)

select * from MOVIES

update MOVIES
set ISDELETED = 1
where MOVIE_ID = 4