question with its query
Posted
by user329820
on Stack Overflow
See other posts from Stack Overflow
or by user329820
Published on 2010-05-01T13:57:00Z
Indexed on
2010/05/01
14:07 UTC
Read the original article
Hit count: 297
Hi this is my homework and the question is this: List the average balance of customers by city and short zip code (the first five digits of thezip code). Only include customers residing in Washington State (‘WA’). also the Customer table has 5 columns(Name,Family,CustZip,CustCity,CustAVGBal)
I wrote the query like below is this correct?
SELECT CustCity,LEFT(CustZip,5) AS NewCustZip,CustAVGBal
FROM Customer
WHERE CustCity = 'WA'
THANKS!!
© Stack Overflow or respective owner
