+ 4

SQL salery >50000

I am currently doing the beginner course for SQL and I have difficulty with this task. It's an easy task. Task: Complete to extract information about the employees with a salary greater than 50000. SELECT * _____ employees WHERE salary _____ 50000 I said "FROM" and ">" are the answers. But apparently "FROM" is not the correct answer and I don't know what it could be otherwise. It's a stupid question and I am probably missing something very obvious but I would appreciate some help.

27th Jun 2023, 6:57 PM
Gül Karahan
Gül Karahan - avatar
13 Respuestas
+ 6
The basic structure of a SQL query is: SELECT column1, column2, ... FROM table WHERE condition; So the correct answer to complete the query would be: SELECT * FROM employees WHERE salary > 50000; DON'T forget to add semicolon at the end of the query.
27th Jun 2023, 7:12 PM
Kakashi はたけ
Kakashi はたけ - avatar
+ 3
Gül Karahan Can you specify the exact challenge causing the problem so we can find and test it.
28th Jun 2023, 8:56 AM
Rik Wittkopp
Rik Wittkopp - avatar
+ 3
It may have been in the old course which was replaced by the new one. 😁👍
28th Jun 2023, 10:07 AM
Rik Wittkopp
Rik Wittkopp - avatar
+ 3
SELECT * FROM employees ORDER BY salary DESC this working
28th Nov 2023, 8:34 AM
AMIR H R 👑💎🕹📱📡 💪
AMIR  H  R 👑💎🕹📱📡 💪 - avatar
+ 2
Check the table name again., If spelled correctly, may be bug.. then report to SL via info@sololearn.com. A screen shot will be more helpful to find bug... Add clear details....
28th Jun 2023, 3:52 AM
Jayakrishna 🇮🇳
+ 2
When I just tried to continue my course the task wasn't there anymore. So I think they fixed it already. I am sorry for the inconvenience 🙃
28th Jun 2023, 9:59 AM
Gül Karahan
Gül Karahan - avatar
+ 1
But this is exactly what I did. I also filled the blanks with FROM and > but for some reason it said that my FROM is not the correct answer.
27th Jun 2023, 10:58 PM
Gül Karahan
Gül Karahan - avatar
+ 1
I can't change the table name, since I just have two banks to fill. Here is a screenshot for better understanding: https://www.dropbox.com/sh/nk4ao5jqyecwt6i/AABIqNh6bU1-rPJkOwfE8r5ca?dl=0 But thank you for your answer. I will contact the support as you suggested.
28th Jun 2023, 5:52 AM
Gül Karahan
Gül Karahan - avatar
+ 1
I have just encountered this and wasted my cubes trying to solve it. A ";" cannot even be entered, as 50000 is prefilled. Typing "FROM" is what's causing the issue
28th Jun 2023, 1:11 PM
Bert
+ 1
Lol😂
29th Jun 2023, 10:29 AM
Maximus Day
Maximus Day - avatar
0
Make sure you deleted all underscores given as placeholders in the question. Select * from employees where salary>50000;
28th Jun 2023, 12:49 PM
Sudhakara Bathala
0
SELECT * FROM table name WHERE salary>5000
28th Jun 2023, 12:58 PM
Wizard YT
Wizard YT - avatar
0
At which line will this code stop the execution? salary = 50000 role Analyst age -> 29 print(salary)
7th Jun 2024, 11:38 AM
Thunder Coding
Thunder Coding - avatar