Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

12. List only the first word in the title of a movie. You may assume a word ends in a space or the end of

image text in transcribed
image text in transcribed
12. List only the first word in the title of a movie. You may assume a word ends in a space or the end of the title (count Surfs as one word). Use an alias to name the result set column "First Word in Title". Hint: There is a function that gets all characters up until a given character (such as a space). Take a screenshot now and paste it here. 13. List only the first word in the title of a movie, just as above, but this time display the first word in all caps (uppercase). Use an alias to name the result set column "First Word". Hint: You can nest functions: SELECT UPPER (IEFT (title, 3)) EROM ... (just an example, not the answer...). Take a screenshot now and paste it here. 14. List the title and year of all movies, but for the years, display only the last 2 digits in the year. For example, 1999 will be displayed as 99, 2010 will be displayed as 10, and so on. Hint: You can apply a

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Data Science For Dummies

Authors: Lillian Pierson ,Jake Porway

2nd Edition

1119327636, 978-1119327639

More Books

Students also viewed these Databases questions