create database RECETE;
use RECETE;
create table Ingredient_Classes
(
	 Ingred_Class_ID  int not null,
	 Ingred_Class_Description text not null
);

create table Selling
(
	Ingred_ID int not null,
	Ingred_Name text not null,
    Ingred_Class_ID int not null,
	Measure int not null
);


insert into Collaborators values (01, 'Beshieru', 'Moldova','002','0789234756');
insert into Collaborators values (02, 'Cibotari', 'Romania','003','079370878');
insert into Collaborators values (03, 'Caraus', 'Moldova','004','079856734');
insert into Collaborators values (04, 'Rusu', 'Germania','005','068945672');
insert into Collaborators values (05, 'Bolduratu', 'Rusia','006','069345678');
insert into Collaborators values (06, 'Ipati', 'Polonia','007','087956392');

insert into Selling values (1 , 'Tennis' , 01 , '1','200','70');
insert into Selling values (2 , 'Football' , 02 ,'2','250','80' );
insert into Selling values (3 , 'Basketball' , 03, '2','560','90');
insert into Selling values (4 , 'Tennis' , 04 ,'3','789','20' );
insert into Selling values (5 , 'Football' , 05,'2','870','15');
insert into Selling values (6 , 'Football' , 06 , '2','900','20');

select* from Collaborators;
select* from Selling;

select  Coll_Name, Position
from Collaborators;

select Coll_Name,Price,Amount
from Collaborators inner join Selling
on Collaborators.Coll_ID = Selling.Coll_ID;