انا عندي تسليم بروجكت يوم السبت أي غداً واحتاج الى بعض الكويريز >>
الكويريز كالتالي
1. List all users (user id, and name), the number of borrowing, the number of books have been borrowed, and the number of different categories.
2. For each book category, list the number of books, number of transactions, and number of different users.
3. Display the detail most famous book (books that has been borrowed most).
4. For books that has been writer by three authors, list of the books (number and title) and number of authors
5. List all the book that has been currently borrowed
شكراً مقدماً
ملفات مرفقة
-
ER.doc 37كيلو
34 عدد مرات التحميل
أعلى
