Bummer! This is just a preview. You need to be signed in with an account to view the entire instruction.

Reporting with SQL

Well done!

You have completed Reporting with SQL!

Sign up for Treehouse Back to Library
Instruction

Single vs Double Quotes

In SQL there's a difference between using single quotes (') and double quotes ("). Single quotes should be used for String literals (e.g. 'lbs'), and double quotes should be used for identifiers like column aliases (e.g. "Max Weight"):

SELECT maximum_weight || 'lbs' AS "Max Weight" FROM ELEVATOR_DATA;

Also, in this course, there's a few instances where we get this wrong and u...