What is the relationship between tables?

Question

SQL

I have a database schema. Tell me, I can’t understand what is the relationship between the Prices and Goods tables?
And how to display the name of the product for which there is a discount (discount) 10%.

Answer 1

Why understand this connection? Well, you learned that this is a one-to-many relationship, so what? )
An example of a request if inside the discount field is 10 as 10%:

SELECT 
    g.name, p.price
FROM
    Goods AS g,
    Prices AS p
WHERE
    p.discount = 10 AND g.id = p.id;