How do i set up queries for child with most popular books? HELP PL

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am doing a project for my IT course and I have tried everything I can to
get the query right bt it doesn't work. I am designing for a library system
and I was wondering how do you set a query to find the child with the most
popular and to display all the books each member has read.
Thank you xxx
Please email me : - (e-mail address removed)
 
Without knowing the structure of your database, it would be almost
impossible to answer that question.

Child with the most popular? I guess you'd want to create a query to pull
the "top" book (the one checked out the most) and then see which child has
that book.

To display all the books a member has read, you'd pull all the records from
your "check out" table, then group and sort by the person.

Again, hard to answer without knowing your structure.

Since this appears to be homework, I'd think the hints I gave you above
would be sufficient for you to figure it out. I doubt anyone here will give
a terrible specific answer since this is your coursework.

Also, have you tried asking your instructor for help?

Hope that helps.
 
Many of the folks you'll find here in the 'groups believe coursework is
designed to help you learn the topic ... so many of the folks will be
disinclined to actually do the homework.

Rick points out an approach you could use.

I'm not clear whether you are talking about a "child" that is a human, or a
"child record" (the "many" side of a one-to-many relationship)? And how are
you defining "with the most popular"?
 
Back
Top