/*Select Count(*) as 'Numar carti' from Book INNER JOIN Publisher
ON Book.Code = Publisher.Code
where Publisher.Name='Ion' and Years='1998'

Select IdBook,Title,Price from Book INNER JOIN Publisher
ON Book.Code = Publisher.Code
where Publisher.Name='Ion' and price <= 15

Select IdBook,Title,Price from Book INNER JOIN Publisher
ON Book.Code = Publisher.Code
where Publisher.Name='Ion'

Select NAME,NrEmp from Branches

select IdBook,Title,Type from Book
where type = 'Comedy' or type = 'Casual'  or type = 'SF'

select IdBook,Title,Price from Book
where price > 10 and Paperback='Y'

select IdBook,Title from Book
where type = 'Horror' and price > 15

select IdBook,Title from Book
where type = 'Horror' and price < 20

select IdBook,Title,Price from Book
where price > 30

select IdBook,Title,Price from Book
where price <= 30 and price >= 20

select Title from Book
where Type = 'Comedy' or Book.Code = '4'


select Name from Publisher
where Location!='Craiova'

select Name from Publisher
where Location='Craiova'*/