SQL Database Query

CLOSED
Bids
36
Avg Bid (USD)
$27
Project Budget (USD)
$10 - $30

Project Description:
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.

Skills required:
Data Processing, MySQL
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


Hire DrTech76
$ 40
in 0 days
$ 29
in 3 days
$ 30
in 1 days
$ 35
in 1 days
$ 24
in 3 days
$ 25
in 3 days
$ 30
in 0 days
$ 29
in 0 days
$ 30
in 1 days
$ 30
in 1 days