LoslegenKostenlos loslegen

Comparison keywords

In this exercise, you will do some more advanced filtering. The sales support department received a call from a customer asking for some more information about the Queen repertoire. Steve, the sales support agent, let the customer know he would call them back after looking into this. The problem is he forgot to write down the customer's name. All he can remember is that it starts with a B and they are living in a non-English speaking country. Let's look for this customer.

Diese Übung ist Teil des Kurses

Introduction to Oracle SQL

Kurs anzeigen

Interaktive Übung

Versuche dich an dieser Übung, indem du diesen Beispielcode vervollständigst.

SELECT LastName, Country
FROM Customer
-- Filter on the customer last name
WHERE LastName ___ '___'
Code bearbeiten und ausführen