Selesai

Advanced SQL Skills Needed

Proyek ini berhasil diselesaikan oleh usman1493 dengan harga $20 USD dalam sehari.

Dapatkan penawaran gratis untuk proyek seperti ini
Pemberi kerja bekerja
Anggaran Proyek
$10 - $30 USD
Diselesaikan Dalam
1 hari
Total Penawaran
14
Deskripsi Proyek

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?

Ingin menghasilkan uang?

  • Atur anggaran Anda dan jangka waktunya
  • Uraikan proposal Anda
  • Dapatkan bayaran atas pekerjaan Anda

Pekerjakan para freelancer yang juga menawar di proyek ini

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