Resolved: questions about the practice exam
This question seems like a correct one but when I run the code I get an ERROR
here is the code
even here I've tried to set the names of the columns at the top next to customers, But I got the same error
this one, can I know what this (e.) used for
2 answers ( 1 marked as helpful)
Hi Peter!
Thanks for reaching out.
- The query is correct and Alex will be able to execute the query. In your query there is an error for an unknown column because you have not used the appropriate quotes for strings which is -
''or"". Please, use the correct quotes and the query will be correct. - This
eis an alias. SQL aliases are used to give a table, or a column in a table, a temporary name. Aliases are often used to make column names more readable. An alias only exists for the duration of that query. An alias is created with theASkeyword.
Hope this helps.
Best,
Tsvetelin
okay, Thanks for your explanation.