RE: Finding a Range of numbers in database

Basically I don’t know the correct term to look for.

I have DB with several different lawn sizes in it.

  1. How many are 0-2999sq/ft, 3000-3999, 4000-4999…etc

  2. I would like to take the discount percent from each one and average it.

  3. I would like to see which discount % was used the most.

I can probably figure out #2 and #3 but I just need some guidance on where to start on #1 (links, things to search for etc…)

Thank you in advance for the help.

Selecting ranges in SQL

Sponsor our Newsletter | Privacy Policy | Terms of Service