Project

General

Profile

Download (38.7 KB)

Support #837 » update_sql_query.txt

Leo Esaki, 04/04/2025 02:49 PM

 
UPDATE auto_premium
SET
pd = CASE acv
WHEN 1000 THEN 0.31
WHEN 1500 THEN 0.5
WHEN 2000 THEN 0.64
WHEN 2500 THEN 0.78
WHEN 3000 THEN 0.92
WHEN 3500 THEN 1.04
WHEN 4000 THEN 1.16
WHEN 4500 THEN 1.216
WHEN 5000 THEN 1.26
WHEN 5500 THEN 1.35
WHEN 6000 THEN 1.44
WHEN 6500 THEN 1.53
WHEN 7000 THEN 1.62
WHEN 7500 THEN 1.692
WHEN 8000 THEN 1.764
WHEN 8500 THEN 1.836
WHEN 9000 THEN 1.908
WHEN 9500 THEN 1.98
WHEN 10000 THEN 2.052
WHEN 10500 THEN 2.1004
WHEN 11000 THEN 2.1472
WHEN 11500 THEN 2.1924
WHEN 12000 THEN 2.236
WHEN 12500 THEN 2.278
WHEN 13000 THEN 2.346
WHEN 13500 THEN 2.414
WHEN 14000 THEN 2.482
WHEN 14500 THEN 2.55
WHEN 15000 THEN 2.618
WHEN 15500 THEN 2.686
WHEN 16000 THEN 2.754
WHEN 16500 THEN 2.822
WHEN 17000 THEN 2.89
WHEN 17500 THEN 2.958
WHEN 18000 THEN 3.0175
WHEN 18500 THEN 3.094
WHEN 19000 THEN 3.162
WHEN 19500 THEN 3.23
WHEN 20000 THEN 3.298
WHEN 20500 THEN 3.366
WHEN 21000 THEN 3.434
WHEN 21500 THEN 3.502
WHEN 22000 THEN 3.57
WHEN 22500 THEN 3.638
WHEN 23000 THEN 3.706
WHEN 23500 THEN 3.774
WHEN 24000 THEN 3.842
WHEN 24500 THEN 3.91
WHEN 25000 THEN 3.978
WHEN 25500 THEN 4.046
WHEN 26000 THEN 4.114
WHEN 26500 THEN 4.182
WHEN 27000 THEN 4.25
WHEN 27500 THEN 4.318
WHEN 28000 THEN 4.386
WHEN 28500 THEN 4.454
WHEN 29000 THEN 4.522
WHEN 29500 THEN 4.59
WHEN 30000 THEN 5.48
WHEN 30500 THEN 5.7268
WHEN 31000 THEN 5.8092
WHEN 31500 THEN 5.8916
WHEN 32000 THEN 5.974
WHEN 32500 THEN 6.0564
WHEN 33000 THEN 6.1388
WHEN 33500 THEN 6.2212
WHEN 34000 THEN 6.3036
WHEN 34500 THEN 6.386
WHEN 35000 THEN 6.4684
WHEN 35500 THEN 6.5508
WHEN 36000 THEN 6.6332
WHEN 36500 THEN 6.7156
WHEN 37000 THEN 6.798
WHEN 37500 THEN 6.8804
WHEN 38000 THEN 6.9628
WHEN 38500 THEN 7.0452
WHEN 39000 THEN 7.1276
WHEN 39500 THEN 7.21
WHEN 40000 THEN 7.2924
WHEN 40500 THEN 7.3748
WHEN 41000 THEN 7.4572
WHEN 41500 THEN 7.5396
WHEN 42000 THEN 7.622
WHEN 42500 THEN 7.7044
WHEN 43000 THEN 7.7868
WHEN 43500 THEN 7.8692
WHEN 44000 THEN 7.9516
WHEN 44500 THEN 8.034
WHEN 45000 THEN 8.1164
WHEN 45500 THEN 8.1988
WHEN 46000 THEN 8.2812
WHEN 46500 THEN 8.3636
WHEN 47000 THEN 8.446
WHEN 47500 THEN 8.5284
WHEN 48000 THEN 8.6108
WHEN 48500 THEN 8.6932
WHEN 49000 THEN 8.7756
WHEN 49500 THEN 8.858
WHEN 50000 THEN 9.114
WHEN 50500 THEN 9.198
WHEN 51000 THEN 9.282
WHEN 51500 THEN 9.366
WHEN 52000 THEN 9.45
WHEN 52500 THEN 9.534
WHEN 53000 THEN 9.618
WHEN 53500 THEN 9.702
WHEN 54000 THEN 9.786
WHEN 54500 THEN 9.87
WHEN 55000 THEN 9.954
WHEN 55500 THEN 10.038
WHEN 56000 THEN 10.122
WHEN 56500 THEN 10.206
WHEN 57000 THEN 10.29
WHEN 57500 THEN 10.374
WHEN 58000 THEN 10.458
WHEN 58500 THEN 10.542
WHEN 59000 THEN 10.626
WHEN 59500 THEN 10.71
WHEN 60000 THEN 10.9996
WHEN 60500 THEN 11.0852
WHEN 61000 THEN 11.1708
WHEN 61500 THEN 11.2564
WHEN 62000 THEN 11.342
WHEN 62500 THEN 11.4276
WHEN 63000 THEN 11.5132
WHEN 63500 THEN 11.5988
WHEN 64000 THEN 11.6844
WHEN 64500 THEN 11.77
WHEN 65000 THEN 11.8556
WHEN 65500 THEN 11.9412
WHEN 66000 THEN 12.0268
WHEN 66500 THEN 12.1124
WHEN 67000 THEN 12.198
WHEN 67500 THEN 12.2836
WHEN 68000 THEN 12.3692
WHEN 68500 THEN 12.4548
WHEN 69000 THEN 12.5404
WHEN 69500 THEN 12.626
WHEN 70000 THEN 12.8304
WHEN 70500 THEN 12.9168
WHEN 71000 THEN 13.0032
WHEN 71500 THEN 13.0896
WHEN 72000 THEN 13.176
WHEN 72500 THEN 13.2624
WHEN 73000 THEN 13.3488
WHEN 73500 THEN 13.4352
WHEN 74000 THEN 13.5216
WHEN 74500 THEN 13.608
WHEN 75000 THEN 13.6944
WHEN 75500 THEN 13.7808
WHEN 76000 THEN 13.8672
WHEN 76500 THEN 13.9536
WHEN 77000 THEN 14.04
WHEN 77500 THEN 14.1264
WHEN 78000 THEN 14.2128
WHEN 78500 THEN 14.2992
WHEN 79000 THEN 14.3856
WHEN 79500 THEN 14.472
WHEN 80000 THEN 14.5584
WHEN 80500 THEN 14.6448
WHEN 81000 THEN 14.7312
WHEN 81500 THEN 14.8176
WHEN 82000 THEN 14.904
WHEN 82500 THEN 14.9904
WHEN 83000 THEN 15.0768
WHEN 83500 THEN 15.1632
WHEN 84000 THEN 15.2496
WHEN 84500 THEN 15.336
WHEN 85000 THEN 15.4224
WHEN 85500 THEN 15.5088
WHEN 86000 THEN 15.5952
WHEN 86500 THEN 15.6816
WHEN 87000 THEN 15.768
WHEN 87500 THEN 15.8544
WHEN 88000 THEN 15.9408
WHEN 88500 THEN 16.0272
WHEN 89000 THEN 16.1136
WHEN 89500 THEN 16.2
WHEN 90000 THEN 16.2864
WHEN 90500 THEN 16.3728
WHEN 91000 THEN 16.4592
WHEN 91500 THEN 16.5456
WHEN 92000 THEN 16.632
WHEN 92500 THEN 16.7184
WHEN 93000 THEN 16.8048
WHEN 93500 THEN 16.8912
WHEN 94000 THEN 16.9776
WHEN 94500 THEN 17.064
WHEN 95000 THEN 17.1504
WHEN 95500 THEN 17.2368
WHEN 96000 THEN 17.3232
WHEN 96500 THEN 17.4096
WHEN 97000 THEN 17.496
WHEN 97500 THEN 17.5824
WHEN 98000 THEN 17.6688
WHEN 98500 THEN 17.7552
WHEN 99000 THEN 17.8416
WHEN 99500 THEN 17.928
WHEN 100000 THEN 18.0144
WHEN 100500 THEN 18.1008
WHEN 101000 THEN 18.1872
WHEN 101500 THEN 18.2736
WHEN 102000 THEN 18.36
WHEN 102500 THEN 18.4464
WHEN 103000 THEN 18.5328
WHEN 103500 THEN 18.6192
WHEN 104000 THEN 18.7056
WHEN 104500 THEN 18.792
WHEN 105000 THEN 18.8784
WHEN 105500 THEN 18.9648
WHEN 106000 THEN 19.0512
WHEN 106500 THEN 19.1376
WHEN 107000 THEN 19.224
WHEN 107500 THEN 19.3104
WHEN 108000 THEN 19.3968
WHEN 108500 THEN 19.4832
WHEN 109000 THEN 19.5696
WHEN 109500 THEN 19.656
WHEN 110000 THEN 19.7424
WHEN 110500 THEN 19.8288
WHEN 111000 THEN 19.9152
WHEN 111500 THEN 20.0016
WHEN 112000 THEN 20.088
WHEN 112500 THEN 20.1744
WHEN 113000 THEN 20.2608
WHEN 113500 THEN 20.3472
WHEN 114000 THEN 20.4336
WHEN 114500 THEN 20.52
WHEN 115000 THEN 20.6064
WHEN 115500 THEN 20.6928
WHEN 116000 THEN 20.7792
WHEN 116500 THEN 20.8656
WHEN 117000 THEN 20.952
WHEN 117500 THEN 21.0384
WHEN 118000 THEN 21.1248
WHEN 118500 THEN 21.2112
WHEN 119000 THEN 21.2976
WHEN 119500 THEN 21.384
WHEN 120000 THEN 21.4704
WHEN 120500 THEN 21.5568
WHEN 121000 THEN 21.6432
WHEN 121500 THEN 21.7296
WHEN 122000 THEN 21.816
WHEN 122500 THEN 21.9024
WHEN 123000 THEN 21.9888
WHEN 123500 THEN 22.0752
WHEN 124000 THEN 22.1616
WHEN 124500 THEN 22.248
WHEN 125000 THEN 22.3344
WHEN 125500 THEN 22.4208
WHEN 126000 THEN 22.5072
WHEN 126500 THEN 22.5936
WHEN 127000 THEN 22.68
WHEN 127500 THEN 22.7664
WHEN 128000 THEN 22.8528
WHEN 128500 THEN 22.9392
WHEN 129000 THEN 23.0256
WHEN 129500 THEN 23.112
WHEN 130000 THEN 23.1984
WHEN 130500 THEN 23.2848
WHEN 131000 THEN 23.3712
WHEN 131500 THEN 23.4576
WHEN 132000 THEN 23.544
WHEN 132500 THEN 23.6304
WHEN 133000 THEN 23.7168
WHEN 133500 THEN 23.8032
WHEN 134000 THEN 23.8896
WHEN 134500 THEN 23.976
WHEN 135000 THEN 24.0624
WHEN 135500 THEN 24.1488
WHEN 136000 THEN 24.2352
WHEN 136500 THEN 24.3216
WHEN 137000 THEN 24.408
WHEN 137500 THEN 24.4944
WHEN 138000 THEN 24.5808
WHEN 138500 THEN 24.6672
WHEN 139000 THEN 24.7536
WHEN 139500 THEN 24.84
WHEN 140000 THEN 24.9264
WHEN 140500 THEN 25.0128
WHEN 141000 THEN 25.0992
WHEN 141500 THEN 25.1856
WHEN 142000 THEN 25.272
WHEN 142500 THEN 25.3584
WHEN 143000 THEN 25.4448
WHEN 143500 THEN 25.5312
WHEN 144000 THEN 25.6176
WHEN 144500 THEN 25.704
WHEN 145000 THEN 25.7904
WHEN 145500 THEN 25.8768
WHEN 146000 THEN 25.9632
WHEN 146500 THEN 26.0496
WHEN 147000 THEN 26.136
WHEN 147500 THEN 26.2224
WHEN 148000 THEN 26.3088
WHEN 148500 THEN 26.3952
WHEN 149000 THEN 26.4816
WHEN 149500 THEN 26.568
WHEN 150000 THEN 26.6544
WHEN 150500 THEN 26.7408
WHEN 151000 THEN 26.8272
WHEN 151500 THEN 26.9136
WHEN 152000 THEN 27.0
WHEN 152500 THEN 27.0864
WHEN 153000 THEN 27.1728
WHEN 153500 THEN 27.2592
WHEN 154000 THEN 27.3456
WHEN 154500 THEN 27.432
WHEN 155000 THEN 27.5184
WHEN 155500 THEN 27.6048
WHEN 156000 THEN 27.6912
WHEN 156500 THEN 27.7776
WHEN 157000 THEN 27.864
WHEN 157500 THEN 27.9504
WHEN 158000 THEN 28.0368
WHEN 158500 THEN 28.1232
WHEN 159000 THEN 28.2096
WHEN 159500 THEN 28.296
WHEN 160000 THEN 28.3824
WHEN 160500 THEN 28.4688
WHEN 161000 THEN 28.5552
WHEN 161500 THEN 28.6416
WHEN 162000 THEN 28.728
WHEN 162500 THEN 28.8144
WHEN 163000 THEN 28.9008
WHEN 163500 THEN 28.9872
WHEN 164000 THEN 29.0736
WHEN 164500 THEN 29.16
WHEN 165000 THEN 29.2464
WHEN 165500 THEN 29.3328
WHEN 166000 THEN 29.4192
WHEN 166500 THEN 29.5056
WHEN 167000 THEN 29.592
WHEN 167500 THEN 29.6784
WHEN 168000 THEN 29.7648
WHEN 168500 THEN 29.8512
WHEN 169000 THEN 29.9376
WHEN 169500 THEN 30.024
WHEN 170000 THEN 30.1104
WHEN 170500 THEN 30.1968
WHEN 171000 THEN 30.2832
WHEN 171500 THEN 30.3696
WHEN 172000 THEN 30.456
WHEN 172500 THEN 30.5424
WHEN 173000 THEN 30.6288
WHEN 173500 THEN 30.7152
WHEN 174000 THEN 30.8016
WHEN 174500 THEN 30.888
WHEN 175000 THEN 30.9744
WHEN 175500 THEN 31.0608
WHEN 176000 THEN 31.1472
WHEN 176500 THEN 31.2336
WHEN 177000 THEN 31.32
WHEN 177500 THEN 31.4064
WHEN 178000 THEN 31.4928
WHEN 178500 THEN 31.5792
WHEN 179000 THEN 31.6656
WHEN 179500 THEN 31.752
WHEN 180000 THEN 31.8384
WHEN 180500 THEN 31.9248
WHEN 181000 THEN 32.0112
WHEN 181500 THEN 32.0976
WHEN 182000 THEN 32.184
WHEN 182500 THEN 32.2704
WHEN 183000 THEN 32.3568
WHEN 183500 THEN 32.4432
WHEN 184000 THEN 32.5296
WHEN 184500 THEN 32.616
WHEN 185000 THEN 32.7024
WHEN 185500 THEN 32.7888
WHEN 186000 THEN 32.8752
WHEN 186500 THEN 32.9616
WHEN 187000 THEN 33.048
WHEN 187500 THEN 33.1344
WHEN 188000 THEN 33.2208
WHEN 188500 THEN 33.3072
WHEN 189000 THEN 33.3936
WHEN 189500 THEN 33.48
WHEN 190000 THEN 33.5664
WHEN 190500 THEN 33.6528
WHEN 191000 THEN 33.7392
WHEN 191500 THEN 33.8256
WHEN 192000 THEN 33.912
WHEN 192500 THEN 33.9984
WHEN 193000 THEN 34.0848
WHEN 193500 THEN 34.1712
WHEN 194000 THEN 34.2576
WHEN 194500 THEN 34.344
WHEN 195000 THEN 34.4304
WHEN 195500 THEN 34.5168
WHEN 196000 THEN 34.6032
WHEN 196500 THEN 34.6896
WHEN 197000 THEN 34.776
WHEN 197500 THEN 34.8624
WHEN 198000 THEN 34.9488
WHEN 198500 THEN 35.0352
WHEN 199000 THEN 35.1216
WHEN 199500 THEN 35.208
WHEN 200000 THEN 35.2944
WHEN 200500 THEN 35.3808
WHEN 201000 THEN 35.4672
WHEN 201500 THEN 35.5536
WHEN 202000 THEN 35.64
WHEN 202500 THEN 35.7264
WHEN 203000 THEN 35.8128
WHEN 203500 THEN 35.8992
WHEN 204000 THEN 35.9856
WHEN 204500 THEN 36.072
WHEN 205000 THEN 36.1584
WHEN 205500 THEN 36.2448
WHEN 206000 THEN 36.3312
WHEN 206500 THEN 36.4176
WHEN 207000 THEN 36.504
WHEN 207500 THEN 36.5904
WHEN 208000 THEN 36.6768
WHEN 208500 THEN 36.7632
WHEN 209000 THEN 36.8496
WHEN 209500 THEN 36.936
WHEN 210000 THEN 37.0224
WHEN 210500 THEN 37.1088
WHEN 211000 THEN 37.1952
WHEN 211500 THEN 37.2816
WHEN 212000 THEN 37.368
WHEN 212500 THEN 37.4544
WHEN 213000 THEN 37.5408
WHEN 213500 THEN 37.6272
WHEN 214000 THEN 37.7136
WHEN 214500 THEN 37.8
WHEN 215000 THEN 37.8864
WHEN 215500 THEN 37.9728
WHEN 216000 THEN 38.0592
WHEN 216500 THEN 38.1456
WHEN 217000 THEN 38.232
WHEN 217500 THEN 38.3184
WHEN 218000 THEN 38.4048
WHEN 218500 THEN 38.4912
WHEN 219000 THEN 38.5776
WHEN 219500 THEN 38.664
WHEN 220000 THEN 38.7504
WHEN 220500 THEN 38.8368
WHEN 221000 THEN 38.9232
WHEN 221500 THEN 39.0096
WHEN 222000 THEN 39.096
WHEN 222500 THEN 39.1824
WHEN 223000 THEN 39.2688
WHEN 223500 THEN 39.3552
WHEN 224000 THEN 39.4416
WHEN 224500 THEN 39.528
WHEN 225000 THEN 39.6144
WHEN 225500 THEN 39.7008
WHEN 226000 THEN 39.7872
WHEN 226500 THEN 39.8736
WHEN 227000 THEN 39.96
WHEN 227500 THEN 40.0464
WHEN 228000 THEN 40.1328
WHEN 228500 THEN 40.2192
WHEN 229000 THEN 40.3056
WHEN 229500 THEN 40.392
WHEN 230000 THEN 40.4784
WHEN 230500 THEN 40.5648
WHEN 231000 THEN 40.6512
WHEN 231500 THEN 40.7376
WHEN 232000 THEN 40.824
WHEN 232500 THEN 40.9104
WHEN 233000 THEN 40.9968
WHEN 233500 THEN 41.0832
WHEN 234000 THEN 41.1696
WHEN 234500 THEN 41.256
WHEN 235000 THEN 41.3424
WHEN 235500 THEN 41.4288
WHEN 236000 THEN 41.5152
WHEN 236500 THEN 41.6016
WHEN 237000 THEN 41.688
WHEN 237500 THEN 41.7744
WHEN 238000 THEN 41.8608
WHEN 238500 THEN 41.9472
WHEN 239000 THEN 42.0336
WHEN 239500 THEN 42.12
WHEN 240000 THEN 42.2064
WHEN 240500 THEN 42.2928
WHEN 241000 THEN 42.3792
WHEN 241500 THEN 42.4656
WHEN 242000 THEN 42.552
WHEN 242500 THEN 42.6384
WHEN 243000 THEN 42.7248
WHEN 243500 THEN 42.8112
WHEN 244000 THEN 42.8976
WHEN 244500 THEN 42.984
WHEN 245000 THEN 43.0704
WHEN 245500 THEN 43.1568
WHEN 246000 THEN 43.2432
WHEN 246500 THEN 43.3296
WHEN 247000 THEN 43.416
WHEN 247500 THEN 43.5024
WHEN 248000 THEN 43.5888
WHEN 248500 THEN 43.6752
WHEN 249000 THEN 43.7616
WHEN 249500 THEN 43.848
WHEN 250000 THEN 43.9344
WHEN 250500 THEN 44.0208
WHEN 251000 THEN 44.1072
WHEN 251500 THEN 44.1936
WHEN 252000 THEN 44.28
WHEN 252500 THEN 44.3664
WHEN 253000 THEN 44.4528
WHEN 253500 THEN 44.5392
WHEN 254000 THEN 44.6256
WHEN 254500 THEN 44.712
WHEN 255000 THEN 44.7984
WHEN 255500 THEN 44.8848
WHEN 256000 THEN 44.9712
WHEN 256500 THEN 45.0576
WHEN 257000 THEN 45.144
WHEN 257500 THEN 45.2304
WHEN 258000 THEN 45.3168
WHEN 258500 THEN 45.4032
WHEN 259000 THEN 45.4896
WHEN 259500 THEN 45.576
WHEN 260000 THEN 45.6624
WHEN 260500 THEN 45.7488
WHEN 261000 THEN 45.8352
WHEN 261500 THEN 45.9216
WHEN 262000 THEN 46.008
WHEN 262500 THEN 46.0944
WHEN 263000 THEN 46.1808
WHEN 263500 THEN 46.2672
WHEN 264000 THEN 46.3536
WHEN 264500 THEN 46.44
WHEN 265000 THEN 46.5264
WHEN 265500 THEN 46.6128
WHEN 266000 THEN 46.6992
WHEN 266500 THEN 46.7856
WHEN 267000 THEN 46.872
WHEN 267500 THEN 46.9584
WHEN 268000 THEN 47.0448
WHEN 268500 THEN 47.1312
WHEN 269000 THEN 47.2176
WHEN 269500 THEN 47.304
WHEN 270000 THEN 47.3904
WHEN 270500 THEN 47.4768
WHEN 271000 THEN 47.5632
WHEN 271500 THEN 47.6496
WHEN 272000 THEN 47.736
WHEN 272500 THEN 47.8224
WHEN 273000 THEN 47.9088
WHEN 273500 THEN 47.9952
WHEN 274000 THEN 48.0816
WHEN 274500 THEN 48.168
WHEN 275000 THEN 48.2544
WHEN 275500 THEN 48.3408
WHEN 276000 THEN 48.4272
WHEN 276500 THEN 48.5136
WHEN 277000 THEN 48.6
WHEN 277500 THEN 48.6864
WHEN 278000 THEN 48.7728
WHEN 278500 THEN 48.8592
WHEN 279000 THEN 48.9456
WHEN 279500 THEN 49.032
WHEN 280000 THEN 49.1184
WHEN 280500 THEN 49.2048
WHEN 281000 THEN 49.2912
WHEN 281500 THEN 49.3776
WHEN 282000 THEN 49.464
WHEN 282500 THEN 49.5504
WHEN 283000 THEN 49.6368
WHEN 283500 THEN 49.7232
WHEN 284000 THEN 49.8096
WHEN 284500 THEN 49.896
WHEN 285000 THEN 49.9824
WHEN 285500 THEN 50.0688
WHEN 286000 THEN 50.1552
WHEN 286500 THEN 50.2416
WHEN 287000 THEN 50.328
WHEN 287500 THEN 50.4144
WHEN 288000 THEN 50.5008
WHEN 288500 THEN 50.5872
WHEN 289000 THEN 50.6736
WHEN 289500 THEN 50.76
WHEN 290000 THEN 50.8464
WHEN 290500 THEN 50.9328
WHEN 291000 THEN 51.0192
WHEN 291500 THEN 51.1056
WHEN 292000 THEN 51.192
WHEN 292500 THEN 51.2784
WHEN 293000 THEN 51.3648
WHEN 293500 THEN 51.4512
WHEN 294000 THEN 51.5376
WHEN 294500 THEN 51.624
WHEN 295000 THEN 51.7104
WHEN 295500 THEN 51.7968
WHEN 296000 THEN 51.8832
WHEN 296500 THEN 51.9696
WHEN 297000 THEN 52.056
WHEN 297500 THEN 52.1424
WHEN 298000 THEN 52.2288
WHEN 298500 THEN 52.3152
WHEN 299000 THEN 52.4016
WHEN 299500 THEN 52.488
ELSE pd
END,
tt = CASE acv
WHEN 1000 THEN 0.17
WHEN 1500 THEN 0.25
WHEN 2000 THEN 0.32
WHEN 2500 THEN 0.39
WHEN 3000 THEN 0.46
WHEN 3500 THEN 0.52
WHEN 4000 THEN 0.58
WHEN 4500 THEN 0.608
WHEN 5000 THEN 0.63
WHEN 5500 THEN 0.675
WHEN 6000 THEN 0.72
WHEN 6500 THEN 0.765
WHEN 7000 THEN 0.81
WHEN 7500 THEN 0.846
WHEN 8000 THEN 0.882
WHEN 8500 THEN 0.918
WHEN 9000 THEN 0.954
WHEN 9500 THEN 0.99
WHEN 10000 THEN 1.0602
WHEN 10500 THEN 1.062
WHEN 11000 THEN 1.0858
WHEN 11500 THEN 1.1088
WHEN 12000 THEN 1.131
WHEN 12500 THEN 1.1524
WHEN 13000 THEN 1.173
WHEN 13500 THEN 1.207
WHEN 14000 THEN 1.241
WHEN 14500 THEN 1.275
WHEN 15000 THEN 1.309
WHEN 15500 THEN 1.343
WHEN 16000 THEN 1.377
WHEN 16500 THEN 1.411
WHEN 17000 THEN 1.445
WHEN 17500 THEN 1.479
WHEN 18000 THEN 1.513
WHEN 18500 THEN 1.547
WHEN 19000 THEN 1.581
WHEN 19500 THEN 1.615
WHEN 20000 THEN 1.649
WHEN 20500 THEN 1.683
WHEN 21000 THEN 1.717
WHEN 21500 THEN 1.751
WHEN 22000 THEN 1.785
WHEN 22500 THEN 1.819
WHEN 23000 THEN 1.853
WHEN 23500 THEN 1.887
WHEN 24000 THEN 1.921
WHEN 24500 THEN 1.955
WHEN 25000 THEN 1.989
WHEN 25500 THEN 2.023
WHEN 26000 THEN 2.057
WHEN 26500 THEN 2.091
WHEN 27000 THEN 2.125
WHEN 27500 THEN 2.159
WHEN 28000 THEN 2.193
WHEN 28500 THEN 2.227
WHEN 29000 THEN 2.261
WHEN 29500 THEN 2.295
WHEN 30000 THEN 2.329
WHEN 30500 THEN 2.78
WHEN 31000 THEN 2.9046
WHEN 31500 THEN 2.9458
WHEN 32000 THEN 2.987
WHEN 32500 THEN 3.0282
WHEN 33000 THEN 3.0694
WHEN 33500 THEN 3.1106
WHEN 34000 THEN 3.1518
WHEN 34500 THEN 3.193
WHEN 35000 THEN 3.2342
WHEN 35500 THEN 3.2754
WHEN 36000 THEN 3.3166
WHEN 36500 THEN 3.3578
WHEN 37000 THEN 3.399
WHEN 37500 THEN 3.4402
WHEN 38000 THEN 3.4814
WHEN 38500 THEN 3.5226
WHEN 39000 THEN 3.5638
WHEN 39500 THEN 3.605
WHEN 40000 THEN 3.6462
WHEN 40500 THEN 3.6874
WHEN 41000 THEN 3.7286
WHEN 41500 THEN 3.7698
WHEN 42000 THEN 3.811
WHEN 42500 THEN 3.8522
WHEN 43000 THEN 3.8934
WHEN 43500 THEN 3.9346
WHEN 44000 THEN 3.9758
WHEN 44500 THEN 4.017
WHEN 45000 THEN 4.0582
WHEN 45500 THEN 4.0994
WHEN 46000 THEN 4.1406
WHEN 46500 THEN 4.1818
WHEN 47000 THEN 4.223
WHEN 47500 THEN 4.2642
WHEN 48000 THEN 4.3054
WHEN 48500 THEN 4.3466
WHEN 49000 THEN 4.3878
WHEN 49500 THEN 4.429
WHEN 50000 THEN 4.557
WHEN 50500 THEN 4.599
WHEN 51000 THEN 4.641
WHEN 51500 THEN 4.683
WHEN 52000 THEN 4.725
WHEN 52500 THEN 4.767
WHEN 53000 THEN 4.809
WHEN 53500 THEN 4.851
WHEN 54000 THEN 4.893
WHEN 54500 THEN 4.935
WHEN 55000 THEN 4.977
WHEN 55500 THEN 5.019
WHEN 56000 THEN 5.061
WHEN 56500 THEN 5.103
WHEN 57000 THEN 5.145
WHEN 57500 THEN 5.187
WHEN 58000 THEN 5.229
WHEN 58500 THEN 5.271
WHEN 59000 THEN 5.313
WHEN 59500 THEN 5.355
WHEN 60000 THEN 5.4998
WHEN 60500 THEN 5.5426
WHEN 61000 THEN 5.5854
WHEN 61500 THEN 5.6282
WHEN 62000 THEN 5.671
WHEN 62500 THEN 5.7138
WHEN 63000 THEN 5.7566
WHEN 63500 THEN 5.7994
WHEN 64000 THEN 5.8422
WHEN 64500 THEN 5.885
WHEN 65000 THEN 5.9278
WHEN 65500 THEN 5.9706
WHEN 66000 THEN 6.0134
WHEN 66500 THEN 6.0562
WHEN 67000 THEN 6.099
WHEN 67500 THEN 6.1418
WHEN 68000 THEN 6.1846
WHEN 68500 THEN 6.2274
WHEN 69000 THEN 6.2702
WHEN 69500 THEN 6.372
WHEN 70000 THEN 6.4152
WHEN 70500 THEN 6.4584
WHEN 71000 THEN 6.5016
WHEN 71500 THEN 6.5448
WHEN 72000 THEN 6.588
WHEN 72500 THEN 6.6312
WHEN 73000 THEN 6.6744
WHEN 73500 THEN 6.7176
WHEN 74000 THEN 6.7608
WHEN 74500 THEN 6.804
WHEN 75000 THEN 6.8472
WHEN 75500 THEN 6.8904
WHEN 76000 THEN 6.9336
WHEN 76500 THEN 6.9768
WHEN 77000 THEN 7.02
WHEN 77500 THEN 7.0632
WHEN 78000 THEN 7.1064
WHEN 78500 THEN 7.1496
WHEN 79000 THEN 7.1928
WHEN 79500 THEN 7.236
WHEN 80000 THEN 7.2792
WHEN 80500 THEN 7.3224
WHEN 81000 THEN 7.3656
WHEN 81500 THEN 7.4088
WHEN 82000 THEN 7.452
WHEN 82500 THEN 7.4952
WHEN 83000 THEN 7.5384
WHEN 83500 THEN 7.5816
WHEN 84000 THEN 7.6248
WHEN 84500 THEN 7.668
WHEN 85000 THEN 7.7112
WHEN 85500 THEN 7.7544
WHEN 86000 THEN 7.7976
WHEN 86500 THEN 7.8408
WHEN 87000 THEN 7.884
WHEN 87500 THEN 7.9272
WHEN 88000 THEN 7.9704
WHEN 88500 THEN 8.0136
WHEN 89000 THEN 8.0568
WHEN 89500 THEN 8.1
WHEN 90000 THEN 8.1432
WHEN 90500 THEN 8.1864
WHEN 91000 THEN 8.2296
WHEN 91500 THEN 8.2728
WHEN 92000 THEN 8.316
WHEN 92500 THEN 8.3592
WHEN 93000 THEN 8.4024
WHEN 93500 THEN 8.4456
WHEN 94000 THEN 8.4888
WHEN 94500 THEN 8.532
WHEN 95000 THEN 8.5752
WHEN 95500 THEN 8.6184
WHEN 96000 THEN 8.6616
WHEN 96500 THEN 8.7048
WHEN 97000 THEN 8.748
WHEN 97500 THEN 8.7912
WHEN 98000 THEN 8.8344
WHEN 98500 THEN 8.8776
WHEN 99000 THEN 8.9208
WHEN 99500 THEN 8.964
WHEN 100000 THEN 9.0072
WHEN 100500 THEN 9.0504
WHEN 101000 THEN 9.0936
WHEN 101500 THEN 9.1368
WHEN 102000 THEN 9.18
WHEN 102500 THEN 9.2232
WHEN 103000 THEN 9.2664
WHEN 103500 THEN 9.3096
WHEN 104000 THEN 9.3528
WHEN 104500 THEN 9.396
WHEN 105000 THEN 9.4392
WHEN 105500 THEN 9.4824
WHEN 106000 THEN 9.5256
WHEN 106500 THEN 9.5688
WHEN 107000 THEN 9.612
WHEN 107500 THEN 9.6552
WHEN 108000 THEN 9.6984
WHEN 108500 THEN 9.7416
WHEN 109000 THEN 9.7848
WHEN 109500 THEN 9.828
WHEN 110000 THEN 9.8712
WHEN 110500 THEN 9.9144
WHEN 111000 THEN 9.9576
WHEN 111500 THEN 10.0008
WHEN 112000 THEN 10.044
WHEN 112500 THEN 10.0872
WHEN 113000 THEN 10.1304
WHEN 113500 THEN 10.1736
WHEN 114000 THEN 10.2168
WHEN 114500 THEN 10.26
WHEN 115000 THEN 10.3032
WHEN 115500 THEN 10.3464
WHEN 116000 THEN 10.3896
WHEN 116500 THEN 10.4328
WHEN 117000 THEN 10.476
WHEN 117500 THEN 10.5192
WHEN 118000 THEN 10.5624
WHEN 118500 THEN 10.6056
WHEN 119000 THEN 10.6488
WHEN 119500 THEN 10.692
WHEN 120000 THEN 10.7352
WHEN 120500 THEN 10.7784
WHEN 121000 THEN 10.8216
WHEN 121500 THEN 10.8648
WHEN 122000 THEN 10.908
WHEN 122500 THEN 10.9512
WHEN 123000 THEN 10.9944
WHEN 123500 THEN 11.0376
WHEN 124000 THEN 11.0808
WHEN 124500 THEN 11.124
WHEN 125000 THEN 11.1672
WHEN 125500 THEN 11.2104
WHEN 126000 THEN 11.2536
WHEN 126500 THEN 11.2968
WHEN 127000 THEN 11.34
WHEN 127500 THEN 11.3832
WHEN 128000 THEN 11.4264
WHEN 128500 THEN 11.4696
WHEN 129000 THEN 11.5128
WHEN 129500 THEN 11.556
WHEN 130000 THEN 11.5992
WHEN 130500 THEN 11.6424
WHEN 131000 THEN 11.6856
WHEN 131500 THEN 11.7288
WHEN 132000 THEN 11.772
WHEN 132500 THEN 11.8152
WHEN 133000 THEN 11.8584
WHEN 133500 THEN 11.9016
WHEN 134000 THEN 11.9448
WHEN 134500 THEN 11.988
WHEN 135000 THEN 12.0312
WHEN 135500 THEN 12.0744
WHEN 136000 THEN 12.1176
WHEN 136500 THEN 12.1608
WHEN 137000 THEN 12.204
WHEN 137500 THEN 12.2472
WHEN 138000 THEN 12.2904
WHEN 138500 THEN 12.3336
WHEN 139000 THEN 12.3768
WHEN 139500 THEN 12.42
WHEN 140000 THEN 12.4632
WHEN 140500 THEN 12.5064
WHEN 141000 THEN 12.5496
WHEN 141500 THEN 12.5928
WHEN 142000 THEN 12.636
WHEN 142500 THEN 12.6792
WHEN 143000 THEN 12.7224
WHEN 143500 THEN 12.7656
WHEN 144000 THEN 12.8088
WHEN 144500 THEN 12.852
WHEN 145000 THEN 12.8952
WHEN 145500 THEN 12.9384
WHEN 146000 THEN 12.9816
WHEN 146500 THEN 13.0248
WHEN 147000 THEN 13.068
WHEN 147500 THEN 13.1112
WHEN 148000 THEN 13.1544
WHEN 148500 THEN 13.1976
WHEN 149000 THEN 13.2408
WHEN 149500 THEN 13.284
WHEN 150000 THEN 13.3272
WHEN 150500 THEN 13.3704
WHEN 151000 THEN 13.4136
WHEN 151500 THEN 13.4568
WHEN 152000 THEN 13.5
WHEN 152500 THEN 13.5432
WHEN 153000 THEN 13.5864
WHEN 153500 THEN 13.6296
WHEN 154000 THEN 13.6728
WHEN 154500 THEN 13.716
WHEN 155000 THEN 13.7592
WHEN 155500 THEN 13.8024
WHEN 156000 THEN 13.8456
WHEN 156500 THEN 13.8888
WHEN 157000 THEN 13.932
WHEN 157500 THEN 13.9752
WHEN 158000 THEN 14.0184
WHEN 158500 THEN 14.0616
WHEN 159000 THEN 14.1048
WHEN 159500 THEN 14.148
WHEN 160000 THEN 14.1912
WHEN 160500 THEN 14.2344
WHEN 161000 THEN 14.2776
WHEN 161500 THEN 14.3208
WHEN 162000 THEN 14.364
WHEN 162500 THEN 14.4072
WHEN 163000 THEN 14.4504
WHEN 163500 THEN 14.4936
WHEN 164000 THEN 14.5368
WHEN 164500 THEN 14.58
WHEN 165000 THEN 14.6232
WHEN 165500 THEN 14.6664
WHEN 166000 THEN 14.7096
WHEN 166500 THEN 14.7528
WHEN 167000 THEN 14.796
WHEN 167500 THEN 14.8392
WHEN 168000 THEN 14.8824
WHEN 168500 THEN 14.9256
WHEN 169000 THEN 14.9688
WHEN 169500 THEN 15.012
WHEN 170000 THEN 15.0552
WHEN 170500 THEN 15.0984
WHEN 171000 THEN 15.1416
WHEN 171500 THEN 15.1848
WHEN 172000 THEN 15.228
WHEN 172500 THEN 15.2712
WHEN 173000 THEN 15.3144
WHEN 173500 THEN 15.3576
WHEN 174000 THEN 15.4008
WHEN 174500 THEN 15.444
WHEN 175000 THEN 15.4872
WHEN 175500 THEN 15.5304
WHEN 176000 THEN 15.5736
WHEN 176500 THEN 15.6168
WHEN 177000 THEN 15.66
WHEN 177500 THEN 15.7032
WHEN 178000 THEN 15.7464
WHEN 178500 THEN 15.7896
WHEN 179000 THEN 15.8328
WHEN 179500 THEN 15.876
WHEN 180000 THEN 15.9192
WHEN 180500 THEN 15.9624
WHEN 181000 THEN 16.0056
WHEN 181500 THEN 16.0488
WHEN 182000 THEN 16.092
WHEN 182500 THEN 16.1352
WHEN 183000 THEN 16.1784
WHEN 183500 THEN 16.2216
WHEN 184000 THEN 16.2648
WHEN 184500 THEN 16.308
WHEN 185000 THEN 16.3512
WHEN 185500 THEN 16.3944
WHEN 186000 THEN 16.4376
WHEN 186500 THEN 16.4808
WHEN 187000 THEN 16.524
WHEN 187500 THEN 16.5672
WHEN 188000 THEN 16.6104
WHEN 188500 THEN 16.6536
WHEN 189000 THEN 16.6968
WHEN 189500 THEN 16.74
WHEN 190000 THEN 16.7832
WHEN 190500 THEN 16.8264
WHEN 191000 THEN 16.8696
WHEN 191500 THEN 16.9128
WHEN 192000 THEN 16.956
WHEN 192500 THEN 16.9992
WHEN 193000 THEN 17.0424
WHEN 193500 THEN 17.0856
WHEN 194000 THEN 17.1288
WHEN 194500 THEN 17.172
WHEN 195000 THEN 17.2152
WHEN 195500 THEN 17.2584
WHEN 196000 THEN 17.3016
WHEN 196500 THEN 17.3448
WHEN 197000 THEN 17.388
WHEN 197500 THEN 17.4312
WHEN 198000 THEN 17.4744
WHEN 198500 THEN 17.5176
WHEN 199000 THEN 17.5608
WHEN 199500 THEN 17.604
WHEN 200000 THEN 17.6472
WHEN 200500 THEN 17.6904
WHEN 201000 THEN 17.7336
WHEN 201500 THEN 17.7768
WHEN 202000 THEN 17.82
WHEN 202500 THEN 17.8632
WHEN 203000 THEN 17.9064
WHEN 203500 THEN 17.9496
WHEN 204000 THEN 17.9928
WHEN 204500 THEN 18.036
WHEN 205000 THEN 18.0792
WHEN 205500 THEN 18.1224
WHEN 206000 THEN 18.1656
WHEN 206500 THEN 18.2088
WHEN 207000 THEN 18.252
WHEN 207500 THEN 18.2952
WHEN 208000 THEN 18.3384
WHEN 208500 THEN 18.3816
WHEN 209000 THEN 18.4248
WHEN 209500 THEN 18.468
WHEN 210000 THEN 18.5112
WHEN 210500 THEN 18.5544
WHEN 211000 THEN 18.5976
WHEN 211500 THEN 18.6408
WHEN 212000 THEN 18.684
WHEN 212500 THEN 18.7272
WHEN 213000 THEN 18.7704
WHEN 213500 THEN 18.8136
WHEN 214000 THEN 18.8568
WHEN 214500 THEN 18.9
WHEN 215000 THEN 18.9432
WHEN 215500 THEN 18.9864
WHEN 216000 THEN 19.0296
WHEN 216500 THEN 19.0728
WHEN 217000 THEN 19.116
WHEN 217500 THEN 19.1592
WHEN 218000 THEN 19.2024
WHEN 218500 THEN 19.2456
WHEN 219000 THEN 19.2888
WHEN 219500 THEN 19.332
WHEN 220000 THEN 19.3752
WHEN 220500 THEN 19.4184
WHEN 221000 THEN 19.4616
WHEN 221500 THEN 19.5048
WHEN 222000 THEN 19.548
WHEN 222500 THEN 19.5912
WHEN 223000 THEN 19.6344
WHEN 223500 THEN 19.6776
WHEN 224000 THEN 19.7208
WHEN 224500 THEN 19.764
WHEN 225000 THEN 19.8072
WHEN 225500 THEN 19.8504
WHEN 226000 THEN 19.8936
WHEN 226500 THEN 19.9368
WHEN 227000 THEN 19.98
WHEN 227500 THEN 20.0232
WHEN 228000 THEN 20.0664
WHEN 228500 THEN 20.1096
WHEN 229000 THEN 20.1528
WHEN 229500 THEN 20.196
WHEN 230000 THEN 20.2392
WHEN 230500 THEN 20.2824
WHEN 231000 THEN 20.3256
WHEN 231500 THEN 20.3688
WHEN 232000 THEN 20.412
WHEN 232500 THEN 20.4552
WHEN 233000 THEN 20.4984
WHEN 233500 THEN 20.5416
WHEN 234000 THEN 20.5848
WHEN 234500 THEN 20.628
WHEN 235000 THEN 20.6712
WHEN 235500 THEN 20.7144
WHEN 236000 THEN 20.7576
WHEN 236500 THEN 20.8008
WHEN 237000 THEN 20.844
WHEN 237500 THEN 20.8872
WHEN 238000 THEN 20.9304
WHEN 238500 THEN 20.9736
WHEN 239000 THEN 21.0168
WHEN 239500 THEN 21.06
WHEN 240000 THEN 21.1032
WHEN 240500 THEN 21.1464
WHEN 241000 THEN 21.1896
WHEN 241500 THEN 21.2328
WHEN 242000 THEN 21.276
WHEN 242500 THEN 21.3192
WHEN 243000 THEN 21.3624
WHEN 243500 THEN 21.4056
WHEN 244000 THEN 21.4488
WHEN 244500 THEN 21.492
WHEN 245000 THEN 21.5352
WHEN 245500 THEN 21.5784
WHEN 246000 THEN 21.6216
WHEN 246500 THEN 21.6648
WHEN 247000 THEN 21.708
WHEN 247500 THEN 21.7512
WHEN 248000 THEN 21.7944
WHEN 248500 THEN 21.8376
WHEN 249000 THEN 21.8808
WHEN 249500 THEN 21.924
WHEN 250000 THEN 21.9672
WHEN 250500 THEN 22.0104
WHEN 251000 THEN 22.0536
WHEN 251500 THEN 22.0968
WHEN 252000 THEN 22.14
WHEN 252500 THEN 22.1832
WHEN 253000 THEN 22.2264
WHEN 253500 THEN 22.2696
WHEN 254000 THEN 22.3128
WHEN 254500 THEN 22.356
WHEN 255000 THEN 22.3992
WHEN 255500 THEN 22.4424
WHEN 256000 THEN 22.4856
WHEN 256500 THEN 22.5288
WHEN 257000 THEN 22.572
WHEN 257500 THEN 22.6152
WHEN 258000 THEN 22.6584
WHEN 258500 THEN 22.7016
WHEN 259000 THEN 22.7448
WHEN 259500 THEN 22.788
WHEN 260000 THEN 22.8312
WHEN 260500 THEN 22.8744
WHEN 261000 THEN 22.9176
WHEN 261500 THEN 22.9608
WHEN 262000 THEN 23.004
WHEN 262500 THEN 23.0472
WHEN 263000 THEN 23.0904
WHEN 263500 THEN 23.1336
WHEN 264000 THEN 23.1768
WHEN 264500 THEN 23.22
WHEN 265000 THEN 23.2632
WHEN 265500 THEN 23.3064
WHEN 266000 THEN 23.3496
WHEN 266500 THEN 23.3928
WHEN 267000 THEN 23.436
WHEN 267500 THEN 23.4792
WHEN 268000 THEN 23.5224
WHEN 268500 THEN 23.5656
WHEN 269000 THEN 23.6088
WHEN 269500 THEN 23.652
WHEN 270000 THEN 23.6952
WHEN 270500 THEN 23.7384
WHEN 271000 THEN 23.7816
WHEN 271500 THEN 23.8248
WHEN 272000 THEN 23.868
WHEN 272500 THEN 23.9112
WHEN 273000 THEN 23.9544
WHEN 273500 THEN 23.9976
WHEN 274000 THEN 24.0408
WHEN 274500 THEN 24.084
WHEN 275000 THEN 24.1272
WHEN 275500 THEN 24.1704
WHEN 276000 THEN 24.2136
WHEN 276500 THEN 24.2568
WHEN 277000 THEN 24.3
WHEN 277500 THEN 24.3432
WHEN 278000 THEN 24.3864
WHEN 278500 THEN 24.4296
WHEN 279000 THEN 24.4728
WHEN 279500 THEN 24.516
WHEN 280000 THEN 24.5592
WHEN 280500 THEN 24.6024
WHEN 281000 THEN 24.6456
WHEN 281500 THEN 24.6888
WHEN 282000 THEN 24.732
WHEN 282500 THEN 24.7752
WHEN 283000 THEN 24.8184
WHEN 283500 THEN 24.8616
WHEN 284000 THEN 24.9048
WHEN 284500 THEN 24.948
WHEN 285000 THEN 24.9912
WHEN 285500 THEN 25.0344
WHEN 286000 THEN 25.0776
WHEN 286500 THEN 25.1208
WHEN 287000 THEN 25.164
WHEN 287500 THEN 25.2072
WHEN 288000 THEN 25.2504
WHEN 288500 THEN 25.2936
WHEN 289000 THEN 25.3368
WHEN 289500 THEN 25.38
WHEN 290000 THEN 25.4232
WHEN 290500 THEN 25.4664
WHEN 291000 THEN 25.5096
WHEN 291500 THEN 25.5528
WHEN 292000 THEN 25.596
WHEN 292500 THEN 25.6392
WHEN 293000 THEN 25.6824
WHEN 293500 THEN 25.7256
WHEN 294000 THEN 25.7688
WHEN 294500 THEN 25.812
WHEN 295000 THEN 25.8552
WHEN 295500 THEN 25.8984
WHEN 296000 THEN 25.9416
WHEN 296500 THEN 25.9848
WHEN 297000 THEN 26.028
WHEN 297500 THEN 26.0712
WHEN 298000 THEN 26.1144
WHEN 298500 THEN 26.1576
WHEN 299000 THEN 26.2008
WHEN 299500 THEN 26.244
ELSE tt
END
WHERE underwriter_id = 3;
(2-2/4)