@@@@


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

Data Types in C

 Data Types in C Programming language..  Mainly we use  3 types of data types  in C Language Integers data type Floating point data type Character data type Integer data types : The positive and negative value from the range of (-32,768 to 32,767) is include by the Integer data type. Example: int = 23;  Floating point data types: The data types which hold decimal numbers is Floating point data. Example: float = 23.54; Character data type: Single word or single character is used inside character data type. For working with large character or sentences we use String function. The range of character data type is from -128 to 127. Above range is based of ASCII which is corresponding to char, special symbol values. Always use Quotes mark to use character. Example: char = "a"; Let's see one example based on data types:: #include<stdio.h> #include<conio.h> void main() { int a,b; float c; char s; printf("Enter some character"); scanf("%s",&s);...
Read more