SQL QUESTION W3schools

Question

This is the database that i want to use, https://www.w3schools.com/sql/trysql.asp?filename=trysql_op_in

Find the average price for all the products from the USA supplier.

Answer 1

select avg(p.price) as "all orders average price from US supplier"

from orders o

inner join orderdetails od

on o.orderid = od.orderid

inner join products p

on od.productid = p.productid

inner join suppliers s

on p.supplierid = s.supplierid

where s.country = 'USA';