In Progress

Advanced SQL Skills Needed

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:

[url removed, login to view]

Issues Table:

[url removed, login to view]

Members Table:

[url removed, login to view]

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?

Skills: MySQL, SQL

See more: sql advanced test questions, sql advanced test, sql expert need, sql advanced, sql advanced queries, photoshop skills resume advanced, needed skills, sql advanced stored procedure, electronics engineer needed skills, skills sales marketer need, skills magazine writer need, needed skills agricultural engineering

About the Employer:
( 28 reviews ) Perth, Australia

Project ID: #12202520

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
(1 Review)
2.6

13 freelancers are bidding on average $27 for this job

$30 USD in 2 days
(396 Reviews)
7.7
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
(44 Reviews)
4.9
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
(19 Reviews)
4.6
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
(14 Reviews)
3.8
dekinghtg

A proposal has not yet been provided

$25 USD in 1 day
(6 Reviews)
3.6
jkalivijay

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

$19 USD in 1 day
(1 Review)
2.0
$20 USD in 1 day
(1 Review)
1.3
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
(0 Reviews)
0.0
$31 USD in 1 day
(0 Reviews)
0.0
CleanCoder227

Hi,I'm very very interested in your job. I have many experience on programming. I have done many C/C++/C#/SQL programs and make them on high level. I have enough experience for this job. I can complete your work in More

$25 USD in 1 day
(0 Reviews)
0.0