An attempt at data analysis for open rice, using SQL and Python

Thank you for reading my second assignment, which is an attempt at data analysis using sql and python. Here is the analysis of hotpot restaurants in the New Territories of Hong Kong.

Result 1:

How many hot pot restaurants are there in New Territories with prices between HK$100 and HK$300?
This step sorts out the restaurants that meet my consumption budget.

Result 2:

What are the top 25 restaurants with the highest positive reviews?
Positive reviews usually reflect the food and service level of the restaurant in a comprehensive manner.

Result 3:

What are the top 25 restaurants with the highest collection?
The number of collections is another important indicator of consumer attitudes towards restaurants.

Result 4:

Which restaurants are the top 25 in terms of number of positive reviews and number of favorites?
It is more worthwhile to try shops that are at the top of both collections and positive reviews.

Result 5:

Which restaurants have a higher collection conversion rate?
This is evaluated by the numer of favorites divided by the sum of the number of positive and negative reviews.