About this question
I am currently working for an online bookstore that wants to analyze the popularity of book genres among their clients or customers. For this, I have a table of databases whose name is “Books” I which have columns like “BookID”, “Title”, ”Genre”, and “keyword”. How can I write an SQL query to calculate the percentage of books in each genre or category that contains a specific keyword? Here is the table structure given of the table “Books”
CREATE TABLE Books (
BookID INT,
Title VARCHAR(100),
Genre VARCHAR(50),
Keywords VARCHAR(200)
);
I want to write an SQL query for finding the percentage of books in each category or genre that contains keywords like “technology.”
Level up your career with Online SQL Server course! Start your journey to success today. Enroll now and unleash your full potential!
