@@@@


Query a list of CITY names from STATION for cities that have an even ID number. Print the results in any order, but exclude duplicates from the answer.

== SELECT DISTINCT CITY FROM STATION 

     WHERE MOD(ID,2)=0;


Find the difference between the total number of CITY entries in the table and the number of distinct CITY entries in the table.


=SELECT COUNT(*) - COUNT(DISTINCT CITY) AS DIFFERENCE FROM STATION;

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