193k views
0 votes
For each topic, find the total number of blurts that were analyzed as being related to the topic. Order the result by topic id. Your SQL query should print the topic id, topic description and the corresponding count.user (email, password, name, date_of _birth, address, type) primary keyſemail) celebrity (email, website, kind) primary keyemail) blurt (blurtid, email, textlocation, time) primary keyblurtid,email ) foreign key (email) references user(email) hobby (email, hobby) primary keyſ emailhobb, ) foreign key(email) references user(email) . follow (follower, followee) primary key(follower.followee) foreign key follower) references user(email) foreign keyfollowee) references user(email) vendor (id, name rimary keyid) vendorambassador (vendorid. email) primary keyſvendorid) foreign key(email) references userſ email) foreign keyvendorid) references vendor(id) topic (id, description) primary keyſid) vendor_topics (vendorid, topicid) primary keyvendorid, topicid) foreign keyvendorid) references vendor(id) foreign keytopicid) references topic(id)

User DarioB
by
3.2k points

1 Answer

1 vote

Answer:

Explanation: see attachment below

For each topic, find the total number of blurts that were analyzed as being related-example-1
User LarryBud
by
3.3k points