tiv_2015 values that appear more than once in the table.lat and lon combinations (unique locations).insurance table to include only rows where tiv_2015 is in the list from step 1 and the lat and lon combination is in the list from step 2.tiv_2016 values of the filtered rows and round the result to two decimal places.erDiagram
Insurance {
int pid PK
float tiv_2015
float tiv_2016
float lat
float lon
}