title: How can I make a counter trigger that updates a different table?
body: <p>Basicly what I want to do is create a trigger which is updates the number of workers in the city I inserted the new worker in but so far I have no idea how could I make that.</p>
  <p>This is the code so far but it doesn't works but I think it makes sense what I meant to do.</p>
  <pre><code>Create or replace trigger Worker_insert
  After insert
  on worker
  
  begin
     update cities Set workers_count=workers_count+1 
     where cities.name=worker.city;    
      
  end;
  </code></pre>