Search Header Logo

Let's practice! - String

Authored by Thuan Tran

Specialty

University

Let's practice! - String
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

5 questions

Show all answers

1.

FILL IN THE BLANK QUESTION

1 min • 1 pt

Retrieve the length of the description column, returning the results as description_length.

SELECT ........... (...........) AS ........... FROM grid;

2.

FILL IN THE BLANK QUESTION

1 min • 1 pt

  • Retrieve the first 25 characters from the description column in the grid table. Name the results first_25_left.

SELECT ...........(...........,...........) AS ........... FROM grid;

3.

FILL IN THE BLANK QUESTION

1 min • 1 pt

  • Amend the query to retrieve the last 25 characters from the description. Name the results last_25_right.

SELECT LEFT(description, 20) AS ........... FROM grid;

4.

FILL IN THE BLANK QUESTION

1 min • 1 pt

  • Edit the query to return the CHARINDEX of the string 'Weather' whenever it appears within the description column.

SELECT description, ..........('..........', description) FROM grid

WHERE description LIKE '%Weather%';

5.

FILL IN THE BLANK QUESTION

1 min • 1 pt

  • Fill in the blank

  • Complete the substring function to begin extracting from the correct character in the description column.

SELECT description, CHARINDEX('Weather', description) AS start_of_string,

LEN ('Weather') AS length_of_string,

SUBSTRING(______,______,______) AS additional_description

FROM grid

WHERE description LIKE '%Weather%';

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?