Functions in WHERE

You want to know which players from the 2017-2018 NBA season went to college in Louisiana. You ask a friend to make the query for you. It looks like he overcomplicated the WHERE filter condition by unnecessarily applying string functions and, also, it does not give you precisely what you want because he forgot how to spell Louisiana. You will simplify his query to return exactly what you require.

Bu egzersiz

Improving Query Performance in SQL Server

kursunun bir parçasıdır

Kursu Görüntüle

Egzersiz talimatları

Select Run Code to see what your friend's query returns.
Think about why his query is not giving you exactly what you require then comment out his filter on line 7.
Add a new wildcard filter condition - Louisiana%

Uygulamalı interaktif egzersiz

Bu örnek kodu tamamlayarak bu egzersizi bitirin.

SELECT PlayerName, 
      Country,
      College, 
      DraftYear, 
      DraftNumber 
FROM Players 
WHERE UPPER(LEFT(College,5)) LIKE 'LOU%';
                   -- Add the new wildcard filter

Kodu Düzenle ve Çalıştır