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'