Seagul

Lesson 3 - Books with 4 characters then Java

Dataset statusEasy SQL exercisesvv1

Exercise content

Using the books table, find all books where book_name starts with a 4-character word, followed by a space, the word Java, and another space.

Return the columns:

book_id
book_name

Order the result by book_id.

Hints

Hint 1

In LIKE, the _ character stands for exactly one character. Here you need 4 of them before Java.

Not completed

Loading dataset...

Latest result

No result set available.