CareerCup

SELECT 
  avg(table1.price), 
  table2.zipcode
FROM 
  table1, 
  table2
WHERE 
  table1.transaction_id = table2.transaction_id
GROUP BY table2.zipcode
Having avg(table1.price)>5;

This sql is based on MS-SQL

Select a.zipcode as Zipcode , AVG(b.price) as averagePrice
From [Table2] a inner join [Table1] b on a.transaction_id = b.transaction_id
Group by a.zipcode
--upto here, Question 1
Having AVG(b.price) > 5
--above line is for Question 2

-- To find average price per zipcode
select 
t2.zipcode
, avg(t1.price) as avgprice
from table1 t1 join table2 t2
on t1.transactionid = t2.transactionid
group by t2.zipcode

-- To find zipcode having avg price > $5
select 
t2.zipcode
, avg(t1.price) as avgprice
from table1 t1 join table2 t2
on t1.transactionid = t2.transactionid
group by t2.zipcode
having avg(t1.price) > 5

select zipcode avg(price) from table 2 join table 1 on table 1.id=table 2.id group by zipcode
having avg(price)>5

select t2.zip_code,avg(t1.price) from table2 t2
left outer join table1 t1 on
t2.transaction_id=t1.transaction_id
group by t2.zip_code
having avg(t1.price) > 5