Encerrado

SQL Database Query

I have an SQL database of textbooks that I need help with. The database has the following tables:

textbook

course_to_textbook

course

department_to_course

department

university

I need help with queries that would allow me to do things like:

find out the top 10 most used biology books;

how many schools are using a certain book;

The top 10 books in use

The structure of this database looks like this:

One to Many Relationships

===============================

state_province ==> university ==> department

Each department is affiliated with a university.

Each university is affiliated with a state_province.

Many to Many Relationships

===============================

course <==> textbook

course <==> department

Each course has one or more textbooks while each textbook is in one or more courses.

Each course is taught at one or more departments while each department has one or more courses.

All the relationships are maintained by the id field of each entity.

For example, there are 381 different biology courses in the course table if you search title by '%biology%'. And then you can find thousands of biology books. For any of them, to find the number of universities that are using it, you need a query that's concerning 6 tables:

textbook

course_to_textbook

course

department_to_course

department

university

Which eventually lead to the university table. I need someone who can write such a query.

Habilidades: Processamento de dados, MySQL

Ver mais: top query, structure books, data structure books, data structure book, books data structure, book data structure, query table, university database department, number book database, sql different, mysql number sql, university database tables, write sql queries, mysql search database table, 2013 query, queries sql, table university database, database university, database tables university, sql query help, tables university database, database Table Structure

Acerca do Empregador:
( 12 comentários ) Atlanta, United States

ID do Projeto: #5130179

34 freelancers estão ofertando em média $26 para este trabalho

DrTech76

Hello there! Your price range does not in any way correspond to teh complexity of the task. With that being said, what is the exact type of the database in use (you say it's SQL, but list it under mySql), as the SQL Mais

$40 USD in 0 dias
(104 Comentários)
6.0
abhius

Hello Sir, I have completely understood your requirements. Assure you fast turnaround. Can do it now! regards, abhi

$29 USD in 3 dias
(33 Comentários)
5.5
chitta

Hi, Chitta here to help you having more than 13 years of working experience in php/mysql. I can do it for you in a day. No wastage of time. Thanks

$30 USD em 1 dia
(15 Comentários)
5.1
pivn

Let expert do this Hi sir, I did many project like this. I can help you get A grade. Plz have a look my profile and let me do this https://www.freelancer.com/u/pivn.html Thanks

$35 USD em 1 dia
(40 Comentários)
4.9
tlchung

mysql developer here, i can write the query for you. mysql developer here, i can write the query for you. mysql developer here, i can write the query for you. mysql developer here, i can write the query for you. mysql Mais

$24 USD in 3 dias
(30 Comentários)
4.4
yubor

Hi. I have 15+ years xp in development of database applications and have expert-level certification. Regards, Yuri.

$25 USD in 3 dias
(29 Comentários)
4.4
it2051229

Hi, I am placing my bid on your project because I have read the requirements and I am confident enough with my Database and SQL skills. I am focused mostly on doing computer science homework here in freelancer.com and Mais

$30 USD in 0 dias
(21 Comentários)
4.3
elboukharimu

Hi, I'm very interested helping you creating your SQL, I have years of experience in SQL and database administration, modeling, and manipulating, please do not hesitate to check my portfolio, there is some samples of d Mais

$29 USD in 0 dias
(10 Comentários)
3.8
rbssolution

Dear Sir, I am having 5+ years of experience in .Net and SQL Server and can write the queries as mentioned by you in the project with ease. Do you want only 3 queries as mentioned in the project description or th Mais

$30 USD em 1 dia
(3 Comentários)
3.4
mail2vimalarora

Hi.. I am working professionally on database and can provide you the queries required as mentioned in the project. Have done work on MYSQL database and feel comfortable in completing your project well in time. Waiting Mais

$30 USD em 1 dia
(1 Comentário)
1.6
emmett25ro

Hello, I have been working with SQL queries for 4 years, if you can give me the structure of the tables involved, I'm sure I can help you with your queries. Best regards, Alex

$20 USD in 2 dias
(1 Comentário)
1.4
bhavinjani

I am submitting herewith my proposal for your perusal and favorable consideration for the said project I would appreciate the chance to discuss with you as to how I could be a vital part of your posted project Your Mais

$25 USD in 2 dias
(1 Comentário)
1.0
marrock

Hi, I am a software engineer and have been working on front end development for more than 3 years. I have good experience in writing sql queries. The query you want in pretty straight forward. I can send you the quer Mais

$20 USD em 1 dia
(1 Comentário)
0.9
truongnguyen86

hi sir, i'm expert in oracle, sql server, my sql. I have done similar projects before, good services is my goal to achieve. Pls check my porfolio for the job i have done, if you still need another sample, i can show yo Mais

$25 USD em 1 dia
(1 Comentário)
1.0
anigre

A proposal has not yet been provided

$25 USD in 3 dias
(0 Comentários)
0.0
Mulder1

Hi! I have a large experience in Mysql and general SQL and know how to optimize queries. I am new here on freelancer, so I want to gain reputation and get a good opinion from you.

$26 USD in 3 dias
(0 Comentários)
0.0
tretanz

Hi, We are ready to start now. we have team of developer that can help you. you can check our profile www.tretanz.com thanks

$25 USD in 0 dias
(0 Comentários)
0.0
pasanbagya

A proposal has not yet been provided

$25 USD in 3 dias
(0 Comentários)
0.0
rob9095

Hello, I am a professional DBA and database designer I have a degree in information systems management and have taken many courses related to database design and management. I believe I can write that query for you ver Mais

$15 USD em 1 dia
(0 Comentários)
0.0
CodePunisher

Dear Sir/Madam I am a database expert and therefore I am confident I can assist you in this exercise. Please provide me with the following further information. 1. The type of database your information is store Mais

$30 USD em 1 dia
(0 Comentários)
0.0