How to write a SQL Join query?

Question

MySQL

Please help me to create a query to get the lowest price value among all values ​​that have category_id = 10
id = product_id in another table

Table 1
id - price
1 - 100
2 - 300
3 - 50
Table 2
product_id - category_id
1 - 10
2 - 10
3 - 11

Answer 1

SELECT
  min(price)
FROM
  table1
WHERE
  id IN (
    SELECT DISTINCT
      (product_id)
    FROM
      table2
    WHERE
      category_id = 10
  )