Query NAME, COUNTRY CODE GREATER THAN 3000

Question

Query the NAME and COUNTRY CODE of CITY Table where ID is greater than 3000

Answer 1

As you said in question that display name and country code greater than 3000 so I write the below query :

Select Name, Country_Code from city where ID > 3000;

Let me know what you think about this query.

Hope this will help.

Answer 2

It would be better if you start learning the course. You will learn a lot of new things.

Anyways this will help.

https://www.sololearn.com/learn/SQL/1856/