3 Statements from previous evidence items using ORDER BY to sort

/*Q1 From Rearrange and Use Aliases - Concatenated name and cost with reader friendly language and used alias of Available Materials for that column*/
SELECT concat( name, ' costs ', cost, ' per square foot.') AS "Available Materials" FROM Materials ORDER BY cost;
/*Q2 - From Single Row Functions - 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;
/*Q3 - Added Sort to HAVING, GROUP BY CLAUSE - Show Number of Banners That Need Grommets or Power Tabs*/
SELECT CONCAT(Signs.hor_dimens, ' ft x ', Signs.vert_dimens, ' ft') as 'Banners', Finishes.name as 'Finish', SUM(Signs.quantity) as 'Total'
FROM Signs
INNER JOIN Finishes ON Signs.finish_id=Finishes.finish_id
WHERE (Signs.finish_id=1 or Signs.finish_id=2) and (Signs.hor_dimens>4 or Signs.vert_dimens>4) GROUP BY Signs.hor_dimens,Signs.vert_dimens,Signs.finish_id HAVING COUNT(*)>0
ORDER BY Signs.quantity desc;