Age of actors from the USA

Now you will explore the age of American actors and actresses. Report the date of birth of the oldest and youngest US actor and actress.

Bu egzersiz

Data-Driven Decision Making in SQL

kursunun bir parçasıdır

Kursu Görüntüle

Egzersiz talimatları

Create a subsequent SELECT statements in the FROM clause to get all information about actors from the USA.
Give the subsequent SELECT statement the alias a.
Report for actors from the USA the year of birth of the oldest and the year of birth of the youngest actor and actress.

Uygulamalı interaktif egzersiz

Bu örnek kodu tamamlayarak bu egzersizi bitirin.

SELECT ___, -- Report for male and female actors from the USA 
       ___, -- The year of birth of the oldest actor
       ___ -- The year of birth of the youngest actor
FROM
   ___ -- Use a subsequen SELECT to get all information about actors from the USA
   ___
   ___ -- Give the table the name a
GROUP BY ___;

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