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 ...
The Iris, Titanic, and other seaborn example datasets in .db format for practicing SQL queries, exploratory analysis, machine learning, etc. Each database starts with an Observation table, which ...