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?