---

the Perfect mySQL execution!

after going nuts about mySQL quiz this morning, i came out with the Perfect QUERY to execute!!!!!

SELECT type_of_frens, level_of_fun, numgames, MAX(food), MIN(stress), SUM(nproject+nassignment+nquiz)<=0
FROM esther.special.data AS a, schworkload_table AS b
WHERE a.numgames='bridge' AND a.level_of_fun=10 AND type_of_frens rlike vgoodtome
GROUP BY type_of_frens
ORDER BY level_of_fun DESC

p/s: Hey prof sql, on the account that i does apply what u taught usefully to my other study n recreation areas, could u get me better grades?? -.-'''

# posted by esther_t11 | 10:05 AM

0 Comments:

Post a Comment

<< Home

myChatterbox

myArchives

October 2005
November 2005
December 2005
January 2006
April 2006
May 2006
June 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
November 2007
June 2008
July 2008
April 2010


myLinks

[Janet]
[Anisa]
[Tyng]
[Debbie]
[Kiang]
[Jianyu]
[Kwong]
[Elgin]
[Fiona]
[Angeline]


myCounter