From the following tables, write a SQL query to find those movies directed by the director whose first name is 'Woddy' and last name is 'Allen'. Return movie title
- برمجة سي كيو ال sql
- 2021-09-03
- mhanasmh00489829403
الأجوبة
SELECT mov_title
FROM movie
WHERE mov_id=(
SELECT mov_id
FROM movie_direction
WHERE dir_id=(
SELECT dir_id
FROM director
WHERE dir_fname='Woody' AND dir_lname='Allen'
));Sample Output:
mov_title ---------------------------------------------------- Annie Hall (1 row)
أسئلة مشابهة
القوائم الدراسية التي ينتمي لها السؤال