Write a query that will display all movies with a return date of March 1, 2018, March 5, 2018, March 15, 2018, March 17, 2018 or March 25, 2018. Note: Do not use the OR operator for this query.
Write a query that will display all movies with a return date of March 1, 2018, March 5, 2018, March 15, 2018, March 17, 2018 or March 25, 2018. Note: Do not use the OR operator for this query.
![](/static/compass_v2/shared-icons/check-mark.png)
Sql query to display all the movies with a return date of March 1, 2018, March 5, 2018, March 15, 2018, March 17, 2018 or March 25, 2018. Write the query without OR operator.
Create table query:
create table Movies(movieTitle varchar(10), movieYear int, movieReturnDate Date);
Insert some data in the table Movies using the insert query:
insert into Movies values('abc', 2018 ,'March 1, 2018');
insert into Movies values('cde', 2018 ,'March 3, 2018');
insert into Movies values('efg', 2018 ,'March 5, 2018');
insert into Movies values('ghi', 2018 ,'March 12, 2018');
insert into Movies values('ijk', 2018 ,'March 15, 2018');
insert into Movies values('jkl', 2018 ,'March 16, 2018');
insert into Movies values('lmn', 2018 ,'March 17, 2018');
insert into Movies values('mno', 2018 ,'March 19, 2018');
insert into Movies values('pqr', 2018 ,'March 21, 2018');
insert into Movies values('xyz', 2018 ,'March 25, 2018');
show the data stored in the Movie table using the select query:
select *
from Movies;
Step by step
Solved in 3 steps with 2 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
![Starting Out with Python (4th Edition)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
![Starting Out with Python (4th Edition)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
![C How to Program (8th Edition)](https://www.bartleby.com/isbn_cover_images/9780133976892/9780133976892_smallCoverImage.gif)
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781337627900/9781337627900_smallCoverImage.gif)
![Programmable Logic Controllers](https://www.bartleby.com/isbn_cover_images/9780073373843/9780073373843_smallCoverImage.gif)