IniziaInizia gratis

Matching text

You've been asked to help test out a new search feature. You'll need to check whether the system can correctly handle searches where users type only part of an actors name. As part of this test, you decide to look for all actors whose names have the letter “e” in the third position.

You need to pull this list from the database to confirm the search behaves as expected.

Questo esercizio fa parte del corso

Intermediate SQL with AI

Visualizza il corso

Istruzioni dell'esercizio

  • Write a prompt that retrieves all people where the third letter of the name is “e”.

Esercizio pratico interattivo

Passa dalla teoria alla pratica con uno dei nostri esercizi interattivi

Inizia esercizio