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).CREATE TABLE `order_entry_dataset.customers` ASSELECT * FROM `handy-bonbon-142723.order_entry_dataset.customers`Write a SQL statement to show the total dollar amount sold across product categories for all orderable products. Calculate the percentage contribution of each product category’s sales to the overall total sales.Write a SQL statement to show the total dollar amount sold summarized by Customer marital status and Year along with RANK. The largest sales by marital status by year should be ranked #1.

Copying Tables:To copy tables from another data set, you can use the CREATE TABLE statement as…

Answered: Set up a Google Cloud Platform account.…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

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).
1. CREATE TABLE `order_entry_dataset.customers` AS
  SELECT * FROM `handy-bonbon-142723.order_entry_dataset.customers`
2. Write a SQL statement to show the total dollar amount sold across product categories for all orderable products. Calculate the percentage contribution of each product category’s sales to the overall total sales.
3. Write a SQL statement to show the total dollar amount sold summarized by Customer marital status and Year along with RANK. The largest sales by marital status by year should be ranked #1.

Expert Solution

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions