D&C GLug - Home Page

[ Date Index ] [ Thread Index ] [ <= Previous by date / thread ] [ Next by date / thread => ]

[LUG] Why the public sector can only operate on proprietary software

 

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(*)
-----------
200

Ok 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