sql query

[sivak]

i have 3 tables
student table
roll no name
sub table
roll no subid subname
markstable
roll no subid marks
1)select name,subname,marks whose having marks less than 40
2)select sub name,marks whose having avg above 60%
3)select rank of each student
can any one tell me the query for that

[nmaillet]

Here is a pretty good tutorial on SQL http://w3schools.com/sql/default.asp

[sivak]

can anyone tell me the query...urgent plz

[nmaillet]

You usually won't get a response unless you put in some effort.