Problem 2 Even Fibonacci numbers

Each new term in the Fibonacci sequence is generated by adding the previous two terms. By starting with 1 and 2, the first 10 terms will be:
1, 2, 3, 5, 8, 13, 21, 34, 55, 89, …
By considering the terms in the Fibonacci sequence whose values do not exceed four million, find the sum of the even-valued terms.

阅读全文 »

Problem 6 Sum square difference

The sum of the squares of the first ten natural numbers is:

$$
\large 1^2+2^2+3^2+\cdots+10^2=385
$$

The square of the sum of the first ten natural numbers is:

$$
\large (1+2+3+\cdots+10)^2=55^2=3025
$$

Hence the difference between the sum of the squares of the first ten natural numbers and the square of the sum is:

$$
\large 3025 - 385 = 2640
$$

Find the difference between the sum of the squares of the first one hundred natural numbers and the square of the sum.

阅读全文 »

实验内容

根据数据库 db_student 中的 tb_student 表、tb_scoretb_course,完成下列查询语句

表结构

表结构如下:

  • tb_student(sno,sn,dept,sex,birthday,polity)
  • tb_score(sno,cno,score)
  • tb_cource(cno,cn,ct)
    阅读全文 »