title: SQL Retrieving repeated rentals
body: <p>Question:</p>
  
  <blockquote>
    <p>write a SQL query that retrieves repeated rentals in which the same 
    customer rents the same movie more than once. if a customer rents the > same movie multiple times, the output should show this (customer's name, movie's title) combination only once</p>
  </blockquote>
  
  <p>There are 3 tables: </p>
  
  <ul>
  <li>customer table: (id, name, country, created_date)</li>
  <li>movie table: (id, title, duration, release_year)</li>
  <li>rental table: (id, customer_id, movie_id)</li>
  </ul>
  
  <p>i currently have:</p>
  
  <pre><code>select customer.name, movie.title
  from ((rental inner join customer on rental.customer_id = customer.id) inner join movie on rental.movie_id = movie.id)
  group by customer.name, movie.title
  having count(*) &gt; 1;
  </code></pre>
  
  <p>but it is incorrect - any thoughts?</p>