what is the true sql statement for show something like list of products

How can I show the products ( description , serial number, price ) purchased by the customer "Peacock cafe bar" in the picture I show 3 tables I have try with select from ... where( select from ... as ... where “” )