2. 3. 5. 6, 7. 8. 9. 10. Display the name, and address of persons who...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
2. 3. 5. 6, 7. 8. 9. 10. Display the name, and address of persons who live in the city of Portland. The output should have column headings "Name" and "Address", and respectively display first name and last name separated by a space, and address and city separated by comma and space. (104 rows) Compute the total number of books for each subject. Output the subjectid together with its total number of books, in decreasing order of total number of books. (16 rows) Display the first name, last name and city of persons who borrowed any book. There should not be any duplicate records in your result. (128 rows) a. Write your query without using the JOIN operator keyword or any sub-query. b. Write your query using the JOIN operator. c. Write your query using an IN sub query. Are there books that belong to on the subject 'Databases' that are written by more than 2 authors (in whatever role)? Display the bookdescid and title of these books. (0 rows) The dates in relation "borrow" are stored as REAL type data in Julian Days. You can use the built-in date() function to convert the real value into date format. For example, to find out a duedate as YYYY- MM-DD format you can use date(duedate). Find out the borrowers who returned the books after the due dates. Display book title, "borrower name" (concatenated first name and last name), date of return, due date, and how many days were delayed from the due date. Display the dates in YYYY-MM-DD format. (33 rows) Find out the books that have never been borrowed. Display the book titles along with the year of publication, ordered alphabetically by title and then from newest to oldest. (296 rows) Find out the authors (including co-authors) who have written (in the "Author" role) more than one book. Display the first name, last name of authors and their role along with the book title, ordered alphabetically by the last name and then first name of authors. (151 rows) A person is reading books about Networks (title containing the string 'network' in any case). They want to find books on the topic co-written (in whatever role) by ONLY 'Tim Miller' and 'Jason Noel' (no other authors). Display the titles of these books. (0 rows) Find all OTHER books written by the author of the book with title 'COMPUTER SCIENCE'. Display the title, "Author Name" (first name and last name), and year of publication of OTHER books by the same author(s). (1 row) Find out the persons who borrowed books on the subject of "Image Processing". Display borrower name (first and last names, separated by a space) under the column heading of "Borrower", book title, book subject, borrow date, and return date. Borrow and return dates should be in the YYYY-MM-DD format. (5 rows) 2. 3. 5. 6, 7. 8. 9. 10. Display the name, and address of persons who live in the city of Portland. The output should have column headings "Name" and "Address", and respectively display first name and last name separated by a space, and address and city separated by comma and space. (104 rows) Compute the total number of books for each subject. Output the subjectid together with its total number of books, in decreasing order of total number of books. (16 rows) Display the first name, last name and city of persons who borrowed any book. There should not be any duplicate records in your result. (128 rows) a. Write your query without using the JOIN operator keyword or any sub-query. b. Write your query using the JOIN operator. c. Write your query using an IN sub query. Are there books that belong to on the subject 'Databases' that are written by more than 2 authors (in whatever role)? Display the bookdescid and title of these books. (0 rows) The dates in relation "borrow" are stored as REAL type data in Julian Days. You can use the built-in date() function to convert the real value into date format. For example, to find out a duedate as YYYY- MM-DD format you can use date(duedate). Find out the borrowers who returned the books after the due dates. Display book title, "borrower name" (concatenated first name and last name), date of return, due date, and how many days were delayed from the due date. Display the dates in YYYY-MM-DD format. (33 rows) Find out the books that have never been borrowed. Display the book titles along with the year of publication, ordered alphabetically by title and then from newest to oldest. (296 rows) Find out the authors (including co-authors) who have written (in the "Author" role) more than one book. Display the first name, last name of authors and their role along with the book title, ordered alphabetically by the last name and then first name of authors. (151 rows) A person is reading books about Networks (title containing the string 'network' in any case). They want to find books on the topic co-written (in whatever role) by ONLY 'Tim Miller' and 'Jason Noel' (no other authors). Display the titles of these books. (0 rows) Find all OTHER books written by the author of the book with title 'COMPUTER SCIENCE'. Display the title, "Author Name" (first name and last name), and year of publication of OTHER books by the same author(s). (1 row) Find out the persons who borrowed books on the subject of "Image Processing". Display borrower name (first and last names, separated by a space) under the column heading of "Borrower", book title, book subject, borrow date, and return date. Borrow and return dates should be in the YYYY-MM-DD format. (5 rows)
Expert Answer:
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these databases questions
-
Order processing time can be accelerated by using _______ (EDI) which facilitates a review of the customer's credit rating and whether goods are in stock, issuing an order to the warehouse, invoicing...
-
Nathan, Busi, Sandile and Tom started a business in 2008. They have been requested to exclude their personal tax returns from that of the business. What form of company is that? A. Public company B....
-
Carol Harris, Ph.D, CPA, is a single taxpayer and she lives at 674 Yankee Street, Durham, NC 27409. Her Social Security number is 793-52-4335. Carol is an Associate Professor of Accounting at a local...
-
Two ball bearings from different manufacturers are being considered for a certain application. Bearing A has a catalog rating of 2.0 kN based on a catalog rating system of 3 000 hours at 500 rev/min....
-
A beryllium-copper metal flat belt with Sf = 56.67 kpsi is to transmit 5 hp at 1125 rev/min with a life goal of 106 belt passes between two shafts 20 in apart whose centerlines are in a horizontal...
-
Presented below is the Governmental Funds Balance Sheet for the Warrenton Library District, a special-purpose entity engaged in a single governmental activity. Prepare a combined Governmental Funds...
-
Cheese Please Ltd produces cheese topping for the fast pizza industry. At the beginning of April, 20 000 kilograms of cheese topping was in process, 100% complete as to raw materials and 60% complete...
-
Santos Company currently manufactures one of its crucial parts at a cost of $3.40 per unit. This cost is based on a normal production rate of 50,000 units per year. Variable costs are $1.50 per unit,...
-
How would you help employees build cultural intelligence in your fictional organization? Name and explain two specific actions you would take to help employees build cultural intelligence. Explain...
-
Fawcett Institute provides one-on-one training to individuals who pay tuition directly to the business and also offers extension training to groups in off-site locations. Fawcett prepares adjusting...
-
Martin Company's cost of goods sold is 40% of net sales revenue. This means that for every $1 of net sales revenue, Martin has $0.60 of gross profit. True False
-
ABC Corporation is considering the acquisition of JLK Corporation. ABC has 760,000,000 shares of stock, with earnings per share of $6.70 and a market price per share of $78. JLK has 350,000,000...
-
A company purchased a commercial dishwasher by paying cash of $8,000. The dishwasher's fair value on the date of the purchase was $10,000. The company incurred $600 in transportation costs, $500...
-
Indicate if a Deferred Tax Asset (DTA), Deferred Tax Liability (DTL) or permanent (P) difference would result when difference originates. For permanent differences, indicate if adding (P+) or...
-
Make a Reflective Learning Log Report on some situation which can be relatable for student Section A . Before the event / experience: Describe the event / experience . Consider the things that could...
-
On 1 5 October 2 0 1 9 , the board of directors of MAA Bhd decided to close down one of its overseas divisions due to continuous losses. For this reason, a detailed plan was drafted and all costs...
-
Which of the following is not true about EPS? It must be reported separately for discontinued operations. None of the other answers is correct. It must be reported on operating income. It must be...
-
Time Travel Publishing was recently organized. The company issued common stock to an attorney who provided legal services worth $25,000 to help organize the corporation. Time Travel also issued...
-
During 2012, Tom sold Sears stock for $10,000. The stock was purchased 4 years ago for $13,000. Tom also sold Ford Motor Company bonds for $35,000. The bonds were purchased 2 months ago for $30,000....
-
Laura is a single taxpayer living in New Jersey with adjusted gross income for the 2012 tax year of $35,550. Laura's employer withheld $3,300 in state income tax from her salary. In April of 2012,...
-
William sold Section 1245 property for $25,000 in 2012. The property cost $35,000 when it was purchased 5 years ago. The depreciation claimed on the property was $16,000. a. Calculate the adjusted...
-
Show all the steps leading to the integral balance equation (18.6) in the text. Use the following boundary conditions and verify Eq. (18.7). (i) At \(y=0, T=T_{\mathrm{S}}\). (ii) At...
-
Consider the flat-plate heat transfer to be solved by the similarity approach. Show all the details leading to Eq. (18.15). What are the boundary conditions on \(\theta\) ? Extend your MATLAB code to...
-
For fluids with \(\operatorname{Pr} <1\) the velocity profile is assumed to be a cubic for \(y
Study smarter with the SolutionInn App