Write the SQL code to determine how many books are in the "Cooking" category. CREATE TABLE Books (ISBN VARCHAR2(10), Tit
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
Write the SQL code to determine how many books are in the "Cooking" category. CREATE TABLE Books (ISBN VARCHAR2(10), Tit
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, PublD 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));
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!