[ Date Index ] [ Thread Index ] [ <= Previous by date / thread ] [ Next by date / thread => ]
>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 ..... -- The Mailing List for the Devon & Cornwall LUG http://mailman.dclug.org.uk/listinfo/list FAQ: http://www.dcglug.org.uk/listfaq