et up a Google Cloud Platform account. Create a BigQuery dataset named “order_entry_dataset” in your GCP Project. Copy all of the tables from the `handy-bonbon-142723.order_entry_dataset` to your own order_entry_dataset dataset (see example code below). Table names are: products, customers, orders, order_items, promotions, salesreps, warehouses, and inventories. To copy the tables, create an order_entry_dataset in your own GCP Project and then run queries like this (for each table): CREATE TABLE `order_entry_dataset.customers` AS SELECT * FROM `handy-bonbon-142723.order_entry_dataset.customers` Write a SQL statement to show the most profitable product overall orders (Note: unit price above Min Price). Only consider products that are available in the US or Canadian warehouses with list price over $50.
Set up a Google Cloud Platform account. Create a BigQuery dataset named “order_entry_dataset” in your GCP Project. Copy all of the tables from the `handy-bonbon-142723.order_entry_dataset` to your own order_entry_dataset dataset (see example code below).
-
Table names are:
products, customers, orders, order_items, promotions, salesreps, warehouses, and inventories.
-
To copy the tables, create an order_entry_dataset in your own GCP Project and then run queries like
this (for each table):
CREATE TABLE `order_entry_dataset.customers` ASSELECT * FROM `handy-bonbon-142723.order_entry_dataset.customers`
-
Write a SQL statement to show the most profitable product overall orders (Note: unit price above Min Price). Only consider products that are available in the US or Canadian warehouses with list price over $50.
-
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
