Consider the following relational schema for the following question:

Star $($s$-$id$,$ name, age, nationality$)$

Film $($f$-$id$,$ f$-$name, year$)$

Role $($s$-$id$,$ f$-$id$)$

Which of the following relational algebra queries lists the names of the stars who role in films

produced in $2023$ and movies produced in $2024?$

A year$=2023$ AND year$=2024($Film $*$ Role $*$Star$))$

B year$-2023($Film $*$ Role $*$ Star $\{$:$)$ name $($ yoar$=2024($Film $*$ Role $*$ Star$))$

C year$-2023($Film $*$ Role$)){?}^{}$ name $($ year $2024($Film $*$ Role$))$

D year$=2023$ AND year$=2024($Film $*$ Role$)$