Write a query that will display the customer number, first name, and last name f

Question

Write a query that will display the customer number, first name, and last name for every customer with a balance greater than $50. Display the first and last name as a single column and provide an alias for the column.

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

Query that will display the customer number, first name, and last name for every customer with a balance greater than $50

SELECT Customer_Number,First as First Name, Last as Last Name
FROM     Customer
WHERE    Balance >50;

The first and last name as a single column with an alias for the column.

SELECT First + ' ' + Last AS Cutomer_Name

FROM Customer;

OR you can write:

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

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