Skip to content
New Workbook
Sign up
My Python workspace
# Add your Python code here!
name = 'Hello World!'
print(name)





Spinner
DataFrameavailable as
df
variable
-- Select the product details, quantity, and location of bicycles in stock
SELECT
    c.category_name 'Category',
    COUNT DISTINCT p.product_name 'Number of products',
    MAX (p.list_price) 'Most expensive product',
    SUM (s.quantity) 'Total stock',
    COUNT DISTINCT s.store_id 'Stores'
FROM products p
  INNER JOIN stocks s
    ON p.product_id = s.product_id
  INNER JOIN categories c
    ON p.category_id = c.category_id
GROUP BY c.category_name
ORDER BY c.category_name