`
import sqlite3
conn = sqlite3.connect(‘:memory:’)
conn.execute( “””
CREATE TABLE artist(
artistname TEXT PRIMARY KEY,
country TEXT,
genre TEXT
)
“””)
conn.execute( “””
INSERT INTO artist(artistname, country, genre)
VALUES
( “ACDC” ,”Australia” ,”Rock”),
( “Beatles”,”UK” ,”Pop”),
( “Cramps” ,”USA” ,”Psychobilly”),
( “Danzig” ,”Germany” ,”Rock”)
“””)
print (“Rock bands…”)
results = conn.execute(“””
SELECT artistname, country
FROM artist
WHERE artist.genre = “Rock”
“””)
for record in results:
print( “Artist =”, record[0])
print( “Country =”, record[1])
print ()
conn.close()
‘
.
