title: Shows a list with the names of all the movies and the number of actors associated >> ORACLE <<
body: <p>Well, I need to call on the screen what was asked, but how?
  I have three tables, containing the names of the films, which contains the name of the actors and the relational containing the 'ids' to display correctly. But I came across this and are difficult to solve, here are the tables ...</p>
  
  <pre><code>To create Actors table
  
  create table tb_ator(
          id_ator NUMBER (4) PRIMARY KEY NOT NULL,
               nome_ator VARCHAR (50) NOT NULL
      );
  
  
  To Create Films table
  
  create table tb_filme(
        id_filme NUMBER (4) PRIMARY KEY NOT NULL,
        nome_filme VARCHAR (50) NOT NULL 
  );
  
  And finaly, the relational 
  
  create table ator_filme(
        id_filme NUMBER (4) references tb_filme(id_filme),
        id_ator NUMBER (4) references tb_ator(id_ator)
  );
  </code></pre>
  
  <p>How do I solve this with the inner join?</p>