SQL salery >50000

Question

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.

Answer 1

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.

Answer 2

Gül Karahan
Can you specify the exact challenge causing the problem so we can find and test it.

Answer 3

It may have been in the old course which was replaced by the new one.

😁👍

Answer 4

SELECT *
FROM employees
ORDER BY salary DESC
this working

Answer 5

Check the table name again.,
If spelled correctly, may be bug.. then report to SL via [e-mail].
A screen shot will be more helpful to find bug...
Add clear details....

Answer 6

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 🙃

Answer 7

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.

Answer 8

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.

Answer 9

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

Answer 10

Lol😂

Answer 11

Make sure you deleted all underscores given as placeholders in the question.

Select * from employees where salary>50000;

Answer 12

SELECT * FROM table name WHERE salary>5000

Answer 13

At which line will this code stop the execution?

salary = 50000
role Analyst
age -> 29
print(salary)