b) Write a query to display the patron ID, last name, number of times that patron has ever checked out a book, and the number of different books the patron has ever checked out. For example, if a given patron has checked out the same book twice, that would count as two checkouts but only one book. Limit the results to only patrons who have made at least three checkouts. Sort the results in descending order by number of books, then in descending order by number of checkouts, and then in ascending order by patron ID. Sample Output:- Chekouts and Books by Patron PAT_ID PAT_LNAME NUM CHECKOUTS NUM DIFFERENT BOOKS 1161 Koch 1165 Baldwin 1181 Horne 1185 Yang 1210 Cooley 1229 Burke 1160 carter 1171 Marsh 1172 Miles 1207 Ramos 1209 Mathis 1183 Hughes 3 3 3 3 3 لا لا لا لا لا لا لا لا 3 3 3 3 3 3 3 3 3 3 3 3 3 2 2 2 2 2 1

b) Write a query to display the patron ID, last name, number of times that patron has ever checked out a book, and the number of different books the patron has ever checked out. For example, if a given patron has checked out the same book twice, that would count as two checkouts but only one book. Limit the results to only patrons who have made at least three checkouts. Sort the results in descending order by number of books, then in descending order by number of checkouts, and then in ascending order by patron ID. Sample Output:- Chekouts and Books by Patron PAT_ID PAT_LNAME NUM CHECKOUTS NUM DIFFERENT BOOKS 1161 Koch 1165 Baldwin 1181 Horne 1185 Yang 1210 Cooley 1229 Burke 1160 carter 1171 Marsh 1172 Miles 1207 Ramos 1209 Mathis 1183 Hughes 3 3 3 3 3 لا لا لا لا لا لا لا لا 3 3 3 3 3 3 3 3 3 3 3 3 3 2 2 2 2 2 1

Programming with Microsoft Visual Basic 2017

8th Edition

ISBN:9781337102124

Author:Diane Zak

Publisher:Diane Zak

Chapter11: Sql Server Databases

Section: Chapter Questions

Problem 15RQ

See similar textbooks

Similar questions

Official Miami Dade College Hon x / Content Take Test: Exam 2- CGS1540C-2 x Ô https://mdc.blackboard.com/webapps/assessment/take/launch.jsp?course assessment_id= 818475 1&course_id=_207342_ O Imported from Inte. Remaining Time: 1 hour, 48 minutes, 41 seconds. * Question Completion Status: QUESTION 2 During class, I showed you how application programs (e.g., software used by nurses in hospitals) written in different general-purpose programming languages can use API to send SQL code to SQL servers. Which one of the following was an example of a programming language that I used to illustrate that idea? O Cookies O PHP O Front-end scripting O HTML QUESTION 3 Which of the following statements regarding MYSQL is FALSE? O It has free and open-source versions O It is most popular with web applications O It is owned by Oracle O It implements SQL in a non-relational structure Click Save and Submit to save and submit. Click Save All Answers to save all answers. P Type here to search a * S O 77°F…
The following Excel image has a VBA program (see below). What will be the result after the program is executed? Any cells not displayed are currently empty, and any cells with numbers are formatted numeric. A B C D 1 2 3 UN Gross Domestic Product (GDP) per Capita 4 5 6 7 8 9 10 11 12 Total Year/Country Angola Portugal France 2000 2005 2010 2015 2020 10 10 10 10 10 50 100 100 100 100 100 500 1,000 1,000 1,000 1,000 1,000 5,000 E Mexico 10,000 10,000 10,000 10,000 10,000 50,000
Create Trigger for When a student marks are being inserted, if the marks that are inserted are greater than 50, allow the insertion, but update marks to 50. Marks(Id , Marks) -> Table Fill in the blanks: ___ triggerName Before ___ ON Marks REFERENCING _____ AS nrow FOR EACH ROW WHEN (nrow.marks>50) _____ nrow SET nrow.marks = 50;
DATA: myBytes BYTE 10h,20h,30h,40hmyWords WORD 8Ah,3Bh,72h,44h,66hmyDoubles DWORD 1,2,3,4,5myPointer DWORD myDoubles Questtion: mov edx,[myDoubles + edi] ; EDX =?
Transcribed Image Text SOL Assignment Salesforce: In this assignment you have to find the all the account or contact where the 'test' key in find either in account name or in contact first name and in last name. otherwise l'll downvote multiple please do no provide uploaded answer on bartleby times
flavors_df 1>I What code chunk do you add to change the column name? rename (Company <- Company...Maker.if.known.) rename (Company... Maker.if.known. = Company) rename (Company = Company... Maker.if.known.) rename (Company...Maker.if.known. <- Company)
DATA: myBytes BYTE 10h,20h,30h,40hmyWords WORD 8Ah,3Bh,72h,44h,66hmyDoubles DWORD 1,2,3,4,5myPointer DWORD myDoubles Questtion: mov al,[esi+3] ; AL = ?
DATA: myBytes BYTE 10h,20h,30h,40hmyWords WORD 8Ah,3Bh,72h,44h,66hmyDoubles DWORD 1,2,3,4,5myPointer DWORD myDoubles Questtion: mov al,[esi]; AL =?
Schoology X 1+ com/common-assessment-delivery/start/5581281107?action=onresume&submissionid=871120828 COURSES GROUPS RESOURCES GRADES Checkpoint 2.2 The Insert menu allows you to insert: O images O charts Otables header/footers all of the above
the "list.txt" contains information about materials stored in the warehouse. Every record (line) in the file contains code, name and description seperated by "#" write a php script that will open the file, read the content of the file and manupulate using associative array with code as a key. the array should be sorted by the code and displayed to the user.
Horse with columns: ID - primary key RegisteredName Breed Height BirthDate Student with columns: ID - primary key FirstName LastName Street City State Zip Phone EmailAddress LessonSchedule with columns: HorseID - partial primary key, foreign key references Horse(ID) StudentID - foreign key references Student(ID) LessonDateTime - partial primary key Write a SELECT statement to create a lesson s
hello please i want SQL Statements (DDL & DML) full code based on this ERD diagram Patient patientiD PK Pharmacy BloodBank PAame Medicine pharmacylD PK bankID bloodType patientiD PK PAge treatmentiD 0.. PK treatmentID FK pHeathissue medName FK peloodType medPrice FK medPrice 0. Appointment appointmentiD Doctor DoctorClinic 1 appointmentiD FK PK doctoriD PK 0.appointmentDate 0. dName treamentiD FK medPrice doctoriD FK appointment_price FK patientiD FK FK appointmentStatus appoinment_price