How to do this query in MYSQL

How to do this query in MYSQL

References

Reference NO 1

http://php.net/manual/en/function.mysql-query.php

Reference NO 2

http://dev.mysql.com/doc/refman/4.1/en/entering-queries.html

Reference NO 3

http://php.about.com/od/phpwithmysql/ss/mysql_php_3.htm

Reference NO 4

http://www.tizag.com/mysqlTutorial/mysqlquery.php

Reference NO 5

http://arachnoid.com/MySQL/

Reference NO 6

http://www.tutorialspoint.com/mysql/mysql-select-query.htm

Reference NO 7

http://www.cyberciti.biz/faq/run-sql-query-directly-on-the-command-line/

Reference NO 8

http://www.packtpub.com/article/building-queries-visually-in-mysql-query-browser