SELECT M.METAL_NAME AS "Metal Coat",
       S.STONE_NAME AS "Embedding Gemstone",
       COUNT(*) AS "Placed Orders"
FROM COMPONENT C JOIN JOB J
    ON J.JOB_ID = C.JOB_ID FULL JOIN STONE_TYPE S
    ON S.STONE_ID = C.STONE_ID FULL JOIN METAL_TYPE M
    ON M.METAL_ID = C.METAL_ID
GROUP BY S.STONE_NAME, M.METAL_NAME
ORDER BY COUNT(*) DESC;