The DISTINCT clause is helpful when there is need of avoiding the duplicate values present in any specific columns/table. When we use distinct keyword only the unique values are fetched.

The cursor object is created by calling the cursor ( ) method of connection. The cursor is used to traverse the records from the result set.

(i) The WHERE clause can be combined with AND, OR, and NOT operators.
(ii) The AND and OR operators are used to filter records based on more than one condition.

The reason behind the triple quotes is sometime the values in the table might contain single or double quotes.

(i) A cursor in SQL and databases is a control structure to traverse over the records in a database. So it's used for the fetching of the results.
(ii) The cursor object is created by calling the cursor( ) method of connection. The cursor is used to traverse the records from the result set.

The fetchall() method is used to fetch all rows from the database table.
result = cursor. fetchall()

To populate the table "INSERT" command is passed to SQLite."execute" method executes the SQL command to perform some action.
Example:
Sql_command =" " INSERT INTO student (Rollno, Sname, Grade, Gender, Average, birth_date) values (NULL, "Akshay", "B", "M", "87.8", "2001-12-12");" " cursor.execute(sql_command)

If a column of a table is declared to be an INTEGER PRIMARY KEY, then whenever a NULL is used as an input for this column, the NULL will be automatically converted into an integer which will be one larger than the highest value so far used in that column.

Create a connection using connect() method and pass the nanie of the database file.
Example:
#connecting to the database
connection = sqlite3.connect ("Academy.db")
#cursor
cursor = connection.cursor()

Users of database can be human users or programmers, other programs or applications.