Show me all the problems on the product with name voluptatem.
select * from product as t1 join problems as t2 on t1.product_id = t2.product_id where t1.product_name = "voluptatem"
What are the statuses of each?
select *, t3.problem_status_code from product as t1 join problems as t2 on t1.product_id = t2.product_id join problem_log as t3 on t2.problem_id = t3.problem_id where t1.product_name = "voluptatem"
How many are solved?
select count(*) from product as t1 join problems as t2 on t1.product_id = t2.product_id join problem_log as t3 on t2.problem_id = t3.problem_id where t1.product_name = "voluptatem" and t3.problem_status_code = "Solved"
Actually how many are there in total?
select count(*) from product as t1 join problems as t2 on t1.product_id = t2.product_id where t1.product_name = "voluptatem"