Toys Sales Summary

Easy

Description

For the order lines of Toys products (category_id 8), show in one row:

lines: the number of order lines
orders: the number of different orders those lines belong to
units: the total quantity
revenue: the sum of quantity × unit_price less discount_pct percent, rounded to 2 decimal places

Easy

For the order lines of Toys products (category_id 8), show in one row:

lines: the number of order lines
orders: the number of different orders those lines belong to
units: the total quantity
revenue: the sum of quantity × unit_price less discount_pct percent, rounded to 2 decimal places

lines	orders	units	revenue
68	64	123	351234.70

Easy

For the order lines of Toys products (category_id 8), show in one row:

lines: the number of order lines
orders: the number of different orders those lines belong to
units: the total quantity
revenue: the sum of quantity × unit_price less discount_pct percent, rounded to 2 decimal places

Easy

For the order lines of Toys products (category_id 8), show in one row:

lines: the number of order lines
orders: the number of different orders those lines belong to
units: the total quantity
revenue: the sum of quantity × unit_price less discount_pct percent, rounded to 2 decimal places