A virtual data analyst job for students and freshers in India. Practise the work, not just the syntax.

Product

Scenario library
Pricing
How it works

For you

Students
Trainers & colleges
FAQ

Company

Contact
Institutions

© DataDesk. All companies, people and datasets are fictional.

Made for learners in India 🇮🇳

Upsert a price list — practice · DataDesk

How it works
Scenarios
Practice
For trainers
Pricing

Log in Start free

INSERT, UPDATE & DELETE(16 / 20)

Advanced

Upsert a price list

Apply price_updates to products: existing products get the new price; products that don't exist yet are added with stock 0.

Tables

customers

customer_idinteger
namevarchar
cityvarchar
statevarchar
signup_datedate
emailvarchar
phonevarchar
referred_byinteger

order_items

order_idinteger
product_idinteger
quantityinteger
unit_priceinteger

orders

order_idinteger
customer_idinteger
order_datedate
statusvarchar
payment_methodvarchar

price_updates

product_idinteger
product_namevarchar
categoryvarchar
priceinteger

products

product_idinteger
product_namevarchar
categoryvarchar
priceinteger
stockinteger

Hints(0/2)

Solution

Unlocks after you solve it or after 3 submissions

SQL (DuckDB)

Ctrl + Enter to runLog in to save progress and earn XP

Run your code to see the output here.