/*** "Let's Organize a Party" Query ***/
SELECT * FROM Friendster.dbo.Friends
WHERE Status not in ('In a relationship', 'Married')
AND Age > 25
ORDER BY LastName
ORDER BY LastName
~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~
Hehehe. I love SQL.
Hehehe. I love SQL.
3 comments:
You are missing a few additional filters:
AND Gender = 'Male'
AND DarnaFl <> 1
You should return finer results.
result:
0 rows returned
nyahahahaha. =P
Hahaha. DarnaFl <> 1 ?!?!
Yeah, i have to agree with coffee fairy...
0 rows returned
Post a Comment