Advertisement
Guest User

Untitled

a guest
Feb 26th, 2020
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.21 KB | None | 0 0
  1. SELECT
  2. Actor.actName,
  3. COUNT(mvTitle) AS Count,
  4. ROUND(AVG(mvPrice), 2) as "Average Price"
  5. FROM
  6. Movie,
  7. Actor
  8. WHERE
  9. Actor.actID = Movie.actID
  10. GROUP BY
  11. Actor.actName
  12. HAVING
  13. Count > 1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement