Could you please find all the procedures that cost more than 1000?
select * from procedures where cost > 1000
Could you please find all the procedure that Jon Wen was trained in?
select * from physician as t1 join trained_in as t2 on t1.employeeid = t2.physician join procedures as t3 on t3.code = t2.treatment where t1.name = "John Wen"
What are the names of the procedures that cost more than 1000 and are procedures John Wen was trained in?
select name from procedures where cost > 1000 intersect select t3.name from physician as t1 join trained_in as t2 on t1.employeeid = t2.physician join procedures as t3 on t3.code = t2.treatment where t1.name = "John Wen"
When do all of John Wen's certifications expire?
select t2.certificationexpires from physician as t1 join trained_in as t2 on t1.employeeid = t2.physician join procedures as t3 on t3.code = t2.treatment where t1.name = "John Wen"