Question: Oracle SQL Task 1. Write and test a query to report what tools were loaned out during the seven months prior to the current month.

Oracle SQL

Task 1. Write and test a query to report what tools were loaned out during the seven months prior to the current month. The identifying information for what tools includes the tool description, tool id from the manufacturer of the tool, and the manufacturer of the tool. The tool library manager also wants to know: to whom were the tools loaned? and for what job? and were the tools returned to the tool libary and when? She is going to use the

I have this so far

select t.TOOL_ID_FROM_MFG, t.TOOL_DESC,t.TOOL_MFG, l.TOOL_OUT_DATE from QLIU07.loan_02 l, QLIU07.TOOL_DESCRIPTION_02 t where t.TOOL_DESC_ID = l.TOOL_DESC_ID and TOOL_OUT_DATE >='01-sep-2018' and TOOL_OUT_DATE

Oracle SQL Task 1. Write and test a query to report what

JOB-02 JOBID JOB-DESC JOBCUSTOMER JOBDATE TOOLDESCRIPTION02 - - TOOLDESCID TOOL ID FROM_MFG TOOL_MFG - - - - I TOOL DESC E CHANGED_BY_USER - JOB-STATUS JOB-STATUS-CHANGE-DA DATE UPDATED E CHANGED_BY_USER DATEUPDATED - TOOL02 LOAN-01 LOAN02 - TOOLNO TOOLDESCID CHANGEDBYUSER DATEUPDATED - - LOANID TOOL-NO TOOLDESCID EMPLOYEEID - - - - - - - - - JOBID - TOOL OUT_DATE DUEDATE LOANACTIVE LOAN-STATUS-CHANGE-[ E CHANGED_BY_USER - - DATEUPDATED

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!

I would like assist for my assessment. The subject is Subsidiary Accounts and Ledgers and Foundation Skills. T-1.8.1 Details of Assessment Term and Year 1, 2017 Time allowed Week 2-7 Assessment No 1...

that is all that was given In this Task you will build a database to support the needs of The Central Hospital, England who are working with local doctors' surgeries to keep accurate data about the...

There are two problems due this week (each worth 35 points) as follows. Case 5-1David L. Miller: Portrait of a White-Collar Criminal (page 144). In comprehensive paragraphs, answerrequirements 1?6....

Hello, Would you please review the attached assignment? I know I have errors in and this assignment carries into the rest of the course so I need to get it corrected to move forward. I have attached...

He want us to identify the 18 vulnerabilities. template is attach. Case No. 2000-02: Recreation, Inc. 1 AICPA Case Development Program RECREATION, INC. AN INFORMATION TECHNOLOGY RISK ASSESSMENT CASE...

Risk Assestment Project - Identify 18 Vulnerabilit AICPA Case Development Program Case No. 2000-02: Recreation, Inc. ? 1 RECREATION, INC. AN INFORMATION TECHNOLOGY RISK ASSESSMENT CASE STUDY OF...

Can you please help me with this case problem? AICPA Case Development Program. Case No. 2000-02: Recreation, Inc Case No. 2000-02: Recreation, Inc. 1 AICPA Case Development Program RECREATION, INC....

The new line character is utilized solely as the last person in each message. On association with the server, a client can possibly (I) question the situation with a client by sending the client's...

INTERNATIONAL REVIEW OF L AW C OMPUTERS & TECHNOLOGY , VOLUME 11, N UMBER 2, P AGES 251-261, 1997 The Data Mart: A New Approach to Data Warehousing PAM ELA PIPE Introduction Vendors have recently...

Describe some of the actions taken by Taco Bell to increase productivity that have resulted in Taco Bells ability to serve twice the volume with half the labor.

Multiple Choice Questions 1. What is Golden's gain or loss on the cap (the change in time value) for the 6-month period ending December 31, 2013? a. $5, 000 gain b. $6, 000 loss c. $1, 000 loss d....

The governor can delete items from the state budget if they so choose. True or False? True False

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

13. What are Lifelong Learning Accounts? Do you think they help retain employees or encourage them to train and then leave the company? Explain your rationale.

3. You are in charge of preparing a team of three managers from the United States to go to Ciudad Juarez, Mexico, where you have recently acquired an auto assembly plant. The managers will be in...

4. Go to fairuse.stanford.edu, a Web site called Copyright and Fair Use created by Stanford University Libraries. How does work fall into the public domain? That is, how can you use someone elses...