dunc

Newcastle upon Tyne

seriouslyfish.com

Age: 28

I'm a Virtual Learning Environment Manager during the day, then semi-Super (not really) web developer during the evening.

Please feel free to contact me for any reason.

Jul
2
awarded Inquisitive
Jul
2
awarded Curious
Jul
2
awarded Curious
Jul
2
awarded Curious
Jun
26
awarded Popular Question
Jun
20
awarded Autobiographer
Jun
16
accepted Creating a spider diagram/mind map with CSS
Jun
13
asked Creating a spider diagram/mind map with CSS
Jun
13
awarded Popular Question
Jun
7
awarded Popular Question
May
29
asked Linux Mint (XFCE) on Acer Veriton - using one monitor, Mint thinks I have two?
May
23
awarded Notable Question
Mar
25
awarded Popular Question
Mar
13
accepted Creating a formulaic query with multiple columns and joined columns
Mar
13
comment Creating a formulaic query with multiple columns and joined columns
Excellent answer, thanks for the detail. For a 50 point bounty, could you add in another column? I've tried it for myself but don't understand where to fit it in with the joins. I would like to include a COUNT of flags.. so I can see that Student X has been given 10 flags but because they're all quite serious his weighting is ~35 points. That make sense?
Mar
11
comment Creating a formulaic query with multiple columns and joined columns
Sorry Strawberry, I forgot about the output. I've worked it out manually and added it to my original question. I hope it's accurate but as it was done "by hand" there may be a discrepancy or two.
Mar
11
revised Creating a formulaic query with multiple columns and joined columns
added desired output in relation to sqlfiddle
Mar
11
comment Creating a formulaic query with multiple columns and joined columns
Ah OK, I see your point. It works for what I need it to though; not a heavily-used column.
Mar
11
revised Creating a formulaic query with multiple columns and joined columns
deleted 32 characters in body
Mar
11
comment Creating a formulaic query with multiple columns and joined columns
I think I've added an SQL fiddle... :D
1 2 3 4 5