[Resolved] addition/division on different records in a single query

[sneakyimp]

i want to run a query on table foo
assuming i have 2 fields of interest, i want to return one value which is

the sum of field1 values for all records that have a value of '1','2', or '3' for field2
divided by
the sum of all field1 values for all records that have a value of '4' for field 2

i'm using mySQL version 3.23.58. is this possible?

[Roger_Ramjet]

No.

[sneakyimp]

thanks for your answer! very concise 😉