Problem Statement Query all columns for all American cities in the CITY table with populations larger than 100000 . The CountryCode for America is USA . Video Solution: APPROACH 1. First select all the column 2. Then use two condition a) POPULATION > 100000 b) COUNTRYCODE="USA" MYSQL QUERY select * from city where POPULATION > 100000 and COUNTRYCODE= "USA" ; Explanation 1. select * from city : It is used to select all the column from the table city. 2. where : It is used to describe conditions Thank You For Visiting...💖💖💖
Coder Aryan is a blogging website that provide solution to Coding related problem. Competitive programming solution are also available here.I try to give easy explanation with video solution for all the Coding Questions.Platform Used Are: Hackerrank ,Codechef , Hackerearth , Codeforce , GeekforGeeks.
Comments
Post a Comment