Some Intresting Simple Query In SQL Server

Some one ask me for Some interesting small query not logical but for some fun.

I said yes sure I have some simple query by this probably wh started SQL Server  will be little bit confuse to answer some of the mention question .I don't tell you the answer please answer all who knows  on comment  . Questions are given below

Sql Server intresting Query

SELECT 15
SELECT $
SELECT COUNT(*)
SELECT COUNT('7')
SELECT 'Code' + 1
SELECT 'Code' + '1'
SELECT (SELECT 'Code')
SELECT SELECT 'Code'
SELECT * FROM 'TableName'
SELECT COUNT(*) + COUNT(*)
SELECT SUM(1+2*3)
SELECT MAX(1+2*3)
SELECT MAX(1,3,4)
SELECT MAX('Cherry')
SELECT COUNT(SELECT columnname FROM TableName)