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.
On this page of the site you can watch the video online SQL Interview Question - 4 Hard with a duration of hours minute second in good quality, which was uploaded by the user ML - Made it Simple! 27 January 2022, share the link with friends and acquaintances, this video has already been watched 42 times on youtube and it was liked by 0 viewers. Enjoy your viewing!