(i) "SELECT" is the most commonly used statement in SQL.
(ii) The SELECT Statement in SQL is used to retrieve or fetch data from a table in a database.
(iii) The syntax for using this statement is "Select * from table_name" and all the table data can be fetched in an object in the form of list of lists. List the classes used in

(I) COUNT ( ) function returns the number of rows in a table.
(ii) AVG ( ) function retrieves the average of a selected column of rows in a table.
(iii) SUM ( ) function retrieves the sum of a selected column of rows in a table.
(iv) MAX( ) function returns the largest value of the selected column.
(v) MIN( ) function returns the smallest value of the selected column.

# Python code to demonstrate table creation and insertions with SQL
# importing module
import sqlite3
# connecting to the database
connection = sqlite3.connect ("Academy.db")
# cursor
cursor = connection.cursor ( )

Step 1: Import sqlite3
Step 2: Create a connection using connect o method and pass the name of the database File
Step 3: Set the cursor object cursor = connection. cursor ( )

(i) The SELECT statement can be used along with GROUP BY clause.
(ii) The GROUP BY clause groups records into summary rows. It returns one records for each group.
(iii) It is often used with aggregate functions (COUNT, MAX, MIN, SUM, AVG) to group the result -set by one or more columns.