Exercise

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!

Instructions

100 XP

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.

.css-6su6fj{-webkit-flex-shrink:0;-ms-flex-negative:0;flex-shrink:0;}Exercise

Instructions

Exercise