Dokončeno

Advanced SQL Skills Needed

Tento projekt byl úspěšně realizován uživatelem usman1493 za $20 USD za den.

Získat nabídky zdarma pro podobný projekt
Pracující zaměstnavatel
Rozpočet projektu
$10 - $30 USD
Realizováno za
1 den
Nabídky celkem
14
Popis projektu

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?

Máte zájem si vydělat?

  • Zadejte váš rozpočet a dobu trvání práce
  • Ve zkratce popište svůj návrh
  • Dostaňte za svou práci zaplaceno

Zaměstnejte freelancery, kteří na tento projekt zveřejnili nabídku

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