title: Comedy Movies Description Write a query to list all the films existing in the 'Comedy' category and arrange them in the alphabetical order
body: <p>Sample Output</p>
  <pre><code>title
  
  ACADEMY DINOSAUR
  </code></pre>
  <p>I tried the following code but it isn't producing the expected output such as that of the sample output. Someone please help me with this. Thank you</p>
  <pre><code>select Title
  from film 
  join film_category USING (film_id)
  join category USING (category_id)
  order by film_id = 'Comedy'
  limit 1;
  </code></pre>