different monitor ports

A normal query, in which there could be duplicates

A query with DISTINCT where there would not be duplicate data

LENGTH gets the length of a certain string

The TRIP function simply cuts spaces before and after words

Also Cast

Count: as the name itself explains, it counts all the values in a column

Count DISTINCT in the other hand doesn't count the duplicate sets of data

=SumProduct => gets the sum of 2 arrays multiplied together