create database dbBooks on
(name = 'Books',
filename = 'D:\PCC\student.mdf'
)
use dbBooks


create table BRANCH
(id_brench char (8) primary key,
nume varchar(10),
oras varchar(10),
id_pub char(8))


create table PUBLISHER
(ID char (8) primary key,
nume varchar(10))


create table AUTHOR
(CNP char (10) primary key,
nume varchar(10),
prenume varchar(10))



create table BOOK
(IBAN char (8) primary key,
titlu varchar(10),
PAPERBACK char(3) NOT NULL DEFAULT('YES'),
CONSTRAINT PAPERBACK CHECK(PAPERBACK IN ('YES','NO')))



create table WROTE
(CNP char (10) primary key,
IBAN char(8))


create table INVENTORY
(IBAN char(8),
id char (8) primary key,
nr_exemplare varchar(10))

8. SELECT PUBLISHER.nume
FROM BRANCH, PUBLISHER
where PUBLISHER.ID = BRANCH.id_pub AND BRANCH.oras = 'NEW YORK'

9. SELECT PUBLISHER.nume
FROM BRANCH, PUBLISHER
where PUBLISHER.ID = BRANCH.id_pub AND BRANCH.oras != 'NEW YORK'

10. SELECT BOOK.IBAN, BOOK.titlu


11. SELECT BOOK.IBAN, BOOK.titlu, BOOK.price
from BOOK
where BOOK.price



17. How many employees does the books store have?

SELECT COUNT(CNP)
FROM AUTHOR


18. For each book published by Tor Books, list the book code, book title, and price.

SELECT BOOK.IBAN, BOOK.titlu, BOOK.price
from BOOK,PUBLISHER,INVENTORY,BRANCH
where BOOK.IBAN = INVENTORY.IBAN AND INVENTORY.id = BRANCH.id_brench AND BRANCH.id_pub = PUBLISHER.ID AND PUBLISHER.nume = 'Tor Books'