Middle East Countries Users

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select count(*) as [Middle East - Female]  from Users where  AboutMe like '%female%'
and Location  like '%egypt%' or Location  like '%Egypt%'
or Location  like '%iran%' or Location  like '%Iran%'
or Location  like '%iraq%' or Location  like '%Iraq%'
or Location  like '%israel%' or Location  like '%Israel%'
or Location  like '%jordan%' or Location  like '%Jordan%'
or Location  like '%kuwait%' or Location  like '%Kuwait%'
or Location  like '%lebanon%' or Location  like '%Lebanon%'
or Location  like 'oman' or Location  like 'Oman'
or Location  like '%palestine%' or Location  like '%Palestine%'
or Location  like '%qatar%' or Location  like '%Qatar%'
or Location  like '%syria%' or Location  like '%Syria%'
or Location  like '%turkey%' or Location  like '%Turkey%'
or Location like '%saudi arabia%' or Location  like '%Saudi Arabia%' or Location  like '%saudi Arabia%' or Location  like '%Saudi arabia%' or Location  like '%Saudi%'
or Location  like '%United Arab Emirates%' or Location  like '%Emirates%' or Location  like '%emirates%'
or Location  like '%yemen%' or Location  like '%Yemen%'
or Location like '%Bahrain%' or Location  like '%bahrain%'
or Location like '%Kurdistan Region%' or Location  like '%Iraqi Kurdistan%' or Location  like '%Kurd%' or Location  like '%kurd%'
or Location like '%Middle East%' or Location  like '%middle east%'


select count(*) as [Middle East - male]  from Users where  AboutMe like '% male%'
and Location  like '%egypt%' or Location  like '%Egypt%'
or Location  like '%iran%' or Location  like '%Iran%'
or Location  like '%iraq%' or Location  like '%Iraq%'
or Location  like '%israel%' or Location  like '%Israel%'
or Location  like '%jordan%' or Location  like '%Jordan%'
or Location  like '%kuwait%' or Location  like '%Kuwait%'
or Location  like '%lebanon%' or Location  like '%Lebanon%'
or Location  like 'oman' or Location  like 'Oman'
or Location  like '%palestine%' or Location  like '%Palestine%'
or Location  like '%qatar%' or Location  like '%Qatar%'
or Location  like '%syria%' or Location  like '%Syria%'
or Location  like '%turkey%' or Location  like '%Turkey%'
or Location like '%saudi arabia%' or Location  like '%Saudi Arabia%' or Location  like '%saudi Arabia%' or Location  like '%Saudi arabia%' or Location  like '%Saudi%'
or Location  like '%United Arab Emirates%' or Location  like '%Emirates%' or Location  like '%emirates%'
or Location  like '%yemen%' or Location  like '%Yemen%'
or Location like '%Bahrain%' or Location  like '%bahrain%'
or Location like '%Kurdistan Region%' or Location  like '%Iraqi Kurdistan%' or Location  like '%Kurd%' or Location  like '%kurd%'
or Location like '%Middle East%' or Location  like '%middle east%'

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results