Question: Please explain how to make these queries in detail! Please explain how to make these queries in detail! Download LibraryCirculationDB_Winter2020-InClass.accdb: Relationships X Borrower 1 SSN

Please explain how to make these queries in detail!

Please explain how to make these queries in detail! Please explain how SSN Name Address Subject/Topic 1 SubjectID Subject Description BookCard Catalog ISBN Title

Please explain how to make these queries in detail!

Download LibraryCirculationDB_Winter2020-InClass.accdb: Relationships X Borrower 1 SSN Name Address Subject/Topic 1 SubjectID Subject Description BookCard Catalog ISBN Title 1stAuthor Publisher YearOfPublication 81 Book 1 ISBN 1 Copy SSN DateChargedout DateDue 18 covers ISBN 1 SubjectID 18 Implement each of the following queries: Query 1: Give distinct ISBN's for books currently loaned out. (1168 rows) Hint: SELECT DISTINCT removes duplicate rows from the output. Query1-ISBN's for books currently loaned out X ISBN 9780060006938 9780060747503 9780060891541 9780060932688 9780060956431 9780060964313 9780060972455 9780060975401 9780061330254 9780061577628 9780061807886 9780061859977 Query 2: Give ISBN and Title for books currently loaned out. (1168 rows) Query2-ISBN and Title for books currently loaned out X ISBN Title 9780060006938 GREAT MORTALITY 9780060747503 REBIRTH OF A NATION (P) 9780060891541 ON WRITING WELL (30TH ANNIV ED) (P) 9780060932688 COLLECTED STORIES (PERENNIAL CLASSICS ED) (P) 9780060956431 WRITING THAT WORKS (REV & UPD) (P) 9780060964313 SHORT HISTORY OF RECONSTRUCTION (P) 9780060972455 TRACKS (P) 9780060975401 HOW WE SURVIVED COMMUNISM & EVEN LAUGHED (P) 9780061330254 FRANKLIN D ROOSEVELT & NEW DEAL (P) 9780061577628 LAST REPORT ON THE MIRACLES AT LITTLE NO HORSE (P) 9780061807886 LIFE OF ANDREW JACKSON (PERENNIAL POLITICAL CLASSIC) (P) 9780061859977 HOUSE MADE OF DAWN (PERENNIAL MODERN CLASSIC) (P) 9780062362803 THE REAL LIFE MBA 9780070006577 COMPLEX ANALYSIS 9780071621250 BIG BOOK OF MARKETING (P) 9780071737692 THERAPEUTIC MODALITIES IN REHABILITATION 9780071748834 BUSINESS PLANS THAT WORK (P) 9780071771320 CRUCIAL CONVERSATIONS (UPD) (P) Query 3: List ISBN and Title of books that we carry at least 3 copies of. (1031 rows) Hint: This is a COUNT query. How Many 3 3 3 3 4 Query3-List ISBN and Title of books with at least 3 copies X ISBN Title 2780060006938 GREAT MORTALITY 9780060747503 REBIRTH OF A NATION (P) 9780060753948 WINNING 9780060891541 ON WRITING WELL (30TH ANNIV ED) (P) 9780060932688 COLLECTED STORIES (PERENNIAL CLASSICS ED) (P) 9780060956431 WRITING THAT WORKS (REV & UPD) (P) 9780060964313 SHORT HISTORY OF RECONSTRUCTION (P) 9780060972455 TRACKS (P) 9780060975401 HOW WE SURVIVED COMMUNISM & EVEN LAUGHED (P) 9780061807886 LIFE OF ANDREW JACKSON (PERENNIAL POLITICAL CLASSIC) (P) 9780061859977 HOUSE MADE OF DAWN (PERENNIAL MODERN CLASSIC) (P) 9780062362803 THE REAL LIFE MBA 9780070006577 COMPLEX ANALYSIS 9780071410946 TECHNIQUE FOR PRODUCING IDEAS (P) 9780071621250 BIG BOOK OF MARKETING (P) 9780071780469 PHARMACOTHERAPY (REV) 3 4 3 4 3 Wwwwwwww Query 4: How many books by first authors whose name includes MAN are checked out? (37 rows) Hint: This is a COUNT query too, but needs a couple of criteria. Query 4-*MAN* (as first author) books out X ISBN #of Copies Out - 9780060956431 1 9780073529301 1 9780077862411 1 9780078038419 2 9780132147835 2 9780137133444 1 9780195130454 1 9780199372294 1 9780199757534 1 9780205615964 1 9780205762613 1 9780205763139 1 9780321883636 1 9780323055901 1 9780325030883 1 9780325050935 1 9780374533403 1

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

QUESTION 27 Connie's Cakes wants to find out how much cash the company brought in this year. Which is the best financial statement to find this information? O Balance sheet O Income statement O...

Please explain how to make these queries in detail! Please explain how to make these queries in detail! Query 5: For each year, list the number of titles published in that year that the library...

I am so lost with all of this and the worst part it is due in an hour and a half. I don't know what to do please help. In this course you will have the opportunity to apply the concepts learned to a...

I really need help, please explain and show in detail what to do. If you don't know how to explain and help me, don't answer this question. Don't just give me a random unhelpful answer. Please...

Required information Chapter 08, Integrated Project 2: Y Not Flowers [The following information applies to the questions displayed below.] Background Forrest runs Y Not Flowers, Inc. (YNF), a...

i know its a long project but please answer it based on the format below 1-Introduction 2-Data Requirements and Conceptual Design 3-Database Construction and Population 4-Querying the Database...

Resources Cash Flower inventory Stores account (PK), bank, description, balance Jan 01, 2022 Inventory# (PK), flower name, unit, expected cost store (PK), phone, address state, zip, original purchase...

Project proposal Table Options O Title 1. State the proposed title of your project: 2 marks O Caption The Relationship of Social Support in Mental Health: An Investigation Currently Underway Headers...

INTRODUCTION "Enterprise Resource Planning with e-MOR ERP" is an individual assignment that you will complete using the e- MOR ERP software and submit online. You can log on to e- MOR ERP using the...

Group Project - Part III Kim's Flower Inc. Purchasing (Expenditure) Cycle Requirements: The final part of the project requires your team to implement the logical data model in MS Access. Please read...

This section in the picture is what i am needing. MergerETL Memo DATE 9/5/2018 MEMORANDUM FOR Young Jolly, LLC Merger Project Com FROM SmartBuy SUBJECT Merger Project ETL Parameters Now that ther e...

Business Sim Corp. (BSC) issued 1,000 common shares to Kelly in exchange for $ 12,000. BSC borrowed $ 30,000 from the bank, promising to repay it in two years. BSC paid $ 35,000 for computer...

Who, among university administrators, is most likely to be responsible for each of the following? a. Quantity of supplies used in executive education classes that the business school conducts b....

A nation that imposes tariffs on imported goods may find its welfare improving should the tariff result in a favorable shift in the terms of trade. Explain.

Q A favorable variance arises when: Multiple Choice Actual costs are more than budgeted costs Actual revenues are more than budgeted revenues. The actual amount decreased operating income relative to...

4. What do you know about the healthcare industry and electronic medical records? Have you ever worked with medical record systems and software? What work did you do with them?

Data management, analytics, and information system experience preferred

1. Have you worked with any business intelligence software? Which tools? What is your level of proficiency? Can you give examples of the kinds of data analysis work and reports you used these tools...