Page 1 of 1
Write the SQL code to determine how many books are in the "Cooking" category. CREATE TABLE Books (ISBN VARCHAR2(10), Tit
Posted: Mon May 09, 2022 7:00 am
by answerhappygod
- Write The Sql Code To Determine How Many Books Are In The Cooking Category Create Table Books Isbn Varchar2 10 Tit 1 (38.94 KiB) Viewed 25 times
Write the SQL code to determine how many books are in the "Cooking" category. CREATE TABLE Books (ISBN VARCHAR2(10), Title VARCHAR2(30), PubDate DATE PubID NUMBER (2) Cost NUMBER (5,2), Retail NUMBER (5,2), Discount NUMBER (4,2), Category VARCHAR2(12), CONSTRAINT books_isbn_pk PRIMARY KEY(isbn), CONSTRAINT books pubid_fk FOREIGN KEY (pubid) REFERENCES publisher (pubid));