SELECT subject, author, body FROM message WHERE forumname='Inls258' ORDER BY dateposted;

SELECT MID FROM message WHERE forumname='Web Database' AND MONTH(dateposted)=8;

SELECT forum.forumname, COUNT(MID) as num FROM message, forum WHERE forum.forumname=message.forumname GROUP BY forum.forumname ORDER BY num DESC;

SELECT m1.MID, count(m2.MID) as numofmsg
FROM message as m1, message as m2 WHERE m2.in_reply_to=m1.MID GROUP BY m1.MID ORDER BY m1.MID;

DROP TABLE IF EXISTS temp;
CREATE TEMPORARY TABLE temp SELECT forum.forumname, count(MID) as num FROM forum LEFT JOIN message ON(forum.forumname=message.forumname)GROUP BY forumname HAVING num<1;

SELECT temp.forumname, usertable.username, name, email FROM temp, interact, usertable, adm_moderator WHERE temp.forumname=interact.forumname AND interact.username=usertable.username AND usertable.username=adm_moderator.username AND role='moderator';