Databse SQL(POSTGRESQL) Introductory University Homework (Need good quality SQL with indentation & efficient) Super Urgent!!

Completed Posted Feb 22, 2014 Paid on delivery
Completed Paid on delivery

FIXED PRICE!!!!! 50 USD!!! with in 5 Hour!!!

6 questions:

Example:

schema:

person(father) fk -> person(name)

person(mother) fk -> person(name)

person

name gender dob dod father mother born in

Alice F 1885-02-25 1969-12-05 null null Windsor

Andrew M 1960-02-19 null Philip Elizabeth II London

..

...

..

Question1:

Write an SQL query that returns the scheme (name,father,mother) ordered by name containing

the name of all people known to have died before both their father and mother, together

with the name of the mother and the name of the father.

PostgreSQL SQL

Project ID: #5473582

About the project

5 proposals Remote project Active Feb 22, 2014

Awarded to:

mchanya

Hi, I'm very interested helping you creating and designing your database, I have more then 7 years of experience in SQL and database administration, modeling, optimizing and manipulating. I've checked your requirement More

$50 USD in 1 day
(4 Reviews)
2.0

5 freelancers are bidding on average $87 for this job

elboukharimu

Aucune proposition n'a encore été fournie.

$50 USD in 0 days
(18 Reviews)
4.7
ssurfer

Hi, i can help you with this. Let me know if you are interested. Can start right away. Regards, Pratik

$138 USD in 1 day
(0 Reviews)
0.0
genius1990

Hi, I am Moeen, I have 2 year experience in java ,C++, SQL programming. I have done similar projects before. I have gone through your requirements and I can assure you that I will be able to complete this project on ti More

$40 USD in 0 days
(0 Reviews)
0.0