[ Date Index ] [ Thread Index ] [ <= Previous by date / thread ] [ Next by date / thread => ]
On 29/03/2011 20:24, Tom Brough wrote:
I ran a few query's today to try and answer the above question, I thought I might share the results.>select count(*) from staff where department = 'IT' and role = 'manager' and skills = 'technical' and background = 'open source';no rows selected Ok well that was obvious .... lets try something else ....>select count(*) from staff where department = 'IT' and role = 'manager' and skills = 'technical' and background = 'proprietary';no rows selected hmm surprising ... ok maybe its something to do with skills ?>select count(*) from staff where department = 'IT' and role = 'manager' and skills = 'none' and background = 'proprietary';count(*) ----------- 200 wow that's a bit on the high side ..... how managers do we have ?>select count(*) from staff where department = 'IT' and role = 'manager' and skills = 'none';count(*) ----------- 200 Ok surely I missed something ? >select count(*) from staff where department = 'IT' and role = 'manager' count(*) ----------- 200Ok so I have a large number of managers all with proprietary backgrounds and no skills .... So must be a huge IT department with all those managers....>select count(*) from staff where department = 'IT'; count(*) ----------- 201 That cant be right surely ? >select name from staff where department = 'IT' and role <> 'manager'; name ------------ you Figures .....
Sweet.... Dave -- The Mailing List for the Devon & Cornwall LUG http://mailman.dclug.org.uk/listinfo/list FAQ: http://www.dcglug.org.uk/listfaq