0

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?

3rd May 2018, 2:14 PM
David Szöke
David Szöke - avatar
1 Respuesta
+ 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
Roberto Guisarre - avatar