Select SQL

 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:





SELECT NAME 
FROM CITY 
WHERE Population > 120000 AND CountryCode = 'USA';


Comments

Post a Comment

Popular posts from this blog

Python else if condition  n = int ( input () . strip ()) check = { True : "Not Weird" , False : "Weird" } print ( check [ n % 2 == 0 and ( n in range ( 2 , 6 ) or n > 20 ) ])
Read more

About RAM

Image
 RAM. About RAM  RAM stand's for Random Access Memory. RAM is type of Memory device which holds programs or instructions which is going to be executed. So we  say that RAM is a primary memory which stores currently running programs . Some features of RAM are as Follows:: --RAM is a volatile memory  --It is expensive memory device.  --We read and write data instructions in RAM. --High speed memory Types of RAM are ::: 1. Static RAM (SRAM)  2. Dynamic RAM (DRAM) Pic of RAM given below.... Pic: RAM  from:google.com
Read more

Class and object in c++

 Program in Class and Object: #include   < cmath > #include   < cstdio > #include   < vector > #include   < iostream > #include   < algorithm > #include   < cassert > using   namespace   std ; // Write your Student class here class   Student   {      private :      int   score [ 5 ];           public :      void   input ()      {        for ( int   i = 0 ; i < 5 ;++ i )        {            cin >> score [ i ];        }         }      int   calculateTotalScore ()      {          int ...
Read more