ISNULL([Color], 'zamieniona wartosc ')
DISCENT
CONCAT_WS('!! SEPARATOR !! ', [ProductNumber] , [Color]) AS lool

________
SELECT [Name], [ListPrice],
    CASE
        WHEN [ListPrice] < 50 THEN 'Cheap'
        WHEN [ListPrice] < 500 THEN 'Medium'
        ELSE 'Hight'
    END AS PriceBinned
FROM [SalesLT].[Product]

_______________

SELECT [Name], [ListPrice], [ProductCategoryID],
    CASE
        WHEN [ProductCategoryID] < 10 THEN ROUND([ListPrice] * 1.10, 2)
        WHEN [ProductCategoryID] < 20 THEN ROUND([ListPrice] * 1.20, 2)
        ELSE ROUND([ListPrice] * 1.30, 2)
    END AS BruttoPrice

FROM [SalesLT].[Product]

________________________
SELECT [Name], [SellStartDate]
FROM [SalesLT].[Product]
WHERE [SellStartDate] > '2007-06-01'

___________________
PRZEDZIALY

SELECT [Name], [ListPrice]
FROM [SalesLT].[Product]
WHERE [ListPrice] BETWEEN 100 AND 300

______________________________

SELECT [Name], [ListPrice]
FROM [SalesLT].[Product]
WHERE [Color] IN ('Black', 'White');

______________________


LIKE - szukanie wedlug wzorca
% - dowolny ciag znakow
_ - dowolny znak
RIGHT([NazwaKol], ile_literek osatnich_od_prawej)
RIGHT([FirstName], 1)

SELECT [FirstName], RIGHT([FirstName], 1)
FROM [SalesLT].[Customer]
WHERE [FirstName] LIKE ('_a%a')


_________________________
ALGEBRA BOOL'a

T NOT -> F
TT AND -> T
FF OR -> F

select *
FROM [SalesLT].[Product]
WHERE [Size] = 'M' AND
[Color] in('Black', 'White', 'Red')
AND [Name] like '%Gloves%'

select *
FROM [SalesLT].[Product]
WHERE [SellEndDate] is NOT NULL

___________
top 1 -> pierwszy wiersz z gory

top 2 with ties -> pokaz wszystkie  z powtorzeniem
select top 1 with ties [Name], [ListPrice]
FROM [SalesLT].[Product]
ORDER BY [ListPrice] desc;

____________________

SELECT [Name], [ListPrice], [Color]
FROM [SalesLT].[Product]
WHERE [ListPrice] between 100 AND 1000
AND [Color] in ('Black', 'White', 'Red')
ORDER BY [ListPrice] asc, [ProductID]
OFFSET 24 rows
FETCH NEXT 25 rows only;