Completed

Advanced SQL Skills Needed

This project was successfully completed by usman1493 for $20 USD in a day.

Get free quotes for a project like this
Project Budget
$10 - $30 USD
Completed In
1 day
Total Bids
14
Project Description

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?

Completed by:
Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online