Find Jobs
Hire Freelancers

55048 Need Oracle SQL advice

N/A

Opravljeno
Objavljeno pred približno 19 leti

N/A

Plačilo ob dostavi
I actually need someone who is experienced in Oracle SQL/iSQL so I can get some help with some homework problems. I want an expert's answers to all my questions so I can match them to mine. Here are the questions and I will attach the SQL file to this project so you can execute it. 1. What books did the author who sold the most books write? 2. What were the names of people who got a book cover with their orders? 3. List all the customer names and the names of people who referred them, if they were referred. Put in “not referred” if the customer was not referred. 4. What were the names of the books that were sent to the state that received the most books? 5. What author made the most profit? 6. What was the profit made on each of the books that the author in #5 sold? 7. What are the names of the books and author's names of the books with multiple authors? 8. Which customer (name, please) placed the most orders, and what did he order? 9. Did any customers ship the books to an address that they don't live at? 10. Which customer made the most profit for the company? Contact me on PMB for questions.
ID projekta: 1803983

Več o projektu

1 ponudba
Projekt na daljavo
Aktivno pred 12 leti

Želite zaslužiti?

Prednosti oddajanja ponudb na Freelancerju

Nastavite svoj proračun in časovni okvir
Prejmite plačilo za svoje delo
Povzetek predloga
Registracija in oddajanje ponudb sta brezplačna
Dodeljeno:
Avatar uporabnika
Hello, it's an easy homework once you know SQL. Payment via ScriptLance Escrow.
$20 USD v 1 dnevu
0,0 (0 ocen)
0,0
0,0

O stranki

Zastava UNITED STATES
Norfolk, United States
4,6
62
Plačilna metoda je verificirana
Član(ica) od nov. 2, 2004

Verifikacija stranke

Hvala! Po e-pošti smo vam poslali povezavo za prevzem brezplačnega dobropisa.
Pri pošiljanju vašega e-sporočila je šlo nekaj narobe. Poskusite znova.
Registrirani uporabniki Skupaj objavljenih del
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Nalaganje predogleda
Geolociranje je bilo dovoljeno.
Vaša prijavna seja je potekla, zato ste bili odjavljeni. Prosimo, da se znova prijavite.