SQL-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?

functions command help select sql,

3rd May 2018, 2:14 PM

David Szöke

1 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.

3rd May 2018, 6:05 PM

Roberto Guisarre