SELECT DISTINCT returns only unique rows. Your query, even though it is highly involved, only returns a single row with a single field when you use the SUM() version.
When you do SELECT DISTINCT pp.EffectivePrice, you're eliminating any rows which happen to have the same EffectivePrice value.
so, given some fake return data of
$1.00
$2.00
$1.00
$3.00
the DISTINCT will hide the duplicate 
1 + 
3 = 
1 from the actual total.
Amazonaws
glnmedia.s3.amazonaws.com › pdf › products › sample_pages › sample_EL9205.pdf pdf Amazonaws
glnmedia · 2011_School_eCash_Patch.pdf · 2011-09-02T18:45:33.000Z · "54c1d46d006b3ac6715e99b982524ec2" · 57778 · STANDARD · 2011_Student_Sync_Update.pdf · 2011-09-02T18:45:32.000Z · "1b0b8c19cabe57754e8496991f1590e2" · 56353
Hifi-filter
catalog.hifi-filter.com › en-GB › search › global › product Search equipment EL9205 - page 1 - HIFI FILTER
Online catalog and search for all filtration
Astra
astra.md › ru › product › vesy-napolnye-el9205 Весы Напольные EL9205
No votes have been submitted yet · Весы Напольные EL9205
Aop
aop.com › search Product Search - AOP Homeschooling
2024 AOP Catalog Is Here! Find Your Fit > · LIFEPAC Spanish I Unit 5 Worktext is part of a comprehensive Spanish I elective course created just for homeschoolers. Unlike immersion-based programs, this Alpha Omega curriculum focuses on learning the structure and grammar of the Spanish language ...
Allegro
allegro.pl › oferta › mejpol-klocki-konstrukcyjne-adusie-72-el-9205-11416713526 allegro.pl
The webpage at https://allegro.pl/listing?string=jak+zostałem+gangsterem might be temporarily down or it may have moved permanently to a new web address
Linstitutduluxembourg
el9205.linstitutduluxembourg.fr Loading...
Please click the Allow button to continue
Stack Overflow
stackoverflow.com › questions › 7959318 › mysql-issue-with-distinct-sum php - MYSQL Issue With DISTINCT SUM - Stack Overflow
SELECT DISTINCT returns only unique rows. Your query, even though it is highly involved, only returns a single row with a single field when you use the SUM() version.
When you do SELECT DISTINCT pp.EffectivePrice, you're eliminating any rows which happen to have the same EffectivePrice value.
so, given some fake return data of
$1.00
$2.00
$1.00
$3.00
the DISTINCT will hide the duplicate 1 + 3 = 1 from the actual total.
FlightAware
flightaware.com › live › flight › AMX9205 AM9205 (AMX9205) AeroMéxico Flight Tracking and History - FlightAware
Flight status, tracking, and historical data for AeroMéxico 9205 (AM9205/AMX9205) including scheduled, estimated, and actual departure and arrival times.
Plane Finder
planefinder.net › flight › LX9205 LX9205 Live Flight Tracker - Plane Finder
Live flight tracker for LX9205. Trusted flight tracking since 2009. Track live flights worldwide on a map and check real time airport status information. Explore detailed aircraft and flight data and playback historical flights.
Flightpedia
flightpedia.org › flight-status › ly9205.html EL AL Israel Airlines LY9205 Flight Status - LY 9205 Flight Status
Get the latest status of International flight EL AL Israel Airlines LY9205 from Madrid Barajas International Airport (MAD) to El Dorado International Airport (BOG).
Servodatabase
servodatabase.com › servo › futaba › s9205 Futaba S9205 Servo Specifications and Reviews
Detailed information and reviews for the Futaba S9205 servo.
Findchips
findchips.com › detail › ml9205-xxgp Findchips: ml9205-xxgp Manufacturer Options
Browse ml9205-xxgp manufacturers to view electronic part details.
Ripmax
ripmax.com › Category_List.aspx Ripmax - Futaba S9205 Spares
Ripmax is one of the largest wholesalers of radio control models & accessories in the UK.
Aviability
aviability.com › flight-number › flight-ly9205-el-al LY9205 El Al Flight - Aviability
El Al flight LY 9205 Madrid - Bogota (MAD-BOG), duration 10h 30m, departure 12:05, Madrid Barajas Terminal 4S, arrival 15:35, El Dorado Terminal 1.
Veswin
veswin.com › product-g9205.html G9205 GMT | G9205 Electronic Chips Components Distributor | G9205 G9091-120T11U G9090-150T11U G9091-150T11U G671L263T93U stock available from veswin.com
G9205
G9205, G9091-120T11U G9090-150T11U G9091-150T11U G671L263T93U from GMT Electronic Chips at Veswin Component Distributor, G9205 large in-stock quantities. PayPal accepted, inquire G9205 Specifications Near infrared image sensors (0.9 to 1.67 μm / 2.55 μm) online at veswin.com or RFQ Email ... Excelle
Rating: 5
Ferguson
ferguson.com › product › impact-products-infospec-6-in.-deluxe-toilet-plunger-s9205 › 7575496.html Impact Products 6 in. Deluxe Toilet Plunger | Ferguson
Shop for 6 in. Deluxe Toilet Plunger from Impact Products At Ferguson. Ferguson is the #1 US plumbing supply company and a top distributor of HVAC parts, waterworks supplies, and MRO products.
Candy
candy.com.pl › start › klocki › pozostałe › klocki wafle adusie 72 el. 9205 Kup KLOCKI WAFLE ADUSIE 72 EL. 9205
Niezwykle lekkie i miękkie klocki tzw. "wafle". Można dowolnie je składać i rozkładać, a także rozbudowywać z innymi zestawami. Klocki idealnie nadają się również dla mniejszych dzieci, duże elementy, miękki plastik, bardzo kolorowe i wyraziste, sprawiają, iż przyciągną uwagę ...
Krynica-zdroj
krynica-zdroj.org.pl › biuro-i-firma › produkt › klocki-wafle-ciezarowka-z-pilkami-5821 Sklep – Najlepsze produkty i promocje. Zupełnie inna porównywarka ...
Używamy ciasteczek, aby zapewnić najlepszą jakość korzystania z naszej witryny · Możesz dowiedzieć się więcej o tym, jakich ciasteczek używamy, lub wyłączyć je w ustawieniach
MercadoLibre
listado.mercadolibre.com.ar › mul9205a Mul9205a | MercadoLibre 📦
Envíos Gratis en el día ✓ Comprá Mul9205a en cuotas sin interés! Conocé nuestras increíbles ofertas y promociones en millones de productos.