Home / SQL / Practice problems / Easy

Prices with GST

Easy

Show each product's name and gst_price: price plus 10%, rounded to 2 decimals.

Tables: customers(customer_id, name, city, country, joined) · products(product_id, name, category, price) · orders(order_id, customer_id, order_date, status) · order_items(order_id, product_id, quantity, unit_price)

Your query
Show the expected result
namegst_price
Wireless mouse31.9
Mechanical keyboard130.9
USB-C hub53.9
27-inch monitor361.9
Noise-cancelling headphones273.9
Python Crash Course (book)49.5
Deep Learning (book)97.9
SQL Pocket Guide27.5
Standing desk603.9
Ergonomic chair438.9
Desk lamp64.9
Coffee beans 1 kg35.2
Green tea, 100 bags13.2
A5 notebook9.35
Gel pens, pack of 1012.1

15 rows

Show a solution
SELECT name, ROUND(price * 1.1, 2) AS gst_price FROM products;

SQL used

New to SQL? The free SQL course teaches everything these problems use, with a self-checking exercise in every lesson.