SQL I need help with the following question I would like to focus on my job tabl

Question

SQL

I need help with the following question I would like to focus on my job table, that states a job not started, quality control, and completion of customers I have attach screenshots od each table.

11. Write a query that returns all the data from the sample data scenarios you created in previous tasks. The data scenario data is data that “makes sense” from a business process standpoint. Run the query.

a. In the Project Assignment report, document the query and the results of running the team query

Job Table

Columns Data |Model Constraints Grants Statistics Triggers Flashback IDependencies Details |Partitions Indexes sQL . Actions.. DATA TYPE NULLABLE DATA DEFAULT COLUMN_ID COMMENTS COLUMN NAME 1 JoB_INSTRUCTION VARCHAR2 (500 BYTE) No 2 JOB DATE 3 JOB DEADLINE 4 WEIGHT IN 5 WEIGHT OUT 6 WEIGHT DIFF 7 ESTIMATE 8 DEPOSIT 9 JOB RETURN 10 BILLING_ADDRESS VARCHAR2 (100 BYTE) No 11 BILLING CITY 12 BILLING_ZIP_CODE VARCHAR2 (9 BYTE) No 13 SHIPPING_ADDRESS VARCHAR2 (100 BYTE) No 14 SHIPPING_CITYVARCHAR2 (40 BYTE) No 15 SHIPPING_ZIP_CODE VARCHAR2 (9 BYTE) No 16 PROMO ID 17 CUSTOMER ID 18 JEWELRY_TYPE_ID 19 COUNTRY ID (null) (null) (null) (null) (null) (null) (null) (null) 1 (null) 2 (null) 3 (null) 4 (null) 5 (null) 6 (null) 7 (null) 8(null) (null) 10 (nul1) 11 (null) 12 (null) 13 (null) 14 (null) 15 (null) 16 (nul1) 17 (nul1) 18 (nul1) 19 (null) 20 (null) 21 (null) 22 (nul1) 23 (null) 24 (null) DATE DATE NUMBER (19,2) NUMBER (19,2) NUMBER (19,2) NUMBER (19,2) NUMBER (19,2) VARCHAR2 (2 BYTE) Yes Yes Yes Yes No PRICE no (null) Houston (null) (null) Houston (null) (null) (null) (null) (null) (null) (null) (null) (null) (null) VARCHAR2 (40 BYTE) No NUMBER (19,2) NUMBER (19,2) NUMBER (19, 2) NUMBER (19,2) NUMBER (19,2) NUMBER (19,2) NUMBER (19,2) NUMBER (19,2) NUMBER (19,2) Yes 20 STATE ID 21 SIZE ID 22 SERVICE ID 23 JOB STATUS ID 24 JOB ID

Explanation / Answer

SELECT J.JOB_INSTRUCTION,
J.JOB_DATE,
J.JOB_DEADLINE,
J.ESTIMATE_PRICE,
J.DEPOSIT,
J.SHIPPING_ADDRESS,
J.SHIPPING_CITY,
J.SHIPPING_ZIP_CODE,
J.BILLING_ADDRESS,
J.BILLING_CITY,
J.BILLING_ZIP_CODE,
J.CUSTOMER_ID,
J.COUNTRY_ID,
J.JOB_STATUS_ID,
C.CUS_CNAME
FROM JOB J, CUSTOMER C
WHERE J.CUSTOMER_ID = C.CUSTOMER_ID;

As per the business point of view the above details are required.

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.