I have a database of real estate listings in office buildings. There are multiple suites per building. I want to do a query that returns the largest suite and smallest suite per address so this is what i have and i keep getting empty results:
SELECT max(size) FROM listing GROUP By ‘street_number’ ORDER by ‘$sort’
if I replace max with * then it works fine, so I know the rest of the query is structured correctly. The column I want the max and min Values from is ‘size’. Any help will be appriciated.
