Forum Discussion
Confused in aliasing
SELECT
Warehouse.warehouse_id,
CONCAT (Warehouse.state,":", Warehouse.warehouse_alias) AS warehouse_name,
COUNT (Orders.order_id) AS num_of_orders,
(SELECT COUNT(*) FROM resonant-apex-416004.warehouse_orders.orders AS Orders) AS total_orders,
CASE
WHEN COUNT (Orders.order_id)/(SELECT COUNT(*) FROM resonant-apex-416004.warehouse_orders.orders AS Orders) <= 0.20
THEN 'Fufilled 0-20% of Orders'
WHEN COUNT(Orders.order_id)/(SELECT COUNT(*) FROM resonant-apex-416004.warehouse_orders.orders AS Orders) > 0.20
AND COUNT(Orders.order_id)/(SELECT COUNT(*) FROM resonant-apex-416004.warehouse_orders.orders AS Orders) <= 0.60
THEN 'Fufilled 21-60% of orders'
ELSE 'Fulfilled more than 60% of Orders'
END AS fufillment_summary
FROM
resonant-apex-416004.warehouse_orders.warehouse AS Warehouse
LEFT JOIN resonant-apex-416004.warehouse_orders.orders AS Orders
ON Orders.warehouse_id = Warehouse.warehouse_id
GROUP BY Warehouse.warehouse_id,
warehouse_name
HAVING
COUNT(Orders.order_id) > 0
If i replace my line 5, "resonant-apex-416004.warehouse_orders.orders" to just Orders because of my alias on line 19, will this sql work?
2 Replies
ErenC1585 to just Orders because of my alias on line 19, will this sql work?
No, you can not use a alias within the same SQL statement.- I see, thanks for the help!
