h0tk3y · March 3, 2017 10:10
diff --git a/gistfile1.txt b/gistfile1.txt
 CREATE VIEW avg_meter_cost_rent AS 
 SELECT rooms_number, AVG(cost / area) AS avg_meter_cost 
 FROM offer JOIN property USING (property_id)
 GROUP BY rooms_number
 WHERE kind = 'rent';

 CREATE VIEW avg_meter_cost_sale AS 
 SELECT rooms_number, AVG(cost / area) AS avg_meter_cost 
 FROM offer JOIN property USING (property_id)
 GROUP BY rooms_number
 WHERE kind = 'sale';
	CREATE VIEW avg_meter_cost_rent AS
	SELECT rooms_number, AVG(cost / area) AS avg_meter_cost
	FROM offer JOIN property USING (property_id)
	GROUP BY rooms_number
	WHERE kind = 'rent';

	CREATE VIEW avg_meter_cost_sale AS
	SELECT rooms_number, AVG(cost / area) AS avg_meter_cost
	FROM offer JOIN property USING (property_id)
	GROUP BY rooms_number
	WHERE kind = 'sale';
No results found