using databases and sql command that we are adding (such as the table and column nameswill be shown in lowercase the first sql command removes the tracks table from the database if it exists this pattern is simply to allow us to run the same program to create the tracks table over and over again without causing an error note that the drop table command deletes the table and all of its contents from the database ( there is no "undo"cur execute('drop table if exists tracks 'the second command creates table named tracks with text column named title and an integer column named plays cur execute('create table tracks (title textplays integer)'now that we have created table named trackswe can put some data into that table using the sql insert operation againwe begin by making connection to the database and obtaining the cursor we can then execute sql commands using the cursor the sql insert command indicates which table we are using and then defines new row by listing the fields we want to include (titleplaysfollowed by the values we want placed in the new row we specify the values as question marks (??to indicate that the actual values are passed in as tuple 'my way' as the second parameter to the execute(call import sqlite conn sqlite connect('music sqlite'cur conn cursor(cur execute('insert into tracks (titleplaysvalues (??)'('thunderstruck' )cur execute('insert into tracks (titleplaysvalues (??)'('my way' )conn commit(print('tracks:'cur execute('select titleplays from tracks'for row in curprint(rowcur execute('delete from tracks where plays 'conn commit(cur close(code