Register FAQ / Rules Forum Spy Search Today's Posts Mark Forums Read
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, 05:07 PM   #1
ArtOfWarfare
macrumors 601
 
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.
__________________
Battery Status - On the Mac App Store
The only app that'll estimate when your wireless devices will need their batteries changed.
Including the ones paired with other Macs on your network.

Last edited by ArtOfWarfare; Feb 22, 2013 at 09: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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -5. The time now is 09:13 AM.

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

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