Новый курс! Каждый программист должен знать генеративный ИИ!
Попробуйте бесплатный урок0
SQL intermediate
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 amyanderson@company.com Expected output email amy.anderson@company.com Wouldnt I need a dot to get the expected output?
3 ответов
+ 4
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.
+ 2
Answer for your update. Yes, you need to use a string containing just one dot. Remember to use quotes for the string.
+ 1
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?