SQL intermediate

Question

I'm getting an error message without fully understand why. Here is the coding

1. SELECT CONCAT(
2. LOWER ( firstname),
3. ' '
4. - '
5. LOWER (lastname),
6. '@company.com' AS email
7. FROM employees
ORDER BY email ASC

States there is an error on line 4. Then I changed it & still got a syntex error message. What is going on here?

Edit: Thx for replies. I seemed to have another error message...after i fixed what was mentioned below. It states there is a '.' Theres a dot in the code. Here is the new error message.

Your output
email
[e-mail]

Expected output
email
[e-mail]

Wouldnt I need a dot to get the expected output?

Answer 1

Jess A check that all parentheses are closed, all quotation marks are paired, and that there are no missing commas. It looks like all three of these errors need correction.

Answer 2

Answer for your update. Yes, you need to use a string containing just one dot. Remember to use quotes for the string.

Answer 3

There's a quote missing in line 4, trailing commas in lines 3 and 4, and a closing parenthesis just before "AS".

Also, do you really need that empty string in line 3?