Menu
CoddyTech

Active Price Review

Part of the SQL Foundations section of Coddy's PostgreSQL journey. Lesson 5 of 22.

challenge icon

Challenge

Medium

Return id and quarter_price for active products. Divide price by four using numeric arithmetic and round to two decimal places. Order by id.

The input tables are shown in the test panel. Each run starts from fresh data. Return the named columns in the stated order; do not hard-code the displayed rows.

Try it yourself

-- Write your SQL here.

All lessons in SQL Foundations

Practice on your own: PostgreSQL playground