Count the number of films spoken in English. You must not hard code English's language_code. Give two solutions for this problem: the first using a subquery and the second using a join of tables.

Explanation name has given below

Explanation:

In sub query we have to take Film Language .From Film Where code is equal to language code and language is English.

FROM Film F,FilmLanguage L1,

WHERE C.Code = L1LanguageCode

AND L1.Language = 'English';

Join table:

code |        film_name       |  Language           * where E = English & N = no

++

   01 | Forrest Gump          | E

   02 | Good fellas              | E

   03 | Peter                        | N

   04 | Hotel Rwanda         | E

   05 | F. Murray                 | N

   06 | The Green Mile       | E

   07 | Nicole                       | N

   08 | The Godfather         | E

   09 | Jack                          | N

b. related objects

explanation:

data is stored in related objects in an access database.