Advanced SQL Skills Needed

Completed Posted 7 years ago Paid on delivery
Completed Paid on delivery

This should only take 30 minutes for anyone with Advanced SQL skills which is what I am looking for. I have attached a copy of the database.

I am looking to pay $20-$25USD for this project.

I have a database with 3 tables:

Books Table:

[login to view URL]

Issues Table:

[login to view URL]

Members Table:

[login to view URL]

I need the SQL for the following to find out the following:

What book has been issued the most?

What book has been issued more than X amount of times but less than Y amount of times

What is the most popular genre issued?

How many borrowers live in City X and what is the most popular type of book issued by those users?

What is the average amount of books issued between February and September 2016?

MySQL SQL

Project ID: #12202520

About the project

12 proposals Remote project Active 7 years ago

Awarded to:

usman1493

Hey An SQL expert developer is here I have advanced expertise in SQL and database development I can write the database queries for you as per your need I hope to have a conversation with you soon Feel Free to mess More

$20 USD in 0 days
(35 Reviews)
5.2

12 freelancers are bidding on average $26 for this job

mahamadali

I am experienced php developer and web designer with the depth knowledge related to MySQL,MSSQL,JSON,JAVASCRIPT,AJAX,XML,jQuery,CSS,HTML5,Material Designing with the integration of web technologies. I have worked as More

$30 USD in 1 day
(238 Reviews)
7.0
bhawin91

I have got good sql skills , I have done a lot of such projects You can see my rating as well I have total of 3 years of experience in sql

$30 USD in 1 day
(16 Reviews)
3.9
dekinghtg

A proposal has not yet been provided

$25 USD in 1 day
(7 Reviews)
3.8
Meagan26

Hello, I have read through your project and I am incredibly interested in taking on your project. I am an experienced developer with a diploma in the field of web development. i have recently also earned my preferre More

$35 USD in 1 day
(24 Reviews)
5.2
jkalivijay

hi I can easily do this project waiting for your offer to finish within 1hour

$19 USD in 1 day
(15 Reviews)
3.8
gblumetto

A proposal has not yet been provided

$25 USD in 1 day
(0 Reviews)
0.0
rajesh7186

Hello Sir, I will be do this job. if you give me this opportunity than I will start work immediately. let me know if you have any questions Thanks, Rajesh

$25 USD in 0 days
(0 Reviews)
0.0
arifiranda

Hi, SQL is my daily avtivities. he talk details

$30 USD in 1 day
(0 Reviews)
0.0
julius19946

hi there i think i can help you with your project , let's have discussion about the login and access ? btw i am julius HI:)

$25 USD in 1 day
(1 Review)
0.0