Writing an Oracle SQL Query

Question

I want to make a query that will display the largest number of movies rented by one member and it should also show the member's name.

This is what I have.

SELECT FIRST, LAST AS, COUNT(mm_rental.member_id) AS "MAXIMUM MOVIES"
FROM mm_member, mm_rental
WHERE mm_rental.member_id = mm_member.member_id;

But its not working. Can anyone please help?

It tells me that my "SELECT FIRST,LAST" is not a single-group group function. — user2461116
– user2461116, Commented Nov 4, 2013 at 2:52

Iswanto San · Accepted Answer · 2013-11-04 02:52:11Z

2

Since COUNT is an aggregate function, you should use GROUP BY in your query.

And you should using JOIN syntax.

More : Please use ANSI join syntax

SELECT [FIRST], [LAST], COUNT(mm_rental.member_id) 
AS "MAXIMUM MOVIES" FROM mm_member JOIN mm_rental 
ON mm_rental.member_id = mm_member.member_id
group by [FIRST], [LAST];

answered Nov 4, 2013 at 2:52

Iswanto San

18.6k13 gold badges60 silver badges79 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Writing an Oracle SQL Query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related