BaşlayınÜcretsiz Başlayın

Creating a retail table

The business development team thinks there's an opportunity to increase revenue at each gym by adding a retail footprint. At this in-gym store, they'd sell things like towels, sneakers, and beverages. To track the goods being sold, they're going to need a new table in the CORE_GYM schema. To create this table, they've come to you. Show that what you've got!

Bu egzersiz

Data Types and Functions in Snowflake

kursunun bir parçasıdır
Kursu Görüntüle

Egzersiz talimatları

  • Create a transaction_id numeric field with a precision of 16 and scale of 0.
  • Define pre_tax_amount as a NUMBER that can have two digits right of the decimal point and a total of 6 digits.
  • Include a tax_rate column that could store a number such as 28.625; a total of 5 digits with 3 right of the decimal point.

Uygulamalı interaktif egzersiz

Bu örnek kodu tamamlayarak bu egzersizi bitirin.

CREATE OR REPLACE TABLE retail (
  	-- transaction_id stores 16 total digits with 0 right of the decimal point
    ___ NUMBER(16, 0),
  	-- pre_tax_amount stores up to 6 digits with 2 right of the decimal point
    ___,
  	-- tax_rate stores up to 5 digits with 3 right of the decimal point
    ___,
    transaction_total NUMBER(6, 2)
);
Kodu Düzenle ve Çalıştır