SQL database application that will please the great god help

CodePudding user response:

Is anyone here

CodePudding user response:

The answer to 2.2
SELECT
TIMESTAMPDIFF (DAY, MIN (Todd Harper IREDATE), MAX (Todd Harper IREDATE)) ` differs days `,
TIMESTAMPDIFF (MONTH, MIN (Todd Harper IREDATE), MAX (Todd Harper IREDATE)) ` differ months `,
TIMESTAMPDIFF (YEAR, MIN (Todd Harper IREDATE), MAX (Todd Harper IREDATE)) ` differ years `
FROM the table name t;

CodePudding user response:

Picture is not complete, can you send a complete,

CodePudding user response:

2.1 the answer
SET @ c:=(SELECT COUNT (0) FROM the table name);
The SET @ c1:=FLOOR (@ c/2);
The SET @ c2:=CEIL (@ c/2);
SELECT AVG (t. digital) FROM (
SELECT Numbers, t. @ r:=@ r + 1 r FROM (
SELECT id, @ r:=0 FROM the name of the table WHERE DNAME='Research Institute' ORDER BY id) t) t WHERE t.r BETWEEN @ c1 AND @ c2.

CodePudding user response:

reference 4 floor AHUA1001 response:

the picture is not complete, can you send a complete,

thank you for the great god, the illustration in this way, this is the second interview questions, online to find so

CodePudding user response:

The top of the pen to write content, is what meaning,

CodePudding user response:

refer to 7th floor AHUA1001 response:

the top of the pen to write content, is what meaning,

2 tables and table attribute is that