Write a few (rather simple) SQL queries

Cancelled Posted 6 years ago Paid on delivery
Cancelled Paid on delivery

For an assignment, answer 5 questions which include writing an optimized query.

You should probably set up a small database for testing, with tables generated with dummy data.

I will test your queries' performance.

Window functions will be required, for that reason please use PostgreSql.

If you know your stuff it probably shouldn't take more than an hour.

Notes:

* Experienced bidders only.

* Highly proficient in English.

* PostgreSql.

Database Administration Database Programming PostgreSQL SQL

Project ID: #15879575

About the project

12 proposals Remote project Active 6 years ago

12 freelancers are bidding on average $30 for this job

bhupen2606

Hi, i have local instance of PostgreSQL and i can create tables and help you with required queries. Please share the table structures and requirements for queries. Thanks. Relevant Skills and Experience SQL, PostgreSQ More

$25 USD in 1 day
(59 Reviews)
5.0
PATechnology

A proposal has not yet been provided

$25 USD in 2 days
(29 Reviews)
4.5
mikenru1

Large experience in software development. 8 years of development airborne and transport control systems. I suggest to discuss your need in chat. Stay tuned, I'm still working on this proposal.

$30 USD in 1 day
(11 Reviews)
3.7
Darwin21015

Hello, how are you, I hope you send me what you need to do to know if I can do this work I have enough knowledge in postgresql Relevant Skills and Experience postgresql , dev sql, triggers , views , procedure stored More

$40 USD in 1 day
(8 Reviews)
3.5
Precious01

Hi, I understand you need 5 questions on SQL answered. I have over 6 years experience using several database applications and I am confident I can answer the questions. Relevant Skills and Experience I am a full stack More

$25 USD in 1 day
(2 Reviews)
1.6
rca5a334afc1b1af

Experienced with SQL using Oracle Relevant Skills and Experience SQL Oracle PostgreSql Proposed Milestones $20 USD - Will Communicate with customer to make sure I get all the details and create the dummy database

$20 USD in 2 days
(0 Reviews)
0.0
saifkhanhakro

20 dollars are fine for this job. Relevant Skills and Experience I know orace sql and mysql very well. I am interested in this field of database alot Proposed Milestones $25 USD - Whole_Project

$25 USD in 1 day
(0 Reviews)
0.0
mehulrastogi87

A proposal has not yet been provided

$30 USD in 1 day
(0 Reviews)
0.0
friendarora

I have a total experience of 13 yrs in the IT industry with exposure to ETL, Data warehouse and Business intelligence - Complex business logic development on Postgres Stay tuned, I'm still working on this proposal.

$25 USD in 1 day
(0 Reviews)
0.0
paruljainsvn49

Hi, I am currently working with PostgreSQL project and It is quit interesting to me. Relevant Skills and Experience PostgreSQL(6 month), SQL(6 month) , Java Stay tuned, I'm still working on this proposal.

$25 USD in 1 day
(0 Reviews)
0.0