title: Select data to comply with a condition that relate to another table
body: <h1>Help</h1>
  
  <p>Considering that a passenger lives in his first flight departure town, find those passengers among dwellers of other cities who visited Moscow more than once. Result set: passenger´s name, number of visits to Moscow.</p>
  
  <p><a href="https://i.stack.imgur.com/U4MyN.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/U4MyN.jpg" alt="Details"></a></p>
  
  <p>Im trying to solve this query but i dont know how to take the city from departure and then take this to select which people flying the most to moscow, please Help.</p>
  
  <pre><code>select p.name, count(pt.trip_no) from passenger as p, trip as t, pass_in_trip as pt
  where pt.trip_no = t.trip_no and town_to='Moscow'
  group by pt.trip_no;
  </code></pre>
  
  <p>my result set is this</p>
  
  <pre><code>'Bruce Willis', '128'
  'Bruce Willis', '64'
  </code></pre>
  
  <p>but i dont know how to get people that flying more than once time to moscow </p>