Home owner's coverage A B C D E F, what does those mean?

 Homeowners Coverage (towneinsurance.com)

1. Coverage A, Dwelling
2. Coverage B, Other Structures
3. Coverage C, Personal Property
4. Coverage D, Loss of Use
5. Coverage E, Personal Liability
6. Coverage F, Medical Payments

MS SQL learning note

•  comments:  /* comments */ or --comments
• Right click on a table -> "Select TOP 1000 Rows" will run the script below:
• • SELECT TOP (1000) [RoomID]
  •       ,[RoomNumber]
  •       ,[BedType]
  •       ,[Rate]
  •   FROM Table.[ROOMS]

Microsoft Fabric study notes

 One lake

unet

https://medium.com/@nishanksingla/unet-with-resblock-for-semantic-segmentation-dd1766b4ff66

https://towardsdatascience.com/a-detailed-explanation-of-the-attention-u-net-b371a5590831

Leetcode 刷题

https://www.youtube.com/@leetcode8851

quantile regression

https://www.youtube.com/watch?v=JvIzB3hULCo https://github.com/ajhalthor/quantile-regression/blob/main/Quantile%20Regression.ipynb

normal distribution

1 sigma 68% 2 sigma 95% 3 sigma 99.7%

statistical concept

Type I error = False Positive Type II error = False Negative

salt boundary detection using unet

https://towardsdatascience.com/understanding-semantic-segmentation-with-unet-6be4f42d4b47

binary search problem

 Generic Binary Search Snippet

left = 0
right = len(nums)-1
while left <= right:
    #update mid
    mid = left+(right-left)//2
    if "find the element"
        do something # return mid index
    elif "cut the left half"
        left = mid+1
    else "cut the right half"
        right = mid-1
return "no found" # if not found, return left index

SQL Interview practice questions

 https://medium.com/@emmading/practice-for-3-types-of-sql-interview-questions-2bd057a88b4f

Having vs Where Clause in SQL

  It is not a predefined rule but  in a good number of the SQL queries, we use WHERE prior to GROUP BY and HAVING after GROUP BY. The Where clause acts as a pre filter where as Having as a post filter.

https://www.geeksforgeeks.org/having-vs-where-clause-in-sql/

presentation material

Useful photos on  probalistic Bayesian Deep learning model

https://towardsdatascience.com/bayesian-inference-and-transformers-3dc473ac1af2

 Explain poster predictive distribution

https://www.youtube.com/watch?v=R9NQY2Hyl14 

Sammuer Muller video (author):

https://www.youtube.com/watch?v=XnngBWe2WYE&t=1906s

 

Few shot learning

https://www.analyticsvidhya.com/blog/2021/05/an-introduction-to-few-shot-learning/

Kaggle which image models are best?

 https://www.kaggle.com/code/jhoward/which-image-models-are-best

SQL Study

• get the unique ratings from film column: 

SELECT DISTINCT(rating) FROM film;

• get how many unique ratings from film column: 

SELECT COUNT(DISTINCT(rating)) FROM film;

Precision/Recall/True positive rate/True Negative Rate

In machine learning, the true positive rate, also referred to sensitivity or recall.