Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- Actor.actName,
- COUNT(mvTitle) AS Count,
- ROUND(AVG(mvPrice), 2) as "Average Price"
- FROM
- Movie,
- Actor
- WHERE
- Actor.actID = Movie.actID
- GROUP BY
- Actor.actName
- HAVING
- Count > 1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement