Re: Re: Re: Untitled

From Sharp Terrapin, 2 Months ago, written in Plain Text, viewed 120 times. This paste is a reply to Re: Re: Untitled from Eratic Lechwe - view diff

URL http://codebin.org/view/c3e1ee42 Embed

Download Paste or View Raw

SELECT c.name AS category_name,
       AVG(length) AS average_length
FROM movie AS m
INNER JOIN film_category AS fc ON m.film_id = fc.film_id
INNER JOIN category AS c ON fc.category_id = c.category_id
WHERE rating IN
(SELECT rating
FROM movie AS m
GROUP BY rating
ORDER BY AVG(rental_rate) DESC
LIMIT 10)
GROUP BY c.name;

Replies to Re: Re: Re: Untitled

Title	Name	Language	When
Re: Re: Re: Re: Untitled	Torrid Panda	text	2 Months ago.

Reply to "Re: Re: Re: Untitled"

Here you can reply to the paste above

Author What's your name?

Title Give your paste a title.

Language What language is your paste written in?

Your paste Paste your paste here

Create Shorturl Create a shorter url that redirects to your paste?

Private Private paste aren't shown in recent listings.

Delete After When should we delete your paste?