Write a query that will list the part number and part description for all parts

Question

Write a query that will list the part number and part description for all parts in the PART table.

SALES REP CUSTOMER NUMBER CHARI3) SLSREP NUMBER CHAR(2) LAST FIRST STREET CITY STATE ZIP CODE BALANCE CREDIT LIMIT SLSREP NUMBER(FK) CHAR(2) CHAR(10) CHAR(B) CHAR(15) CHAR(15) LAST FIRST STREET CITY STATE ZIP CODE TOTAL COMMISSION NUMERIC(7.2) CHAR(10) CHAR(8) CHAR(15) CHAR(15) CHAR(2) CHAR(5) CHAR(S) NUMERIC(7.2) ORDERS CHAR(5) ...ORDER NUMBER ORDER DATE CUSTOMER NUMBER (FK) CHAR(3) DATETIME ORDER LINE ORDER NUMBER (FK) CHAR(5) PART NUMBER (FK) CHAR(4) NUMBER ORDERED NUMERIC(3.2) QUOTED PRICE NUMERIC(6.2) PART PART NUMBER CHAR 4) PART DESCRIPTION CHAR(20) UNITS ON HAND ITEM CLASS WAREHOUSE NUMBER CHAR(1) UNIT PRICE CHAR(12) CHAR(2) NUMERIC(6.2) Points: 15

Explanation / Answer

select PART_NUMBER,PART_DESCRIPTION FROM PART;

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

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