Zad. 1
SELECT
orderid
FROM
Orders
where
freight
between
20
and
70
order
by
freight
zad. 2
SELECT
ProductName
as
'Nazwa produktu'
,
UnitPrice
as
'Cena w EUR'
,
UnitPrice
*
1.37
as
'Cena w USD'
FROM
Products
zad. 3
SELECT
*
FROM
Employees
WHERE
LastName
not
like
'K%'
1.
SELECT
CustomerID
,
City
,
Fax
FROM
Customers
WHERE
(
City
like
'London'
or
City
like
'Paris'
)and
Fax
is
not
null
2.
SELECT
CustomerID
+
' '
+
City
+
' '
+
Address
+
' '
+
PostalCode
FROM
Customers
ORDER
BY
City
3.
SELECT
*
FROM
Customers
WHERE
Country
in
(
'Italy'
,
'Germany'
,
'France'
,
'Spain'
)
4.
SELECT
*
FROM
Customers
WHERE
ContactTitle
like
'sales representative'
and
City
like
'London'
or
ContactTitle
like
'Sales agent'
and
City
like
'Buenos Aires'
5.
SELECT
*
FROM
Customers
WHERE
(
City
like
'London'
or
City
like
'Buenos Aires'
)and
(
ContactTitle
like
'sales representative'
or
ContactTitle
like
'Sales agent'
)
6. Wyświetl wszystkie zamówienia, które zostały zrealizowane na czas
SELECT
*
FROM
Orders
WHERE
ShippedDate
<=
RequiredDate
7. Wyświetl wszystkie spóźnione zamówienia oraz liczbę dni, o jakie były spóźnione
w kolejności od najbardziej spóźnionych
SELECT
*,
CAST
(
ShippedDate
-
RequiredDate
AS
INT
)
’opoznienie’
