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