-- create צור טבלה
CREATE TABLE book (
  KodBook int primary key (KodBook) not null,
  Category varchar(50), 
  price int
);

-- insert הכנס נתנונים לטבלה
insert into BOOK (KodBook,Category,price) VALUES (111,'anima','');
insert into BOOK (KodBook,Category,price) VALUES (112,'crime',26);
insert into BOOK (KodBook,Category,price) VALUES (113,'kids',27);
insert into BOOK (KodBook,Category,price) VALUES (114,'comix','');
insert into BOOK (KodBook,Category,price) VALUES (115,'crime',29);
-- fetch הצג טבלה שלמה
select top 1 * from BOOK
where Category='crime'
order by price desc
by