Write a SQL query which will give the top 10 results (aggregated) from this data

Đã hoàn thành Đã đăng vào 7 năm trước Thanh toán khi bàn giao
Đã hoàn thành Thanh toán khi bàn giao

- Website has a URL, Category and Text

- URL has a Website

- Text has Keywords and a URL

- Keywords

I want the top 10 Keywords by Category.

This is the DB structure:

Website:

ID

Domain (text)

Categories (Many-to-Many via WebsiteCategories) // note in practice a website will only have one category, but it's still a many-to-many relationship

WebsiteCategories:

Website (FK)

Category (FK)

Category:

ID

Category (text)

Url:

ID

Url (text)

Website (FK)

Text:

ID

Text (text)

Keywords (Many-to-Many via TextKeywords)

Urls (Many-to-Many on Url)

TextKeywords:

Text (FK)

Keyword (FK)

Keyword:

ID

Keyword (text)

So you can see the route from Keyword to Category looks like this:

Keyword -> TextKeywords -> Text -> Url -> Website -> WebsiteCategories -> Category

I want you to give me something like this:

Let's imagine the category is 2.

Keyword ---- Count

Keyword1 ---- 560

Keyword2 ---- 400

Keyword3 ---- 390

Keyword4 ---- 350

Keyword5 ---- 320

Keyword6 ---- 210

Keyword7 ---- 90

Keyword8 ---- 60

Keyword9 ---- 55

Keyword10 ---- 10

So as you can see, you are listing the keyword frequency by category, sorted by most frequent descending.

Any questions, just ask.

SQL

ID dự án: #13395633

Về dự án

24 đề xuất Dự án từ xa 7 năm trước đang mở

Được trao cho:

maxibrain

Hi, it is a simple query joining all your tables with filtering, grouping and sorting. May I help you out? Max

$45 USD trong 1 ngày
(7 Đánh Giá)
5.8

24 freelancer chào giá trung bình$103 cho công việc này

admin845

Hi, I am a 10+ years exp SQL developer. I can do this in couple of hours. Looking forward to work on this project. Regards,

$50 USD trong 1 ngày
(22 Nhận xét)
6.1
jagdishbhatt38

I have more than 7 years of experience in IT industry.I have worked on .net(c#net,vb.net,asp,asp.net,mvc) with SQLSERVER 2005/2008/2012/2014/2016 and ORACLE(pl/sql).I can provide you best solution. Awaiting for you Thêm

$177 USD trong 5 ngày
(29 Nhận xét)
4.9
sheikDev

Hello, I'm interested to work on this. I gone through the details. let me know if you are interested. Thanks, Sheik

$80 USD trong 3 ngày
(10 Nhận xét)
3.7
pramsweety

Dear Sir, Thank you for providing me this opportunity and explaining it clearly. The requirement is pretty clear. I will either use a multi join statement or sub queries to obtain the final result. I have writin Thêm

$155 USD trong 3 ngày
(6 Nhận xét)
3.0
angnut

hi, i am sql developer. i am available to produce the sql query in 1 day. have a nice day

$61 USD trong 1 ngày
(5 Nhận xét)
3.0
HealthyCoder

Good Morning Mr. Being a Software Engineer i can do your job easily, i have about 5 years experience with Programming so i can do your job easily. Contact me for more detail conversation about your rpoject. Regards Thêm

$50 USD trong 1 ngày
(3 Nhận xét)
2.8
KothariNeha

I will provide you service and maintenance also even after completion of the work with 100% satisfaction. I'm not just looking for money OR one project, as I firmly believe in long term business relationships. For Thêm

$88 USD trong 3 ngày
(0 Nhận xét)
0.0
DevITsarajevo

You'll get the undivided attention of a highly experienced four men team. We are looking forward to working with you.

$35 USD trong 2 ngày
(0 Nhận xét)
0.0
nagabharatc

i have experience in managing SQL and nosql databases

$56 USD trong 2 ngày
(0 Nhận xét)
0.0
jainarayan1023

solid experience in database programming. sql, t-sql, triggers, Marco, stored procedures, etc.

$88 USD trong 2 ngày
(0 Nhận xét)
0.0
meandcloud

Meandcloud Digital Pvt Ltd provides services in web apps and mobile apps from 8 years. We are expertise in mobile sites,eCommerce,b2b,b2c sites,Api Integration,online payment integration,android & ios apps too from 8 Thêm

$30 USD trong 3 ngày
(0 Nhận xét)
0.0
artifexonline

Hi, I have reviewed your requirement and I can do this job as per your requirement. We have huge expertise in WORDPRESS , Laravel, Node.Js , React.Js, CakePHP, Codeigniter, Angular.js, Bootstrap, API Integration, P Thêm

$277 USD trong 3 ngày
(0 Nhận xét)
0.0
fabianrussell

A proposal has not yet been provided

$133 USD trong 3 ngày
(0 Nhận xét)
0.0