Skip to content

Instantly share code, notes, and snippets.

@nfreader

nfreader/gist:7760821

Created December 2, 2013 23:11
Show Gist options
  • Save nfreader/7760821 to your computer and use it in GitHub Desktop.
Save nfreader/7760821 to your computer and use it in GitHub Desktop.
Download ZIP
When keepin it real goes wrong:
Raw
gistfile1.sql
SELECT ssim_commod.name,
COUNT(CASE WHEN ssim_spob.techlevel >= ssim_commod.avail THEN 1 ELSE NULL END) AS spobs,
((sum(ROUND((ssim_commod.baseprice * (ssim_commod.avail / ssim_spob.techlevel) / ssim_commodspob.supply) * 2000)))/(COUNT(CASE WHEN ssim_spob.techlevel >= ssim_commod.avail THEN 1 ELSE NULL END))) AS avgprice,
((sum(ssim_commodspob.supply))/(COUNT(CASE WHEN ssim_spob.techlevel >= ssim_commod.avail THEN 1 ELSE NULL END))) AS avgsupply
FROM ssim_commod
LEFT JOIN ssim_commodspob ON ssim_commod.id = ssim_commodspob.commod
LEFT JOIN ssim_spob ON ssim_spob.id = ssim_commodspob.spob
WHERE ssim_spob.techlevel >= ssim_commod.avail
GROUP BY ssim_commod.id
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment