<s>[INST] // Exercise

// Create a simple SQL table (in qlite3) that would store an inventory of music files, then write a function to show the "party playlist" - so, all songs by a few popular party DJ's (Skrillex, Marshmello etc.). 

For creating DB - make it one column for artist, one for track name, one for track duration then something to denote genre.

Here's the SQL script to create the data tables for the party playlist, it's commented with a few sample records for kicks:

```sql
-- Create table to store music files
CREATE TABLE music_files (
    artist TEXT NOT NULL,
    song_name TEXT NOT NULL,
    duration INTEGER NOT NULL, // in seconds
    genre TEXT NOT NULL
);

-- Sample records
INSERT INTO music_files (artist, song_name, duration, genre) 
VALUES 
('Skrillex', 'Bangarang', 201, 'Electronic'),
('Marshmello', 'Happier', 174, 'Electro-Pop'),
('Calvin Harris', 'Summer', 209, 'Pop'),
('The Chainsmokers', 'Don\'t Let Me Down', 187, 'Electronic'),
('David Guetta', 'Titanium', 243, 'Electronic'),
('Skrillex', 'Scary Monsters and Nice Sprites', 147, 'Electronic'),
('Calvin Harris', 'Summer (feat. John Newman)', 217, 'Pop');

```

And here's now the python connect and query using sqlite3:

```python
import sqlite3
import time

# Establish DB connection
conn = sqlite3.connect('party_playlist.db') 
cur = conn.cursor()

# 1st example: given the table name as parameter (table_name parameter: yes)
def fetch_all_songs(artist='Skrillex'):
    query = "SELECT * FROM music_files WHERE artist =?[/INST]