What are all the problems that are reported after 1995?
select * from problems where date_problem_reported > "1995"
Show the product names that each are associated with?
select *, t2.product_name from problems as t1 join product as t2 on t1.product_id = t2.product_id where t1.date_problem_reported > "1995"
Show the ids of the ones with the product named Rose.
select t1.problem_id from problems as t1 join product as t2 on t1.product_id = t2.product_id where t2.product_name = "rose" and t1.date_problem_reported > "1995"
How about those with the product named voluptatem
select t1.problem_id from problems as t1 join product as t2 on t1.product_id = t2.product_id where t2.product_name = "voluptatem" and t1.date_problem_reported > "1995"