insert into REGIONS(REGION_ID,NAME)
values (100,'Balkans')

insert into COUNTRIES(COUNTRY_ID,NAME,REGION_ID)
values ('BG', 'Bulgaria',100)

insert into DEPARTMENTS(DEPARTMENT_ID,NAME,COUNTRY_ID,CITY,ADDRESS,POSTAL_CODE)
values(1,'Research','BG','Plovdiv','bul. Bulgaria-236','4000')

select*from DEPARTMENTS

insert into JOBS(JOB_ID,JOB_TITLE,MIN_SALARY,MAX_SALARY)
values('DEV','Developer',8000,15000)

select*from JOBS

insert into EMPLOYEES(EMPLOYEE_ID,FNAME,LNAME,EMAIL,PHONE,HIRE_DATE,JOB_ID,SALARY,DEPARTMENT_ID)
values(1,'Ivan','Ivanov','ivo@abv.bg','+359 8656 656',CONVERT(datetime,'15-10-2019',105),'DEV',12000,1)

select*from EMPLOYEES

insert into CUSTOMERS(CUSTOMER_ID,COUNTRY_ID,FNAME,LNAME,ADDRESS,EMAIL,GENDER)
values(1,'BG','Malinka','Borovinkova','Asenovgrad ul. Trud','malinka@gmail.com','F')

select*from CUSTOMERS

insert into PRODUCTS(PRODUCT_ID,NAME,DESCR,PRICE)
values(1,'Adata','Flash -2GB',30)

select*from PRODUCTS

insert into ORDERS(ORDER_ID,CUSTOMER_ID,EMPLOYEE_ID,ORDER_DATE)
values(1,1,1,convert(datetime,'14-10-2019',105))

select*from ORDERS

insert into ORDER_ITEMS(ORDER_ID,PRODUCT_ID,UNIT_PRICE,QUANTITY)
values(1,1,30,20)

select*from ORDER_ITEMS

UPDATE CUSTOMERS
set LNAME='Kapinka',
	ADDRESS='Plovdiv bul.Ruski'
where customer_id=1

select*from CUSTOMERS

delete from ORDERS

select * from ORDERS

select*from ORDER_ITEMS