SQL-Question

Question

Hello! I have an exercise here with two tables from an library. The first one shows the colums: articleNr, media, title, who owns it now
The second one: user ID,name, last name, adress.

The user ID and the ,,who ownes it now‘‘ are the primary key and they show who ownes the book now. So now i my exercise: Who ones the most media right now. What is the SQL command for this Question?

Answer 1

Since you want to know "who owns it" and you already know who owns it now, just "count" how many "media" is owned and I would "group it" by name.Good luck David.