Revising the Select Query II | Hackerrank SQL Solution

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...💖💖💖  

Comments

HackerRank SQL | Revising the Select Query I | codewitharyan

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...💖💖💖

Geeksforgeeks | Practice | Learn to Comment

Learn to comment Code: void comment ( int a , int b , int c ) { cout << a << endl ; //cout<<b<<endl; cout << c << endl ; } Input: a = 5 b = 6 c = 15 Output: 5 15

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" ; ...

Coder Aryan

Search This Blog