Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/lsp4you/public_html/connect.php on line 2 LSP4YOU - Learner's Support Publications
SQL Lab Exercises-2 Table creation Show Structure Record Insertion Update Query SELECT with MAX() SELECT with ORDER BY SELECT with MAX() Nested Query SELECT Query SELECT with AVG()


SELECT with AVG()

Q:10
Display the average marks in Sub2.


SQL> SELECT AVG(SUB2) FROM STUDENT;

 AVG(SUB2)
----------
      75.5