This query is used to get a list of all suppliers who have all their products with average rating above 3.

\begin{lstlisting}
SELECT
    s.supplierID,
    CONCAT(s.first_name, ' ', s.middle_initial, ' ', s.last_name) AS name
FROM supplier s
WHERE (
    SELECT AVG(pr.rating) FROM product_review pr, product p
    WHERE p.productID = pr.productID AND p.supplierID = s.supplierID
    GROUP BY p.supplierID
) > 3;
\end{lstlisting}