Write a SQL query which will give the top 10 results (aggregated) from this data
$30-250 USD
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.
ID dự án: #13395633
Về dự án
Được trao cho:
Hi, it is a simple query joining all your tables with filtering, grouping and sorting. May I help you out? Max
24 freelancer chào giá trung bình$103 cho công việc này
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,
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
Hello, I'm interested to work on this. I gone through the details. let me know if you are interested. Thanks, Sheik
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
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
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
You'll get the undivided attention of a highly experienced four men team. We are looking forward to working with you.
solid experience in database programming. sql, t-sql, triggers, Marco, stored procedures, etc.
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
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