Monday, February 27, 2012

Bride Search

Bride search scenario represented as SQL statements. Might not appeal non-IT guys!

Compare every statement with the previous age's statement.

Age 26 :

select * from profiles where
gender = 'FEMALE' and
financial_status = 'RICH' and
complexion = 'FAIR/VERY FAIR' and
education = 'Minimum GRADUATE/POST GRADUATE' and
occupation = 'WORKING '
religion = 'K'
caste = 'X' and subcaste = 'Y'



Age 27 :

select * from profiles where
gender = 'FEMALE' and
financial_status = 'RICH' and
complexion = 'FAIR/WHEATISH' and
education = 'GRADUATE/POST GRADUATE' and
occupation = 'WORKING '
religion = 'K'



Age 28 :

select * from profiles where
gender = 'FEMALE' and
financial_status = 'MEDIOCRE' and
complexion = 'WHEATISH/DARK' and
education = 'STARTING FROM 10TH standard' and
occupation = 'NOT SO PARTICULAR'
religion = 'I DONT BELIEVE IN RELIGION,CASTE & CREED'





Age 29 :

select * from profiles where
gender = 'FEMALE' and
financial_status = 'NO PREFERENCE' and
complexion = 'I BELIEVE BEAUTY IS SKIN DEEP'




Age 30 :

select * from profiles where gender = 'FEMALE'

 
Age 30+:

select * from profiles where gender LIKE 'FEMALE'
 

4 comments:

  1. And what did you say your age is? :)

    ReplyDelete
  2. Yet to get in to this Vish! Just 25

    ReplyDelete
  3. Ha Ha Ha :) Good One Thambu.. Will wait and see what is gonna be your quesry.. I think it will be
    Age 30+:

    select * from profiles where gender LIKE 'FEMALE'

    ReplyDelete