Coder Aryan

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

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

Compare the Triplets Alice and Bob each created one problem for HackerRank. A reviewer rates the two challenges, awarding points on a scale from  1   to   100   for three categories:   problem clarity ,   originality , and   difficulty . The rating for Alice's challenge is the triplet  a = (a[0], a[1], a[2]) , and the rating for Bob's challenge is the triplet  b = (b[0], b[1], b[2]) . The task is to find their  comparison points  by comparing  a[0]  with  b[0] ,  a[1]  with  b[1] , and  a[2]  with  b[2] . If  a[i] > b[i] , then Alice is awarded  1  point. If  a[i] < b[i] , then Bob is awarded  1  point. If  a[i] = b[i] , then neither person receives a point. Comparison points is the total points a person earned. Given  a  and  b , determine their respective comparison points Sample Input: 5 6 7 3 6 10 Sample Output: 1 1 CODE: #includ...

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

Solve Me First Complete the function S olveMeFirst  to compute the sum of two integers. Complete the  SolveMeFirst  function in the editor below. SolveMeFirst  has the following parameters: int a : the first value int b : the second value Sample Input a=3 b=2 Sample Output 5 CODE: #include   < cmath > #include   < cstdio > #include   < vector > #include   < iostream > #include   < algorithm > using   namespace  std; int  solveMeFirst( int  a,  int  b) {      // Hint: Type return a+b; below      return  a+b; } int  main() {      int  num1, num2;      int  sum;     cin>>num1>>num2;     sum = solveMeFirst(num1,num2);     cout<<sum;      return...