BaşlayınÜcretsiz Başlayın

Select from renting

Only some users give a rating after watching a movie. Sometimes it is interesting to explore only those movie rentals where a rating was provided.

Bu egzersiz

Data-Driven Decision Making in SQL

kursunun bir parçasıdır
Kursu Görüntüle

Egzersiz talimatları

  • Select from table renting all movie rentals from 2018.
  • Filter only those records which have a movie rating.

Uygulamalı interaktif egzersiz

Bu örnek kodu tamamlayarak bu egzersizi bitirin.

SELECT *
FROM renting
WHERE date_renting ___ '2018-01-01' ___ '2018-12-31' -- Renting in 2018
AND rating ___; -- Rating exists
Kodu Düzenle ve Çalıştır