Electronics stock only — SQL practice · JobPrax

Practice
Live projects
Guided projects
For colleges
Pricing

Log in Start free

SQLBasic

Electronics stock only

PreviousProblem 21 of 40Next

In one row, show the total stock of Electronics (electronics_stock) and the total stock of all products (all_stock).

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

products

product_idinteger
product_namevarchar
categoryvarchar
priceinteger
stockinteger

Hints(0/2)

Each hint gives a little more help. Try on your own first.

Solution

Unlocks after you solve it or after 3 submissions

SQLCtrl + Enter to run

Log in to save progress and earn XP

Run your code to see the output here.