Skip to content
My Python workspace
# Add your Python code here!
name = 'Hello World!'
print(name)
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