/*use pszpak3
CREATE TABLE Pracownicy(
NrPrac INT PRIMARY KEY,
PESEL CHAR(11) UNIQUE NOT NULL,
Nazwisko NVARCHAR(50) NOT NULL,
Imie NVARCHAR(50) NOT NULL,
Stawka MONEY NULL,
[Data urodzenia] DATE,
LiczbaDzieci TINYINT,
Premia DECIMAL(5,3)
)*/


--INSERT INTO Pracownicy
--VALUES(3,'223456','Zielinski','Adam',2200.0,'1989-10-02',1,11.0)

--ALTER TABLE Pracownicy
--ADD CONSTRAINT PK1 PRIMARY KEY(NrPrac)

SELECT * FROM Pracownicy



/*SELECT * FROM Products
WHERE UnitPrice >= 20 AND UnitPrice < 30 */

/*SELECT *
FROM Products
WHERE UnitPrice BETWEEN 20 AND 30*/

/*SELECT * FROM Customers
WHERE Region = NULL*/

/*SELECT *
FROM Customers
WHERE Region IS NOT NULL*/

/*SELECT *
FROM Customers
WHERE NOT Region IS NULL
ORDER BY Country, City*/