Explain how the SELECT statement can be used along with GROUP BY class.

Write the sqlite steps to connect the database.

Explain how a connect to be made to a database (Academy through python SQlite3.

What is the use of aggregate functions used along with SELECT statement? What are they?

What is the purpose of using
(i) COUNT ( )
(ii) AVG ( )
(iii) SUM ( )
(iv) MAX ( )
(v) MIN ( )

Write a note on SELECT statement in SQL.

List the classes used in the SQL SELECT statement.

How will you create database using SQ Lite?

How will you display all records using fetch all ( )?

How will you display a record using fetch one ( )?

How will you display a record using fetchone ( )?

How will display record using fetchmany( )?

Write a program to display the content of tuples in new line without using loops.

Explain briefly about cursor( ) method of connection?

With an example,program explains briefly about SQL DISTINCT CLAUSE.