SQL强手进

今天遇到一道题目　　　满是汗水　　　
求助强人！
要求是写SQL，
题目：Creat an over view of the name of the president, the name of his spouse, the age of his spouse at the time of their wedding and the number of children from that marriage, for those marriage in which on average one child was born no more than once every five years, counting from the wedding year until the year in which the spouse was 45.
万分感谢！

麻烦死了 不会有人帮你都写出来的

那给点提示也好啊!

Post by Pierhere;2036188
那给点提示也好啊!

不知道楼主解决了没．我先来凑凑热闹吧．很久没写SQL了，估计有很多错误，就勉强当是提示吧。

SELECT President.name as p_name, President.spouse_name as s_name, DATEDIFF(y, President.spouse_dob, President.marriage_year) as age_wedding, COUNT(Children.father_name)

FROM President, Children

WHERE Children.father_name = p_name AND (SELECT COUNT(Children.father_name) FROM Children) <= ROUND((45-President.marriage_year)/5)

Post by 真的潜水员;2036906
不知道楼主解决了没．我先来凑凑热闹吧．很久没写SQL了，估计有很多错误，就勉强当是提示吧。

SELECT President.name as p_name, President.spouse_name as s_name, DATEDIFF(y, President.spouse_dob, President.marriage_year) as age_wedding, COUNT(Children.father_name)

FROM President, Children

WHERE Children.father_name = p_name AND (SELECT COUNT(Children.father_name) FROM Children) <= ROUND((45-President.marriage_year)/5)

你太有才了！

什么是SQL啊??

Structured Query Language

Post by 刺客;2042632
Structured Query Language

感谢你的回答!!