Find Jobs
Hire Freelancers

Need help with Postgresql.

$30-250 USD

완료함
게시됨 약 4년 전

$30-250 USD

제출할때 지불됩니다
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.
프로젝트 ID: 24675744

프로젝트 정보

7 제안서
원격근무 프로젝트
활동 중 4년 전

돈을 좀 벌 생각이십니까?

프리랜서 입찰의 이점

예산 및 기간 설정
작업 결과에 대한 급여 수급
제안의 개요를 자세히 쓰세요
무료로 프로젝트에 신청하고 입찰할 수 있습니다
프로젝트를 수여된 사용자:
사용자 아바타
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 1일에
5.0 (3 건의 리뷰)
1.2
1.2
7 이 프로젝트에 프리랜서들의 평균 입찰은 $134 USD입니다.
사용자 아바타
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 1일에
4.6 (5 건의 리뷰)
4.1
4.1
사용자 아바타
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 7일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
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 2일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
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 1일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
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 7일에
0.0 (0 건의 리뷰)
0.0
0.0

고객에 대한 정보

국기 (UNITED STATES)
Tampa, United States
5.0
1
결제 수단 확인
3월 13, 2020부터 회원입니다

고객 확인

감사합니다! 무료 크레딧을 신청할 수 있는 링크를 이메일로 보내드렸습니다.
이메일을 보내는 동안 문제가 발생했습니다. 다시 시도해 주세요.
등록 사용자 전체 등록 건수(일자리)
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
미리 보기 화면을 준비 중...
위치 정보 관련 접근권이 허용되었습니다.
고객님의 로그인 세션이 만료되어, 자동으로 로그아웃 처리가 되었습니다. 다시 로그인하여 주십시오.