Tried looking everywhere for this but my searching hasn't given me any answers.
Looking to count how many times the word 'Sydney' comes up in the column 'Suburb'
CustomerId FirstName LastName StreetAddress Suburb PostCode
C001 James Smith 400 Kent St Sydney 2000
C002 Maria Carpenter 333 Smith St Westmead 2145
C003 Dennis Miller 214 Uni Rd Sydney 2000
I want it to provide an outcome like:
numCustomersFromSydney
2
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…