Find Jobs
Hire Freelancers

Need help with Postgresql.

$30-250 USD

Fullført
Lagt ut omtrent 4 år siden

$30-250 USD

Betalt ved levering
Your task in this project is to write the following two functions in plpgsql and test them in the NBA-xxxx database: Write a function named fibonacci that, given an integer i (as the 1st and only parameter), returns the i-th Fibonacci number. The valid range of i is [0, 1000] in our project. Note that the first Fibonacci number is F(0) = 0, and we have F(1) = 1, then you can use the formula F(i) = F(i-1) + F(i-2) to get the output for other inputs. If the parameter i is out of range, your function should return -1. Write a function named player_height_rank that, given the first name and last name of a player, return the rank of that player based on his height. Note that the players table stores height information in feet and inches, thus you have to sort the players by total height instead of h_feet or h_inches to get the rank. For a player, his rank is defined as one plus the number of players taller than he is. Players with the exact same height should have the same rank, therefore your function should deal with such ties. Some examples according to the NBA database are: Gheorghe Muresan ranked 1 with a height of 7 feet and 7 inches; Manute Bol ranked 2nd (7 ft. 6 in.); Ming Yao and three others ranked 3rd (7 ft. 5 in.); and five other players with height 7 ft. 4 in. all ranked 7th, etc. If the name given does not match any player in the players table, the function returns 0.
Prosjekt-ID: 24675744

Om prosjektet

7 forslag
Eksternt prosjekt
Aktiv 4 år siden

Ønsker du å tjene penger?

Fordeler med budgivning på Freelancer

Angi budsjettet og tidsrammen
Få betalt for arbeidet ditt
Skisser forslaget ditt
Det er gratis å registrere seg og by på jobber
Tildelt til:
Brukeravatar
Dear, I am a certified professional programmer and I have extensive experience developing in addition to giving classes where I left similar scripts and I know perfectly the solution to fibonacci (I have done it many times) and I know the sql function that is needed to solve your second example, if you like me write and review the details of your project, best regards
$30 USD om 1 dag
5,0 (3 omtaler)
1,2
1,2
7 frilansere byr i gjennomsnitt $134 USD for denne jobben
Brukeravatar
Hello Hope you are doing well. I have 7 years of experience in Linux and PosgreSQL. I can handle this project. Regards VishnuLal*
$250 USD om 1 dag
4,6 (5 omtaler)
4,1
4,1
Brukeravatar
Hi, We are bunch of professionals with extensive experience in Data solutions and management with hands on experience in PostgreSQL. Looking at your requirement we are confident that we can help you. We have bid on lower price to start a healthy relationship so that we can extend our collaboration in future and hence we are willing to negotiate further.
$50 USD om 7 dager
0,0 (0 omtaler)
0,0
0,0
Brukeravatar
Hi , I can help you write these functions on postgresql. I can do both Fibonacci and the players height asap . Contact me if you wanna discuss .
$60 USD om 2 dager
0,0 (0 omtaler)
0,0
0,0
Brukeravatar
Hi I can solve requests(SQL-query) of any complexity and function fibonacci/player_height_rank An expert on database optimization, this is mainly what I’m doing now - more than half the time, reports, setting up indexes, hints, plans. Rewriting queries, partitioning tables, changing the type of tables (from the heap to something else). Mostly optimization of OLTP (fast transactions) systems, less often for DWH (storefronts). About myself: Oracle Senior/PostGre Developer / Database and Performance Architect Architect of information systems and databases, performance analyst. Development and refactoring of SQL, PLSQL code. Optimization of sql queries or locks. 15 years of experience in Oracle, MySQL, MsSQL, PostGre.
$130 USD om 1 dag
0,0 (0 omtaler)
0,0
0,0
Brukeravatar
i can do this, since i have good command over all type of databases,logics, php,java let's connect to have some words on the requirement thanks
$250 USD om 7 dager
0,0 (0 omtaler)
0,0
0,0

Om klienten

UNITED STATESs flagg
Tampa, United States
5,0
1
Betalingsmetode bekreftet
Medlem siden mar. 13, 2020

Klientbekreftelse

Takk! Vi har sendt deg en lenke for at du skal kunne kreve din gratis kreditt.
Noe gikk galt. Vær så snill, prøv på nytt.
Registrerte brukere Publiserte jobber
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Forhåndsvisning innlasting
Tillatelse gitt for geolokalisering.
Påloggingsøkten din er utløpt og du har blitt logget ut. Logg på igjen.