Question: SELECT a . first _ name, a . last _ name, CASE WHEN EXISTS ( SELECT 1 FROM film _ actor fa INNER JOIN film
SELECT afirstname, alastname,
CASE
WHEN EXISTS SELECT FROM filmactor fa
INNER JOIN film f ON fafilmid ffilmid
WHERE faactorid aactorid
AND frating G THEN Y
ELSE N
END gactor,
CASE
WHEN EXISTS SELECT FROM filmactor fa
INNER JOIN film f ON fafilmid ffilmid
WHERE faactorid aactorid
AND frating PG THEN Y
ELSE N
END pgactor,
CASE
WHEN EXISTS SELECT FROM filmactor fa
INNER JOIN film f ON fafilmid ffilmid
WHERE faactorid aactorid
AND frating NC THEN Y
ELSE N
END ncactor
FROM actor a
WHERE alastname LIKE S OR afirstname LIKE S;
Please draw a workflow for the query and please be clear about the logic embedded in the case expression
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Study Help