CREATE PROCEDURE add_new_sale(@products) BEGIN INSERT INTO sales (time) VALUES (datetime('now')); SET @sale_id = last_insert_rowid(); FOREACH @prod_id, @qty, @price IN @products DO INSERT INTO ...

Practice your SQL and Data Science Skills on this handy-to-use sample SQL dataset! Runs in SQLite3 on your local machine. No SQL server setup required. Sakila is a sample database originally developed ...