Inner Joins with USING and ON

/*Task 2*/
/*Query 2 - Join Signs and Materials tables to show Material name along with other info*/
SELECT quantity as 'Quantity', CONCAT(hor_dimens, ' ft x ', vert_dimens, ' ft') as 'Dimensions', UPPER(Materials.name) as 'Material' FROM Signs INNER JOIN Materials USING (mat_id) WHERE id < 10 ORDER BY hor_dimens asc
/*Query 3 - Round Costs to nearest whole dollar*/
SELECT CONCAT(Signs.hor_dimens, ' ft x ', Signs.vert_dimens, ' ft') as 'Dimensions', Materials.name as 'Material', Finishes.name as 'Finish', Signs.quantity as 'Quantity', ROUND(Signs.cost) as 'Cost'
FROM Signs 
INNER JOIN Materials ON Signs.mat_id=Materials.mat_id
INNER JOIN Finishes ON Signs.finish_id=Finishes.finish_id
WHERE 1 ORDER BY cost DESC;
/*Query 4 - Show Number of signs for each type of material*/
SELECT  Materials.name as 'Material', SUM(Signs.quantity) as 'Total'
FROM Signs 
INNER JOIN Materials ON Signs.mat_id=Materials.mat_id
GROUP BY Signs.mat_id HAVING COUNT(*)>0 ORDER BY SUM(Signs.quantity);