@@@@


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

C Program to Sort Id, Name, Address of Student using structure.

 Structure Programm *Program with POINTER* #include<stdio.h> #include<conio.h> #include<stdlib.h> #include<string.h> struct student{ int id; char name[20]; char address[20]; }s1[10],*p; int main() { int i,j,temp,n; printf("Enter the n items \n"); scanf("%d",&n); char tempchar[50],tempchar1[50]; printf("Enter the id name and address of 5 students\n"); for(p=s1;p<s1+n;++p) { scanf("%d %s %s",&p->id,p->name,p->address); } p=s1; for(i=0;i<n;++i){ for(j=i+1;j<n;++j){ if(strcmp((p+i)->name,(p+j)->name)<0) { strcpy(tempchar,(p+i)->name); strcpy((p+i)->name,(p+j)->name); strcpy((p+j)->name,tempchar); strcpy(tempchar1,(p+i)->address); strcpy((p+i)->address,(p+j)->address); strcpy((p+j)->address,tempchar1);         temp=(p+i)->id;         (p+i)->id=(p+j)->id;   ...
Read more
 Data Types of Python : There are several types of Built-in data types in Python. 1. Numeric Type :  Numeric types include integers, floats, and complex numbers. Integers are whole numbers, floats are decimal numbers, and complex numbers are numbers with a real and imaginary part. 2. Boolean Type :  The Boolean type represents truth values, which can be either True or False. 3. Sequence Types  Sequence types include strings, lists, and tuples. Strings are sequences of characters, while lists and tuples are sequences of values of any data type. 4. Mapping Type  The mapping type is represented by dictionaries, which are collections of key-value pairs. 5. Set Types Set types include sets and frozensets. Sets are unordered collections of unique values, while frozensets are immutable sets. Small Code related to Data Types is below : # Numeric Types my_int = 42 my_float = 3.14 my_complex = 2 + 3j # Boolean Type my_bool = True # Sequence Types my_string = "Hello, Wo...
Read more