Go Back   MacRumors Forums > Apple Systems and Services > Programming > Mac Programming

 
 
Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
Old Feb 22, 2013, 06:07 PM   #1
ArtOfWarfare
macrumors 603
 
ArtOfWarfare's Avatar
 
Join Date: Nov 2007
Send a message via Skype™ to ArtOfWarfare
Math in SQL? (HW)

I haven't even had 3 hours of hands on time with SQL yet, so I'm sorry if this comes off sounding like a very noobish question, but I can't figure out what I need to do to take the number returned by this query:

Code:
SELECT description, deaths1 FROM who.deaths
INNER JOIN who.icd9
ON who.deaths.cause = who.icd9.cause
where sex = 2
and country in (SELECT country FROM who.country where country_name like '%united kingdom%')
and ryear = 1980
and deaths1 > 0
group by who.icd9.cause
order by deaths1 desc
limit 1;
And divide it by a number returned by a different query.

Specifically, the question from my homework assignment is
Quote:
What percentage of the United Kingdom's female population died in 1980 from the leading cause of death?
The query I wrote above returns what the leading cause of death is for the United Kingdom Females from 1980, but now I need to sum all of the deaths for the United Kingdom Females from 1980 and then divide it by that.

I can't make what I've already written a subquery, because MySQL complains that it doesn't support limits inside of subqueries.

Suggestions?

Edit:

Alright, I can separately find the sum of all UK female deaths from 1980 with this query:

Code:
SELECT SUM(deaths1) deaths1 FROM who.deaths
where sex = 2
and country in (SELECT country FROM who.country where country_name like '%united kingdom%')
and ryear = 1980;
I don't know how to divide one by the other, though.
__________________
Don't tell me Macs don't last: 2007 iMac, 2007 Mac Mini, 2008 MacBook Air, all Vintage.
(iMac obsoletion: April 28, 2015, MBA: October 14, 2015, Mac Mini: March 9, 2016)

Last edited by ArtOfWarfare; Feb 22, 2013 at 10:53 PM.
ArtOfWarfare is offline   0 Reply With Quote

 
MacRumors Forums > Apple Systems and Services > Programming > Mac Programming

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Similar Threads
thread Thread Starter Forum Replies Last Post
Kids Garden Math - Learn Math While Harvesting Fruits PyjamasApps iPhone and iPod touch Apps 0 Jul 16, 2013 05:00 AM
Software similar to SQL Dev and SQL plus? doomfront Mac Basics and Help 0 Nov 20, 2012 01:25 PM
3rd Grade Math: Summer Review Splash Math App klkatielong iPad Apps 0 Jul 18, 2012 01:56 PM
[Math App] Homework teaches kids math and reports to parents Gaea deBomb iPhone and iPod touch Apps 0 Jul 3, 2012 05:35 AM
5+7+10+5+2+3= ? Math Aloud ! true mental math ... left & right brain. mobile.esd.mx iPhone and iPod touch Apps 0 Jun 1, 2012 05:17 PM

Forum Jump

All times are GMT -5. The time now is 06:58 AM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps

Mobile Version | Fixed | Fluid | Fluid HD
Copyright 2002-2013, MacRumors.com, LLC