I think it should use GroupBy and aggregate functions to do the following steps I require, however I just can’t get this to work:
So say I have the table below but with more records
Price
I wish to require a query stating that the count of “Freight Value” falls into one of the ranges
How is this possible to do this ?? if you need me to explain with more detail let me know, thank you up ahead!
So say I have the table below but with more records
Price
Code:
Cost Zone Zip Code Weight(lbs) Price Cost Freight Value
5 K0K 1209 0 135 289
5 K0K 157 0 135 0
5 K0L 1425 0 135 650
5 K0L 1425 0 135 1999I wish to require a query stating that the count of “Freight Value” falls into one of the ranges
Code:
Zip Code Range 0-500 Range 501-1000 Range 1001-2000
k0K 2 0 0
K0L 0 1 1How is this possible to do this ?? if you need me to explain with more detail let me know, thank you up ahead!
Last edited:
