Craft Beer Bar Sales
Nelson Sauvin Bar sales history
@kaggle.podsyp_sales_in_craft_beer_bar
Nelson Sauvin Bar sales history
@kaggle.podsyp_sales_in_craft_beer_bar
CREATE TABLE product_range (
"product_code" BIGINT,
"vendor_code" VARCHAR,
"name" VARCHAR,
"retail_price" DOUBLE,
"base_unit" VARCHAR,
"country_of_origin" VARCHAR,
"size" DOUBLE,
"abv" DOUBLE
);
CREATE TABLE transactions (
"date_and_time_of_unloading" TIMESTAMP,
"product_code" BIGINT,
"amount" DOUBLE,
"sale_amount" DOUBLE,
"discount_amount" DOUBLE,
"profit" DOUBLE,
"percentage_markup" DOUBLE,
"discount_percentage" DOUBLE
);
Anyone who has the link will be able to view this.