Skip to main content

Revising the Select Query II | Hackerrank SQL Solution | MYSQL


 Problem Statement

Query the NAME field for all American cities in the CITY table with populations larger than 120000. The CountryCode for America is USA.

The CITY table is described as follows:.

                                   Video Solution:



APPROACH

1. First select name column
2. Then use two condition
a) POPULATION > 120000
b) COUNTRYCODE="USA"



MYSQL QUERY
select name from city
where POPULATION > 120000 and  COUNTRYCODE="USA" ;

Explanation
1. select name 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...💖💖💖
Labels:

Comments

Post a Comment

Popular posts from this blog

CodeChef | Practice | Credits C++ Solution by Aryan Bhan

  Credits  In Uttu's college, a semester is said to be a: Overload  semester if the number of credits taken  > 65 > 65 . Underload  semester if the number of credits taken  < 35 < 35 . Normal  semester otherwise Given the number of credits  X X  taken by Uttu, determine whether the semester is  Overload ,  Underload  or  Normal . Code: #include <bits/stdc++.h> using namespace std ; int main () {     ios_base :: sync_with_stdio ( false );     cin . ignore ( NULL );     int t ;     cin >> t ;     while ( t --)     {         int x ;         cin >> x ;         if ( x < 35 )             cout << "Underload" ;         else if ( x > 65 )             cout << "Overload" ;   ...
1 comment
Read more

Simple Array Sum | Hackerrank Problem Solving Algorithm by Aryan

Simple Array Sum Given an array of integers, find the sum of its elements. Function Description Complete the  simpleArraySum  function in the editor below. It must return the sum of the array elements as an integer. simpleArraySum has the following parameter(s): ar : an array of integers Sample Input: 5 1 2 3 4 5 Sample Output 15 Explanation 1+2+3+4+5=15 CODE #include   < bits/stdc++.h > using   namespace  std; string ltrim( const  string &); string rtrim( const  string &); vector<string> split( const  string &); /*  * Complete the 'simpleArraySum' function below.  *  * The function is expected to return an INTEGER.  * The function accepts INTEGER_ARRAY ar as parameter.  */ int  simpleArraySum(vector< int > ar) {      int  sum...
Post a Comment
Read more