formatting-bad.sql

DELETE FROM SCHEMA.TABLE_XYZ; INSERT INTO SCHEMA.TABLE_XYZ(sale_id, user_id, sale_value, no_of_items)
SELECT a.sale_id, a.user_id, a.sale_value
, COALESCE(CASE	WHEN a.product = 310 THEN 90 WHEN a.product = 311 THEN 10
	WHEN a.product = 312 THEN 50 WHEN X.type = 'Month' THEN X.quantity * 30
	ELSE a.quantity END, 0) AS no_of_items FROM (SELECT DISTINCT c.product, pd.productName, c.quantity FROM (
	SELECT rb.redeem_id, pd.product, COUNT(*) AS quantity
	FROM tableA rb
	JOIN tableB r ON r.id = rb.redeem_id
	JOIN tableC pd ON pd.externalId = r.product_id AND rb.something_else = 'cooksHeaven' AND pd.is_paid_for = 1 GROUP BY 1, 2, 3) c
INNER JOIN SCHEMA.tableD pd USING (product)) a
LEFT JOIN SCHEMA.tableX X ON X.product = a.product
LEFT JOIN SCHEMA.tableY Y ON Y.product = a.product AND Y.name IN ('Wagyu Beef', 'Ribs')
LEFT JOIN SCHEMA.tableZ Z ON Z.product = a.product AND Z.name = 'Pork Ribs'