SQL Interview Question - 4 Hard
SQL with POSTGRE.
Question: Business Density Per Street
Find the average and highest number of businesses for all the streets in the dataset. Only consider streets with at least 5 businesses. Assume the street is extracted by choosing the second word from the business_address column. Use `business_id` as a way to count the number of unique businesses.
Link to the question is
https://platform.stratascratch.com/co...
SQL interview questions clearly explained with simple terms easy to understand.