### Database Development and Management#### Section 3.1: Special Operators and Clauses---### 3.1.4: Select Movie Titles with LIKE**Participation Activity**The given SQL creates a Movie table and inserts some movies. The `SELECT` statement selects all movies. Modify the `SELECT` statement to select movies with the word 'star' somewhere in the title.**Objective:**- Modify the `SELECT` statement to filter movies that have 'star' in their title.- Run your solution and verify the result table shows just the movies "Rogue One: A Star Wars Story", "Star Trek" and "Stargate".**SQL Code:**```sql1 CREATE TABLE Movie (2 ID INT AUTO_INCREMENT,3 Title VARCHAR(100),4 Rating CHAR(5) CHECK (Rating IN ('G', 'PG', 'PG-13', 'R')),5 ReleaseDate DATE,6 PRIMARY KEY (ID)7 );8 9 INSERT INTO Movie (Title, Rating, ReleaseDate) VALUES10 ('Rogue One: A Star Wars Story', 'PG-13', '2016-12-16'),11 ('Star Trek', 'PG-13', '2009-05-08'),12 ('The Dark Knight', 'PG-13', '2008-07-18'),13 ('Stargate', 'PG-13', '1994-10-28'),14 ('Avengers: Endgame', 'PG-13', '2019-04-26');15 16 -- Modify the SELECT statement:17 SELECT18 *19 FROM Movie;```**Instructions:**1. **Create the Movie Table:** The script starts with creating a table named `Movie` with columns `ID`, `Title`, `Rating`, and `ReleaseDate`.2. **Insert Movies:** It then inserts five movies into the table.3. **Modify the SELECT Statement:** You need to modify the `SELECT` statement to filter the movies where the title contains the word 'star'.4. **Run and Verify:** Execute the script and verify the output.#### Steps to Modify the SELECT Statement:1. To filter movie titles that contain the word 'star', use the `LIKE` operator.2. The modified `SELECT` statement should look like this:```sqlSELECT *FROM Movie

Answered: Image /qna-images/answer/f491b95e-cae8-4aba-84db-1b9195155647.jpg

The given SQL creates a Movie table and inserts some movies. The SELECT statement selects all movies. Modify the SELECT statement to select movies with the word 'star' somewhere in the title. Run your solution and verify the result table shows just the movies Rogue One: A Star Wars Story, Star Trek and Stargate.

The given SQL creates a Movie table and inserts some movies. The SELECT statement selects all movies. Modify the SELECT statement to select movies with the word 'star' somewhere in the title. Run your solution and verify the result table shows just the movies Rogue One: A Star Wars Story, Star Trek and Stargate.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Correct and detailed answer is must for Upvote. Thank you!
Trying to write SQL statements for these shown here and having issues with them working. Explanation on this would be appreciated.
CREATE TABLE Employee( firstName char(30) , lastName char(30) , hireDate date ,empNo int , empInitial char(30) , years int ); Write the SQL syntax to create an insert statement for the employee table you created above.
Create a function to insert a new product into an existing order, include the product id, unit price, quantity. The output of the function is the message to notify the calling program whether the update succeeded or not. note : Note: Sql code need not java don't waste my time by giving java code
Write a SQL command please Write a query that displays the last name in uppercase letters and the length of the last name for all employees whose last name starts with the letters “J,” “A,” or “M.” Give each column an appropriate label. Sort the results by the employees’ last names.
Write a query in SQL to display all the data of customers, in Table customers, that live in New York or California SELECT city FROM customers WHERE city = 'New York' OR city = 'California' SELECT * FROM customers WHERE city = 'New York' AND city = 'California' SELECT * FROM customers WHERE city = 'New York' OR city = 'California' SELECT ALL FROM customers WHERE city = 'New York' OR city = 'California' %3D
SQL ( ORACLE SQL DEVELOPER ) : THIS IS FIRST , SECOND AND THIRD TABLE for the Task 1 to solve : create table author_45( auth_name char(50), gender char(1), age number(3), nationality char(50), PRIMARY KEY (auth_name) ); create table book_45( isbn number(10), title char(50), ver_no number(2), publisher char(50), PRIMARY KEY (isbn) ); create table writtenBy_45( isbn number(10), auth_name char(50), yr_published number(4), price number(3), no_copy number(4), PRIMARY KEY (isbn,auth_name), foreign key (isbn) references book_45, foreign key (auth_name) references author_45 ); insert into author_45 values ('Benoit','F',42,'French'); insert into author_ 45 values ('Antonini','M',33,'Italian'); insert into author_ 45 values ('McAven','F',31,'Australian'); insert into author_ 45 values ('Williams','M',90,'British'); insert into book_45 values (101,'atabases',1,'Possum'); insert into book_45 values (202,'SQL Primer',2,'Hall'); insert into book_45 values…
This is a Database based question.
Write SQL code Create a table using the statement below. create table odd (number int primary key); Then create a stored procedure “insertOdd” to insert odd numbers in the range of [1, 20] into the table “odd”. Number 5 and 15 are skipped. Below is a statement to test your stored procedure. call insertOdd();
In SQL, write the appropriate statements to insert default values for these two tables, each table containing 5 inserts
The given SQL creates a Song table and inserts some songs. The first SELECT statement selects songs released after 1992. The second SELECT statement selects the release year for song with ID 800. Create a third query that combines the two existing queries. The first SELECT should be the outer query, and the second SELECT should be the subquery. The ORDER BY clause should appear after the subquery. Run your solution and verify the new query returns a result table with five rows, all with release years after 1992. CREATE TABLE Song (ID INT,Title VARCHAR(60),Artist VARCHAR(60),ReleaseYear INT,Genre VARCHAR(20),PRIMARY KEY (ID)); INSERT INTO Song VALUES(100, 'Hey Jude', 'Beatles', 1968, 'pop rock'),(200, 'You Belong With Me', 'Taylor Swift', 2008, 'country pop'),(300, 'You\'re Still the One', 'Shania Twain', 1998, 'country pop'),(400, 'Need You Now', 'Lady Antebellum', 2011, 'country pop'),(500, 'You\'ve Lost That Lovin\' Feeling', 'The Righteous Brothers', 1964, 'R&B'),(600, 'That\'s…
The given SQL creates a Movie table and inserts some movies. The SELECT statement selects all movies. Modify the SELECT statement to select movies with the word 'star' somewhere in the title. Run your solution and verify the result table shows just the movies Rogue One: A Star Wars Story, Star Trek and Stargate. CREATE TABLE Movie ( ID INT AUTO_INCREMENT, Title VARCHAR(100), Rating CHAR(5) CHECK (Rating IN ('G', 'PG', 'PG-13', 'R')), ReleaseDate DATE, PRIMARY KEY (ID)); INSERT INTO Movie (Title, Rating, ReleaseDate) VALUES ('Rogue One: A Star Wars Story', 'PG-13', '2016-12-16'), ('Star Trek', 'PG-13', '2009-05-08'), ('The Dark Knight', 'PG-13', '2008-07-18'), ('Stargate', 'PG-13', '1994-10-28'), ('Avengers: Endgame', 'PG-13', '2019-04-26'); -- Modify the SELECT statement:SELECT *FROM Movie;