Question

Let N be the number of CITY entries in STATION, and let N' be the number of distinct CITY names in STATION; query the value of N-N' from STATION. In other words, find the difference between the total number of CITY entries in the table and the number of distinct CITY entries in the table.

Answer 1

Answer:

As the data given in the table there are some number of cities are entered. Let the number of them is N, now there are some distinct cities also let the number be N'

We need to write the query to find the difference between them

We need to count the number cities and the number of distinct cities using count and distinct count respectively , then we have to subtract them and display them using select command.

Answer 2

Explanation:

50 question the poem creates the same