Discussion on Revising the Select Query I Challenge

Sort 571 Discussions, By:

2 days ago+ 0 comments

SELECT  *
FROM CITY
WHERE (POPULATION > 100000) AND (COUNTRYCODE = 'USA')

2 days ago+ 0 comments

Oracle

SELECT *
FROM CITY
WHERE CountryCode ='USA'
AND Population>100000;

4 days ago+ 0 comments

select * from city where population>100000 and countrycode='USA';

6 days ago+ 0 comments

MYSQL SOLUTION

SELECT ID, NAME, COUNTRYCODE, DISTRICT, POPULATION FROM CITY WHERE POPULATION > 100000 AND COUNTRYCODE = 'USA'

SELECT * FROM CITY WHERE POPULATION > 100000 AND COUNTRYCODE = 'USA'

1 week ago+ 0 comments

MySQL:

Select * From CITY Where POPULATION > 10000 And COUNTRYCODE = "USA";